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

Reset WordPress admin/users password from Linux command line

How to reset WordPress admin/users password from Linux command line? Ans:  * Log into server as root. * Enter to MySQL command prompt. root@grand [~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 932677 Server version: 5.5.42-cll MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its […]

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