MySQL remote connection does not open the workaround

Source: Internet
Author: User
Tags mysql client mysql command line

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 foruser‘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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.