任何时候你都可以开始做自己想做的事

搜索|
mysql 支持远程用户访问的配置常用bash命令
发布时间:2024-10-14 03:15:31

数据库命令:

mysql -u root -p

查看现有用户权限:

SELECT User, Host FROM mysql.user;

授予远程访问权限:

允许从任何 IP 地址访问:

GRANT ALL PRIVILEGES ON *.* TO 'youruser'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;


允许从特定 IP 地址访问:

GRANT ALL PRIVILEGES ON *.* TO 'youruser'@'113.65.80.163' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;