mysql root用户增加远程和本地登录

admin · 发表于 2023-5-2 10:00:01

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要登录才可以下载或查看，没有账号？开始注册

x

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.012 sec)

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.028 sec)

admin · 发表于 2024-7-9 22:26:41

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.004 sec)

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.13.130' IDENTIFIED BY 'root' WITH GRANT OPTION;
Query OK, 0 rows affected (0.002 sec)

添加root本地登录，和相应地址登录。
MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.001 sec)

账号		自动登录	找回密码
密码			开始注册

mysql root用户增加远程和本地登录

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

浏览过的版块

站长推荐 /4