Solution:
1. Change the table.
It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to MySQL on the computer of localhost, and change the "host" entry in the "user" table in the "
After mysql is installed, allow remote connection to bitsCN.com. After mysql is installed, allow remote connection.
Http://blog.sina.com.cn/s/blog_3eba8f1c0100tsox.html
Http://blog.csdn.net/zxyvb/article/details/2462514
Http://www.bitsCN.com/article/
Solution MySQL does not allow remote access to the method
Workaround:1. Change Table method. Your account may not be allowed to log in remotely, only in localhost. This time as long as the computer in localhost, login mysql, change the "MySQL"
The following articles mainly introduce how to solve the problem that MySQL remote access is not allowed. For the problem that MySQL remote access is not allowed, this article provides two solutions, this includes table modification and
ERROR 1130:host ' 192.168.1.3 ' isn't allowed to connect to Thismysql server Workaround: 1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the
1. I use this method to change the table Method!!(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, log in to MySQL, the "MySQL" Database in the "User" table "host",
Method OneAdd remote user admin password to passwordGRANT all privileges on * * to[email protected]identified by \ ' password\ ' with GRANT OPTION;GRANT all privileges on * * to[email protected]\"%\" identified by \ ' password\ ' with GRANT
MYSQL adds remote users or allows remote access.Add the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \"
Add remote users to MYSQL or allow remote accessAdd the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \"
Add the remote user admin password passwordGRANTALLPRIVILEGESON ** TOadmin @ localhostIDENTIFIEDBYpasswordWITHGRANTOPTIONGRANTALLPRIVILEGESON ** TOadmin @ % ID add the remote user admin password as password grant all privileges on *. * TO admin @
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.