How to access remote mysql server using local phpmyadmin

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL or MariaDBwith the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables,fields or rows; executing SQL statements; or managing users and permissions. source: wikipedia

To access remote mysql database from your local phpmyadmin, open config.inc.php file by

Add following line

You can refer this article to install phpmyadmin on Ubuntu: http://devendraverma.com/install-phpmyadmin-on-ubuntu/

Android Splash Screen

To add Splash Screen to you android application


Splashscreen.java

AndroidManifest.xml

 

activity_splash.xml

Output

laterbox_splash_screen

 

 

Deploy WordPress button is disabled in Google Cloud Launcher

Google Cloud WordPress Launcher Screen

In order to use Click to Deploy with Google Compute Engine you need to make sure “Google Cloud Deployment Manager API” is enabled on your project. You can enable this API from Developer console->APIs page.

Google Cloud API Manager Screen

Moreover, if you have multiple accounts added in your browser try using Chrome Incognito tab to login in order to make sure your email has the right permissions.

Remove # from url in Angular JS and Laravel 5

To remove # from Angular JS application built with Laravel , add following line in your config.

Add this in your head tag

Now it will work fine till you do not refresh the page. If you refresh your page at this point, you will see page not found error, it is because now browser sends request to server and server doesn’t have the route.

To do this we will add this route at the end of routes.php

 

 

Force https on Google App Engine

To serve all request on https in Google App Engine, add following entry to your app.yaml file

For application developed in Laravel use following lines instead.

Enable password authentication and set root password – Ubuntu

To enable Password Authentication

Open file etc/ssh/sshd_config by

Search for PasswordAuthentication no, just change this to

To set root password

it will ask for new root password and confirm root password. To test this logout from current session and try to login using root as user and password that you have just assigned.

 

PHP Fatal error: Uncaught exception ‘UnexpectedValueExcepti$

After fresh installation of Laravel 5.1, it was not showing up the welcome page. Further investigating into this issue revealed that “storage” directory is not writable.

To make storage directory writable run following commands

Then run:

How to update Geary to latest version

Geary is an IMAP mail client for GNOME 3.

Geary recently released their new version 0.10, with various improvements. To update geary to new updated version add Yorba ppa.

Restart geary and you will see an updated version of geary.

Android Studio – Unable to run mksdcard SDK tool

When I was installing Android Studio on Ubuntu this error occurred which halted the installation

It happened twice and I thought sharing this might help others. It got resolved by running following command.