Error 1049: database unknown on deploying app on GAE python

454 Views Asked by At

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 ?

0

There are 0 best solutions below