如何给Mysql数据库赋予远程连接的权限

来源：互联网发布：情义我心知黎明演技编辑：程序博客网时间：2024/05/22 05:00

进入自己服务器的mysql数据库

[root@iz2zea8athrpi6mpaciiruz bin]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.5.56-log Source distribution

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

执行以下sql语句

GRANT ALL PRIVILEGES ON *.* TO zhangsan@"%" IDENTIFIED BY "lisi";
FLUSH PRIVILEGES;

执行上面两句话。自动创建用户zhangs,密码lisi

格式：grant 权限 on 数据库名.表名 to 用户@登录主机 identified by "用户密码";

@ 后面是访问mysql的客户端IP地址（或是主机名） % 代表任意的客户端，如果填写 localhost 为本地访问（那此用户就不能远程访问该mysql数据库了）。

或者执行

GRANTALL PRIVILEGES ON *.*TO 'root'@'%' IDENTIFIEDBY 'root' WITH GRANT OPTION;flush privileges;

FLUSH PRIVILEGES;

授权用户root使用密码root从任意主机连接到mysql服务器

阅读全文

0 0