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 MoreCategory: MYSQL
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 MoreHow 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