Error-prone remote connection to MySQL Server

MySQL commands are also not easy to remember, so it is easy to mess up, and it is impossible to log on to the server by default, You need to authorize the IP address of the desired login machine on the server.

Look at the command

Mysql> grant all privileges on *. * to root @ "%" identified by '000000' with grant option;

The preceding command creates a super account that can be logged on from any machine as root. The logon password is 0123456789. In this way, the client can use a convenient graphical tool to log on and operate, including modifying the root password.

However, it should be noted that I also made a mistake here, because the default MySQL user and super-privilege user are root, therefore, if the system runs in the root logon mode, an error is reported.

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)

It is easy to make mistakes, and you may not immediately think of this mistake.