On ubuntu, I am trying to deploy an app on GAE python. I have also connected mysql client to it through these lines:
if (os.getenv('SERVER_SOFTWARE') and os.getenv('SERVER_SOFTWARE').startswith('Google App Engine/')):
db = MySQLdb.connect(unix_socket='/cloudsql/' + _INSTANCE_NAME, db='databaselab', user= 'root')
where in mysql 5.6, I have create a database named 'databaselab'. But the error on deploying it on GAE shows:
OperationalError: (1049, "Unknown database 'databaselab'")
But when I replace 'databaselab' with predefined tables 'mysql', everything works fine. But then I thought to create required tables in 'mysql' database as I was able to access that database. But then error comes
Error: (1146, "mysql.table_name doesn't exist")
i.e I am able to access only predifined tables naming 'mysql', 'information_schema' and 'performance_schema'. Rest other databases and new tables defined in predefined databases are unknown to GAE although all those databases and tables exist.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| databaselab |
| mysql |
| performance_schema |
+--------------------+
How to resolve this ?