≡ Menu

schema

I‘m trying to make backups using the mysqldump command and getting the following error or warning:

mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES

How do I fix this problem?
[click to continue…]

MySQL List Databases

How do I display a list of all databases under MySQL database server running on a Linux or Unix-like system?
[click to continue…]

MySQL command to show list of databases on server

I am a new Linux user and never used MySQL database server before. How do I show the list of databases on my server? Is there any good GUI frontend exists for the same purpose?
[click to continue…]