MySQL remote connection does not open the workaround
1, change the table method .
Please use MySQL management tools such as: SQLyog Enterprise, navicate MySQL
It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer in localhost using the MySQL management tool to log in to MySQL, the "MySQL" Database in the "User" table "host" item, from "localhost" renamed "%"
2, Authorization law.
A: If you want the MySQL account myuser to connect to the MySQL server using the password mypassword from any host, then enter it at the MySQL command line:
GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;
If the above command has not worked, then use the following command, must be successful!
If you want to allow MySQL account myuser to connect to the MySQL server from the IP 192.168.1.3 host and use MyPassword as the password, enter it at the MySQL command line:
GRANT all privileges on * * to ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION;
The following is a supplement to other netizens:
On the remote host, I opened the MySQL service, with phpMyAdmin can open, for example, the user name is root, the password is 123456. However, when using the Mysql client remote connection, but reported the error, such as Mysql-front reported the following error.
?
1 |
Access denied for user ‘root ‘@‘ 121.42.8.33′(using password :YES) |
High-Anti-server rental Select a special guest network "Click to enter" high-anti-server rental selected ringgit, 100% immunization site CC, killed a refund! MYR Network high-protection server rental View
Oddly enough, phpMyAdmin can be accessed normally, and why can't Mysql-front connect? The possible reason is that the IP limit, phpMyAdmin is used in connection with localhost, and we access the page to use the remote host's IP, and Mysql-front is connected to the remote host.
The workaround is as follows, we need to create a new user, and then grant all IP access to the right.
In the following SQL statement, username is the user name and password is the password you want to set:
?
123456789101112131415 |
CREATE USER
‘username‘
@
‘localhost‘ IDENTIFIED BY
‘password‘
;
GRANT ALL PRIVILEGES ON *.* TO
‘username‘
@
‘localhost‘ WITH GRANT OPTION;
CREATE USER
‘username‘
@
‘%‘ IDENTIFIED BY
‘password‘
;
GRANT ALL PRIVILEGES ON *.* TO
‘username‘
@
‘%‘ WITH GRANT OPTION;
CREATE USER
‘username‘
@
‘localhost‘ IDENTIFIED BY
‘password‘
;
GRANT ALL PRIVILEGES ON *.* TO
‘username‘
@
‘localhost‘ WITH GRANT OPTION;
CREATE USER
‘username‘
@
‘%‘ IDENTIFIED BY
‘password‘
;
GRANT ALL PRIVILEGES ON *.* TO
‘username‘
@
‘%‘ WITH GRANT OPTION;
|
By executing the above statement, we create a new account with username username, password password, and then login with the new account to connect successfully.
MySQL remote connection does not open the workaround