Tag: MySQL

How to manage MariaDB in Webmin

It is easy to use Webmin to manage VPS, including MySQL server.  But it is not working with MariaDB default. The webmin MySQL server shows error as below: It can not find the path of command to start and stop MariaDB and also config file of MariaDB server. So click module configuration and change: Command

How to solve mysqldump 1044 error

I do a database backup very ofter with mysqldump command. Just found an error come when I run the command, mysqldump as below. mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES I google it and found one solution for it.