Grant remote access of MySQL database

Grant remote access of MySQL database If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h 192.168.1.8 -u root -p Enter password: ERROR 1130: Host ‘192.168.1.4’ is not allowed […]

See More

Databases showing 0MB in cPanel

Databases showing 0MB in cPanel  From command line 1. Run the command. # /usr/local/cpanel/bin/setupdbmap 2. Edit cPanel configuration file. disk_usage_include_sqldbs=1 ( you need to set it to ‘1’ if ‘0’ ) in file /var/cpanel/cpanel.config 3. Run the following script. #/scripts/update_db_cache You can also enable this from the WHM control panel. WHM >> Server Configuration >> […]

See More

How to reset MySQL root Password

This will helps when you forget MySQL root password and not able to access MySQL service on the server. Here are the steps to reset MySQL password : root@server [~] /etc/init.d/mysqld stop Now start MySQL server without password: root@server [~] mysqld_safe –skip-grant-tables & root@server [~] mysql After that you can get the mysql prompt then […]

See More