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 […]
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 […]
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 […]
