Because mysql has multiple piress users, the remote connection is disabled.

1. mysql security vulnerability if your mysql root user's password is nul, root, or secret, congratulations, on May 1, 2012, your windows user will have another user named piress, 2. solution (1) when installing MySql, try to select another port (3306 by default). The password is a little more complicated! In ne

1. mysql security vulnerability if your mysql root user's password is nul, root, or secret, congratulations, on May 1, 2012, your windows user will have another user named piress, 2. solution (1) when installing MySql, try to select another port (3306 by default). The password is a little more complicated! In ne

1. mysql Security Vulnerabilities

If your mysql root user's password is nul, root, or secret, congratulations, starting from 2012, your windows user will have another user named piress,

2. Solution

(1) When installing MySql, try to select another port (3306 by default). The password is a little more complicated! In the next step, do not select "Allow Remote Logon ".

(2) Delete A piress user

(3) If the remote connection is enabled during installation, the remote connection will be deleted.

Mysql> use mysql;

Database changed
Mysql> select user, host from user;
+ ----------- +
| User | host |
+ ----------- +
| Cactiuser | % |
| Root | % |
| Wikiuser | % |
| Cacti | localhost |
| Mongoose | localhost |
| Root | localhost |
+ ----------- +
6 rows in set (0.05 sec)

Do you see those "%" above? "%" Indicates that a Remote connection can be established. You can delete the "%" record above.

(4) install a good anti-virus software, such as avast.