Mysql remote access denied _ MySQL-mysql tutorial

Mysql remote access denied problem bitsCN.com

When remotely connecting to the MySql database:

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

The remote connection is rejected;

Solution:

MySQL> use MySQL;
Database changed
MySQL> grant all privileges on *. * to 'youruser' @ '% 'identified by 'yourpassword ';
Query OK, 0 rows affected (0.00 sec)
*. * Indicates all tables in all databases, and '*'. * indicates all tables in database *.
MySQL> grant all on *. * to 'youruser' @ '%' identified by 'yourpassword ';
Query OK, 0 rows affected (0.00 sec)
Enter the IP addresses or host names that are allowed to access, and indicate all IP addresses.
Flush privileges;
Query OK, 0 rows affected (0.00 sec)
Mysql> exit;

BitsCN.com