≡ Menu

mysql database

How to Allow MySQL Client to Connect to Remote MySQL server

By default, MySQL does not allow remote clients to connect to the 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 [...]

{ 55 comments }

Forgot MySQL Root Password – How To Reset It?

Forgot your MySQL root user password? Don’t worry. We are here for rescue. When you tried to login to root without entering a password, you may get ‘Access Denied’ message, as MySQL is expecting a password. This article explains how to recover mysql root password by setting a new MySQL password when you don’t remember [...]

{ 16 comments }

How To Change MySQL Root Password

Question: How do I change MySQL root Password? Answer: You can change MySQL root password using one of the following 3 methods. These methods can be used on both Windows and Unix Environment including Ubuntu, Debian, CentOS, Fedora, RedHat, Arch Linux, SUSE etc., Method 1. How to Change MySQL Root Password Using mysqladmin Command? You [...]

{ 14 comments }

Starting from MySQL 5, when you execute show databases command, information_schema will be listed in the database list. information_schema is a virtual MySQL database that stores metadata information of all the MySQL databases. Typically you will execute either DESCRIBE or SHOW commands to get the metadata information. However using the information_schema views, you can execute [...]

{ 10 comments }