mysql授权 远程访问授权

GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY WITH GRANT OPTION 

FLUSH PRIVILEGES 

 

mysql授权 远程访问授权

 

MySQL grant all privileges on lfchat.* to dbname@localhost identified by password;

Query OK, 0 rows affected (0.03 sec)

 

mysql flush privileges;

Query OK, 0 rows affected (0.00 sec)

 

mysql  

 

认情况下Mysql只允许本地登录，所以需要修改配置文件将地址绑定给注释掉：

vim /etc/mysql/my.cnf

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1  ---注释掉这一行就可以远程登录了

阿里云ECS服务器Ubuntu配置MySQL远程访问 root账户登录服务器Ubuntu16.04 apt-get update apt-get install mysql-server mysql-client; 安装时会让你设置root密码，输入2次。
开启mysql远程访问过程中所遇常见问题的解决办法 开启mysql远程访问过程中所遇常见问题的解决办法 MYSQL ERROR 2003 (HY000): Can t connect to MySQL server on 192.168.10.210 (111) 解决方法今天在测试MySQL的连接时候，发现连接不通过，并报错ERROR 2003 (HY000): Can t connect to mysql server on 192.