MySQL 8.0 修改root远程登录【ERROR 1410 (42000): You are not allowed to create a user with GRANT】
mysql 远程 Error to 修改 not with 登录
2023-09-27 14:29:14 时间
MySQL 8.0的数据库root用户默认无法远程登录,需要修改root的远程授权,如下:
mysql> grant all privileges on *.* to 'root'@'%';
ERROR 1410 (42000): You are not allowed to create a user with GRANT
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> grant all privileges on *.* to 'root'@'%';
Query OK, 0 rows affected (0.02 sec)
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
+------------------+-----------+
8 rows in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> exit
Bye
相关文章
- 解决使用Navicat 打开 Linux远程连接mysql很慢的方法
- Mycat(4):消息表mysql数据库分表实践
- 通过跳板机SSH/远程链接mysql
- MySQL通过增加用户实现远程连接数据库
- 【用Navicat Premium 12连接mysql一报错】2059 - Authentication plugin ‘caching_sha2_password‘ cannot be loaded
- 基于Python+MySQL实现(Web)学生成绩管理系统【100010288】
- mysql 维护添加远程主机访问
- new mysqli_ and 旧mysql
- Spring Data R2DBC响应式操作MySQL
- 安装MySQL-python
- mysql远程连接 Host is not allowed to connect to this MySQL server
- Mysql Order By 注入总结
- Linux下mysql的远程连接
- mariadb(MySql)设置远程访问权限
- Mysql数据库远程授权
- 【3.6】一个语句在mysql执行流程
- 【3.3】mysql链接服务器,Federated存储引擎实现远程表,相当于sql server的连接服务器
- MySQL无法远程连接解决方案
- [转]MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111) 的问题
- mysql无法远程连接除了远程授权问题,另外的问题解决docker:IPv4 forwarding is disabled. Networking will not work
- java程序中的ibatis连接mySql的基本实例
- Mysql find_in_set()函数的使用
- Window MySQL远程连接不上的解决
- Ubuntu 16.04 设置MySQL远程访问权限