cloud-test: Google App Engine for PHP with PhpStorm

Google App Engine for PHP with PhpStorm

Saturday, October 19, 2013

Today’s guest post comes from Maarten Balliauw, Technical Evangelist at JetBrains, the vendor of smart developer tools such as IntelliJ IDEA, PyCharm, PhpStorm, Android Studio and many more.PhpStormGoogle App Engine for PHPcomprehensive tutorialGoogle App Engine applications in PHP using PhpStormGoogle Cloud SQLcreated a Cloud SQL instance from the Google Cloud ConsoleCtrl+Alt+A (Cmd+Alt+A on Mac)Google Cloud SQL supports native MySQL connections

Connecting to a Google Cloud SQL database using PhpStorm database tools

:3306/ where cloudsql_ip_address is the IP address of our Google Cloud SQL instance, and database_name is the name of the specific database on that instance to which you want to connect.

As for database credentials, you can create a root user password through the Google Cloud Console or manually create a new user through PhpStorm using the following SQL statement:

CREATE USER 'user_here'@'%' IDENTIFIED BY 'password_here';
GRANT ALL PRIVILEGES ON *.* TO 'user_here'@'%' WITH GRANT OPTION;