phpMyAdmin - MySQL server has gone away

[Noel McKeown]

Hi users,

I have setup phpMyAdmin on my app engine to connect to the Cloud SQL instances as per this technote:

https://cloud.google.com/sql/docs/mysql/phpmyadmin-on-app-engine

I haven't any issue following the guide and phpMyAdmin loads fine.

When I try to login I get the following for all accounts:

I had a look everywhere online but can't resolve this. The instance connection name in config.inc.php is correct and IAM should be all setup.

Anyone come across this and have an idea to resolve ?

Many Thanks

[Amit (Google Cloud Support)]

Hi

It seems like you have an internal ticket with us for this case. Per my colleague’s feedback on that case, he suggested to check your host in the config.inc.php file. As you already checked this file, he just wanted to make sure you included the region in your host path, as an example:

$host = “/cloudsql/yourProjectID:regionOfTheInstance:SQLinstanceName”

Please let him know if after following those steps, you are able to connect.

[Noel McKeown]

Hi Amit,

Thanks for getting back. 

Yeah it was the curly bracket were the problem.

I would think it's worth updating the tech note as its not accurate.

The double curly brackets are not highlighted to replace so I would think you leave these as is based on the instructions below:

1. Paste the new secret in place of {{your-secret}} in config.inc.php.
2. Replace the value of {{your_connection_string}} (within the $host variable) with the Instance connection name property.

I had a look online and it seems to be a common problem so maybe a lot of people are reading it the same.

Best Regards,

Noel

[Pia Chamberlain]

I updated the docs so the highlighting includes the curly brackets. Hope that helps folks.

[Amit (Google Cloud Support)]

Hello Noel

I am glad to know that the issue was resolved for you. And thank you for your feedback on documentation changes. I can see Pia already changed it. I hope that helps.