create database test1; After creating the database through a remote connection prompt Access denied for user 'root'@'%' to database 'xxxx' Cause: After creating the database, the need for authorization, (the local access is generally not this problem
1. Modify the MySQL configuration file (/ etc / mysql / my.cnf), comment the following line: # Bind-address = 127.0.0.1 2 Restart the mysql database for the Ubuntu system, execute the following command sudo / etc / init.d / mysql restart 3 Login as r
Mysql database through a remote connection, suggesting that "can't get hostname for your address", Solution: Modify the my.ini file mysql server, add a line: skip-name-resolve Mysql service to restart.
When we installed mysql does not support remote connections, if you want to connect remotely if necessary, execute the following command into mysql: grant all on *.* to 'tmj'@'%' identified by '111111'; flush privileges; Note: the password to a user
MYSQL slow remote connection, sometimes used when a remote connection to MYSQL ranging from 4-20 seconds, the local connection MYSQL normal, the problem occurs mainly because the default installation of MYSQL opened the reverse DNS resolution, in MY.
databases, default installation, host name, linux, privileges, unix, mysql server, access control, linux systems, windows systems, ip address, local connection, cnf, dns resolution, connection speed, remote connectionAugust 2