google-app-engine,phpmyadmin,google-cloud-sql , Cannot log in to the MySQL server error when logging into phpmyadmin with Google Cloud SQL on Google App Engine

Cannot log in to the MySQL server error when logging into phpmyadmin with Google Cloud SQL on Google App Engine


Tag: google-app-engine,phpmyadmin,google-cloud-sql

EDIT: Changed my question around as this is the real problem:

I followed this Google guide to deploy phpmyadmin on Google Cloud SQL with Google App Engine.

I followed the tutorial and deployed phpmyadmin successfully to my App Engine however, when I try to log in with user: "root" password: [null] I get the following error:

Cannot log in to the MySQL server

Here is my file (taken pretty much verbatim from the guide). Is there something missing here?

/* vim: set expandtab sw=4 ts=4 sts=4: */

 * This is needed for cookie based authentication to encrypt password in
 * cookie
$cfg['blowfish_secret'] = '<your-secret>'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

 * Servers configuration
$i = 0;

// Change this to use the project and instance that you've created.
$host = '/cloudsql/<your-project-id>:<your-cloudsql-instance>';
$type = 'socket';

* First server
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['socket'] = $host;
$cfg['Servers'][$i]['connect_type'] = $type;
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
 * End of servers configuration

 * Directories for saving/loading files from server
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

* Other settings
$cfg['PmaNoRelation_DisableWarning'] = true;
$cfg['ExecTimeLimit'] = 60;
$cfg['CheckConfigurationPermissions'] = false;

I also made sure to whitelist my IP address from which I am accessing phpmyadmin. Furthermore, I can successfully connect to the Google Cloud SQL instance using mysql from the command line so I know it's not a permission issue.

I also found these links here with a similar issue and tried them but they did not help me:

Install phpMyAdmin on Google App Engine

How to trace mysql log in Google Cloud SQL?


This was the problem:

In the guide it says:

// Change this to use the project and instance that you've created.
$host = '/cloudsql/<your-project-id>:<your-cloudsql-instance>';

If you go to your Google Cloud SQL and view your GC-SQL instance, you will see that the instance ID is listed as


So the mistake I made was doing this:

// Change this to use the project and instance that you've created.
    $host = '/cloudsql/<your-project-id>:<your-project-id>:<your-cloudsql-instance>';

When it should be

// Change this to use the project and instance that you've created.
$host = '/cloudsql/<your-project-id>:<your-cloudsql-instance>';

Hope this helps a noob somewhere!!!!!


Designing an API on top of BigQuery

I have an AppEngine app that tracks user various sorts of impression data across several websites. Currently we're gathering roughly 40 million records a month and the main BigQuery table is closing in on 15Gb in size after 6 weeks of gathering data and our estimates show that within 6...

How to exclude entries with specific value/strings in phpmyadmin SQL?

My DB is collecting relative urls as data. The column is called 'path'. How would I filter out all URLS that have a specific word in phpmyadmin SQL section? Example: I would like to see all URLs without the word 'coffee' and my path column is full of urls with...

Objectify - should I create an entity super class?

Is there any reason why shouldn't all my entities be subclasses of one generic ModelEntity object? @Entity public class ModelEntity { @Id Long id; } @Subclass public class User extends ModelEntity { @Index String username; } The advantages are clear: there is code common to all entities (like id, date,...

Google App Engine datastore: filter()

I'm trying to retrieve an entry from Google App Engine's datastore using the filter() method as follows: result = Sender.all().filter("email =", email).filter("source_address =", source).filter("dest_address =", dest).filter("food_type =", food_type) Then, if such an entry exists, I change the value of one of the columns in that entry. Otherwise, I'm displaying an...

PHP math does not work in sql value ZERO

I am trying to math between value of 0 but in php code it's work properly but when that value come from database then it does not work. Here is a demo to test only PHP code: <?php $a = 0; echo $a+1; ?> The result of this code 1...

Is it possible to connect to remote DB while working in localhost?

I am working on a project with my developers on localhost. We are using git to collaborate but are having issues collaborating the database using git or using a remote db. Is there any possible way where I can use git or set up a remote server while working with...

If I export my database with phpmyadmin will it lock my tables or take my database down?

I want to create a backup of my database using the phpmyadmin export function. the database can't have any down time so I need to know if running a database export will take the database down? I've looked on-line but all I get is instructions on how to export. No...

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row

This error show every..*.**please help me for the exact answer for this qyery... SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (mydawai.cataloginventory_stock_item, CONSTRAINT FK_CATINV_STOCK_ITEM_PRD_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (product_id) REFERENCES catalog_product_entity (entity_id) ON DELETE CA) i'm importing the 20 to 50 thousand csv...

AJAX call to Servlet Google App Engine (GAE)

I am trying to make an AJAX call to my servlet but it doesn't work. I can't redirect to a JSP. This is my AJAX call: $.ajax({ url: '/register', type: 'GET' }); This is my Servlet: public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { getServletContext().getRequestDispatcher("/prueba.jsp").forward(req, resp); } If...

Getting user credentials using Google+ API

I am trying to include Google sign in in my android application using Google+ Api. I am able to take account details from the user but once signed in I am getting null when requesting for username using call: Plus.PeopleApi.getCurrentPerson(mGoogleApiClient).getDisplayName() And Logcat shows: BasicNetwork.performRequest: Unexpected response code 403 for

serving GAE applications over http

I have implemented an application on GAE which can be accessible through https://<my_app_id> Now I have a custom domain registered with As described in GAE documentation I have mapped my custom domain to https://<my_app_id> and I see my application getting served from my custom domain. But I see requests...

SQL - Adding user defined variables to table (mysql)?

So I have this code thats part of a stored procedure: SET @MID = 0; SET @MX = 0; SET @MY = 0; SET @MT = 0; SET @CSTAMP = '2014-6-06 08:03:19'; SELECT @MID=m.ID, @MX=m.x , @MY=m.y , @MT=m.timestamp FROM movement m WHERE m.ID = cSID AND m.timestamp = (SELECT...

How check if the sum of the values of two columns, in the same row have exactly 100 as result in mysql

I have this problem in mysql (phpmyadmin).. I should want to check if the values of 2 columns do 100… for example I have this table | BLABLABLA | BLABLABLA | VALUE1 | VALUE2 | and user want add this values(bla, bla, 20, 30).. I would that 20 and 30...

How fatal is the maximum execution timeout warning in MySQL

Been working with the XAMP which I installed just under a year. I recently installed few frontend software for MySQL (to see which one am I comfortable with the most). Now, for the past two days, whenever I go to localhost/phpmysql, I receive this warning Fatal error: Maximum execution time...

GAE Python PyML ImportError: No module named _ckernel

I'm trying to import PyML on Google App Engine as a requirement for another library, however I am getting the following import error: File "/base/data/home/apps/s~myapp/uno.385079313378714244/PyML/", line 4, in <module> from PyML.containers import * File "/base/data/home/apps/s~myapp/uno.385079313378714244/PyML/containers/", line 3, in <module> VectorDataSet = __import__('PyML.containers.vectorDatasets', fromlist=['']).VectorDataSet File...

Google App Engine performance setting : Some performance settings must be changed via Module configuration files

Google App Engine performance setting is not available for the application, it is displaying as Some performance settings must be changed via Module configuration files. My question is, in my current application I am not using module, so it should have performance setting sliders displayed? Or I need to set...

Importing a mysql database with command line

Have tried all other answers on stackoverflow, and they haven't worked. I have a database in phpMyAdmin, and I need to update it. The file is too big to upload via phpMyAdmin, and I've tried increasing limits in php.ini to no avail. I think that didn't work because I updated...

Trying to download a file using Dropbox Java API in the GAE

I have an XML file on Dropbox that I want to access from my Google App Engine using the Dropbox Java API. After a bit of playing around I find the GAE doesn't support FileOutputStream. FileOutputStream outputStream = new FileOutputStream("myFile.txt"); try { DbxEntry.File downloadedFile = client.getFile("/myFile.txt", null, outputStream); System.out.println("Metadata: "...

What is the equivalent of BlobstoreLineInputReader for targeting Google Cloud Storage?

This is a python appengine question, mapreduce library 1.9.21 . I have code writing lines to a blob in the local blobstore, then processing that using mapreduce BlobstoreLineInputReader. Given that the files api is going away, I thought I'd retarget all my processing to cloud storage. I would expect to...

SQL result show empty results in phpmyadmin xampp [closed]

i have make a login and register page in php and every thing work fine and it show me that user register successful . my question is that when i navigate to localhost/phpmyadmin and try to get the user and password i just entered it so i use : SELECT*FROM...

upload CSV file to database on Google app engine using Python

I'm a newbie in python and started learning it from about a week. I was looking into couple of tasks one of which was to upload a file (.txt or .jpg) to a bucket on GAE. I was able to solve it by following couple of tutorials online, but i'm...

GAE DOMDocument::load(): I/O warning : failed to load external entity

I'm trying to move an existing webapp on GAE. At the moment the app is running on my local SDK. When the app perform a compatibility check, it returns an error (read by FIREBUG ): This is the code of the js who fails: function checkConfig(){ // Launch the configuration...

Google Appengine - Entity class is not enhanced

If I change an Entity class in a an appengine project in eclipse, in run time I get this error Found Meta-Data for [classpath] but this class is not enhanced!! Please enhance the class before running DataNucleus. Even when I undo the changes and re-run the local srv i get...

GAE Managed VMs: Possible to use C-based Python libraries with standard runtime?

I'm building a background module for my app in Python 2.7, but it needs to use C-based external libraries such as OpenCV. While GAE only "directly" supports pure Python libraries, I understand that using a managed VM removes that constraint. What I'm not quite clear on, after reading the documentation,...

Choose results by date filter PHP and MySQL

I have one page (members.php) that post date to another page (results.php). Using the below code, i can successfully get the "to" and "from" variables from the members page. <?php echo $_POST["to"]; ?> <?php echo $_POST["from"]; ?> My problem now is, how can i create a query (in results.php) in...

SQL - Get all rows with same ID [on hold]

I'm trying to get all rows with the same id, this is a example of the table: Curs_ID Cursistnr payed Excel 2 500 Internet 3 100 C# 2 200 what I want to get out of the table is everything where Cursistnr is 2 So what I need is 2...

Merging two tables into new table by ID and date

Let' say I have two tables: table 1: col a | col b | col c 1 | 62215 | 21 1 | 62015 | 22 2 | 62215 | 23 2 | 51315 | 24 and table 2: col a | col b| col f 1 | 62015| z...

viewing google app engine Python logging messages in CodeEnvy

I'm trying to move my GAE development to the cloud. So far Codeenvy has the richest toolset however I'm struggling with one small issue. when I use the python logging library I don't know where to view these messages! def post(self): self.response.write('Processing form data...') feedback = self.request.get('content') I assumed...

App Engine - NDB query with projection requires subproperty?

I have the following objects: class Address(ndb.Model): type = ndb.StringProperty() # E.g., 'home', 'work' street = ndb.StringProperty() city = ndb.StringProperty() class Friend(ndb.Model): first_name = ndb.StringProperty() # E.g., 'home', 'work' last_name = ndb.StringProperty() class Contact(ndb.Model): name = ndb.StringProperty() addresses = ndb.StructuredProperty(Address, repeated=True) friends = ndb.StructuredProperty(Friend, repeated=True) And now to optimize the...

Count the number of times each members name appears in a table with a condition

Consider the following table: Im looking for a query that will: - Count the number of times each members name appears in the table where tournament= "EPL" AND round ="12" For this EXAMPLE the query should return: Andrew = 3 Wins Joseph = 2 wins John = 1 win Martin...

Google-App-Engine[PHP]: Error trying to establish database connection

I am finding a problem with the cloudsql as database connection is not being established. I have followed the following site step-by-step However I seem to be finding problems after deploying the project to the appengine and accessing the wordpress installation page with URL: https://<PROJECT-ID> The error shown is:...

How to get a response for a streaming url on google app engine (python)

I am trying to verify if a online radio url is delivering music and if the url was redirected or not (this happens if for some reason the request url is wrong or not active). I found some advices here Fetching url in python with google app engine. However, for...

Scaling non-default version of Google App Engine Backend

I have a live app that uses Google App Engine (python) for the backend. The app is pointing Because the API has changed significantly, I've set up a new version of the backend, 'v2', and am pointing the new app to I see now in the docs, that...

MySQL database shows in phpMyAdmin but not the command line client

I have installed MAMP and set it up with wordpress. Everything is OK except that I have four databases under mysql through terminal. They are - information_schema,mysql,performance_schema, test But when I enter phpmyadmin, it shows - information_schema,mysql,performance_schema, wordpress. Under the actual wordpress db there are many tables, but under test...

Conditional statements and multiple queries in mysql

In MySQL (both instances of phpmyadmin and MySQL workbench) I would like to check if a value exists in a table before I perform any other additional queries to the same table or other tables and below are the sets of queries I have tried but neither are working and...

I am working on small project with Google AppEngine (Python), tutored by Udacity. I am unable to render user comments to main page

I am suppose to add forms to my HTML to allow users to add data (comments to my page) and also store the data via GAE-Datastore. I have been able to store the data but not able to get the user comments posted to the main page. Seperate code files:...

Php code does not come out from MySQL Database properly

I was try to loop PHP CODE data from MYSQL database, but it looks different when it's echo'd out. HERE IS MY PHP CODE: <?php mysql_connect("localhost","root",""); mysql_select_db("myweb"); ?> <table width="100%" border="1"> <?php $query=mysql_query("SELECT * FROM right_widgets ORDER BY right_widgets_id ASC"); while($rows2=mysql_fetch_assoc($query)) { $right_widgets_id=$rows2['right_widgets_id']; $func_name=$rows2['func_name']; $active_status=$rows2['active_status']; ?> <tr> <td><?php echo $func_name;...

Make Mysql database that exists manageable with phpmyadmin

I have a Mysql database on my server. I can get into it via the command line, so it does exist. However, when I go into cpanel and open up phpmyadmin, it is not there. What do you have to do to make an existing database manageable with phpmyadmin?...

PhpMyAdmin export : reference without uppercase

First, I'm sorry for my poor English, I'm french. I use PhpMyAdmin with Xampp in localhost and an other PhpMyAdmin on server My tables are like Personne, Adresse, Titre. When I use the export option with server my sql is perfect : CREATE TABLE IF NOT EXISTS `Personne` ( `idPersonne`...

GAE webapp2 delete all UserTokens (drop all sessios) for specific user

I want to drop all user sessions when user resets his password, but I can't find a way to do that. My idea was to get all UserTokens of the specific user and delete them, but it seems impossible, because of user = model.StringProperty(required=True, indexed=False) in UserToken model Any ideas...

No module named _mysql - Google App Engine & Django

First of all I'm working on Mac (Yosemite). I've created a simple Django project with Google App Engine. I'm using Cloud SQL in production and MySQL in development environment as recommended in the docs. The project uses virtualenv on my dev machine of course. I can run the project with...

Sending mail by Unauthorised sender in Google AppEngine

I've got a Google AppEngine Python application connected with my domain. I want to be able to send emails from any email, like: [email protected] So I use sendmail() and set mailobject.sender = "[email protected]", but it does not work. Also I made a receive function, but I don't want to receive...

How to get public link for the uploaded file on google cloud storage in local dev server(Google App engine+JAVA)

I am trying to upload the image files using gcs client library+java in local google app engine dev server. Images are uploaded successfully and i can see the entries created in local datastore under localhost:8888/_ah/admin/datastore How to get the public key for the uploaded images so that i can show...

IllegalArgumentException: expected primitive class, but got: class UUID

My app is using GAE endpoints. My model has UUID. And once i try to send it Android app it encounters illegalArgument exception. Anyone has got recommendations how to handle endpoints model with UUID on android app with Google App Engine endpoints? 06-14 23:26:49.560 27462-27488/com.example E/AndroidRuntime﹕ FATAL EXCEPTION: AsyncTask #1...

GAE/P: Migrating to NDB efficiently

I'm finally upgrading from db to ndb (it is a much bigger headache than I anticipated...). I used a lot of ReferenceProperty and I've converted these to KeyProperty. Now, every place where I used a ReferenceProperty I need to add an explicit get because it was previously done for me...

Check if a queue is empty in Google App Engine

I have a script that add tasks to a queue. For example: from google.appengine.api import taskqueue [...] for u in users: taskqueue.add(queue_name='mailqueue', url="/api/users/send-notification/%s" % (, method='GET') I would like to check if the queue is empty and all tasks are finishing if queue_is_empty: print "Your task is finished"...

Choosing specific ports on local development server for non-default modules

In my build.gradle file, I use the following config for my non-default (module2) AppEngine gradle module: appengine { downloadSdk = true httpAddress = "" httpPort = 8081 appcfg { email = "[email protected]" oauth2 = true } } However, when I run my "Google AppEngine configuration", the module still starts on...

Do we HAVE to generate and use client libraries to use Google App Engine's Endpoints?

I am currently developing an Swift iOS app with GAE Endpoints for the RESTful API. It seems like all the tutorials and documents make you generate and use client libraries if you need to use the API on the client side. I was wondering if it's possible for me to...

jquery google app engine

I have an issue where the Javascript file that I have uploaded does not work. My code is below. app.yaml has: - url: /js static_dir: /js index.html has: <script type="text/javascript" src="/js/script.js"></script> script.js has: $(document).ready(function(){ $('img').click(function(){ $(this).fadeOut('slow'); }); $('p').click(function(){ $(this).fadeOut('slow'); }); alert("hi"); }); and not even the alert comes out...

How can you get the Google+ Profile of the current user when using Google Cloud Endpoint's (Java) built in authentication?

My Setup Backend: Google App Engine (Java) w/ Google Cloud Endpoints using Endpoint's built in authentication Frontend: AngularJS web app Problem I need to get the Google+ profile for my users. The keyword "me" can generally be used to get the current user's Google+ profile, however since all the authentication,...