mysql远程权限grant_mysql数据库设置远程连接权限，执行grant all privileges on . to 'root'@'%' identified by '密码' with ...

最新推荐文章于 2024-08-20 16:37:34 发布

潘铭允Jasmine

最新推荐文章于 2024-08-20 16:37:34 发布

阅读量955

点赞数 1

文章标签： mysql远程权限grant

本文链接：https://blog.csdn.net/weixin_28728495/article/details/114352308

版权

mysql数据库设置远程连接权限，执行grant all privileges on *.* to 'root'@'%' identified by '密码' with grant optio报错

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50556, now running 50639. Please use mysql_upgrade to fix this error.

解决办法:

使用命令：mysql_upgrade -u[username] -p[password]就可以解决。

使用mysql_upgrade 对数据库的数据表结构等升级时，数据库引擎MyISAM 会做检查、修复的动作，InnoDB 执行 mysql_upgrade 没有作用。

查找MySQL的安装目录找到mysql_upgrade ：

whereis mysql_upgrade

cd /usr/bin/

./mysql_upgrade -uroot -p123 (123为密码)

然后进入到mysql再执行权限修改即可：grant all privileges on *.* to 'root'@'%' identified by 'root4xml004a' with grant option;

如：

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

潘铭允Jasmine

关注关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

解决mysql的赋权操作之GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION问题

shengyin714959的博客

11-09

1万+

到此这篇关于mysql的赋权操作：GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION；的文章就介绍到这了,更多相关mysql的赋权操作：GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION；‘root’@’%’：权限赋给root用户，所有ip都能连接。GRANT：赋权命令。

设置mysql允许外部连接访问(授权和修改表方式)

XG17_38241417145的博客

01-24

1万+

1.设置mysql允许外部连接访问(授权)： grant all privileges on *.* to root@'%' identified by '123456' with grant option; flush privileges; 例子：查询mysql用户权限、授权、刷新使生效 select host, user from user; grant all privileges on *.* to root@'%' identified by '密码' with grant option;

参与评论您还未登录，请先登录后发表或查看评论

mysql＞ GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘shujinghuan‘ WITH GRANT OPTION； ERRO

舒一笑的博客

01-31

2322

命令的语法发生了变化。在 MySQL 5.7 之后的版本中，不再支持在。这条 MySQL 命令出现错误的原因是因为在较新版本的 MySQL 中，命令来创建用户并设置密码。完成这两个步骤后，不要忘记执行。命令来给用户分配权限。命令创建用户，然后再使用。

MySQL8设置DBeaver远程连接

热门推荐

whxwkb的博客

02-07

11万+

mysql数据库设置远程连接权限，执行grant all privileges on *.* to 'root'@'%' identified by '密码' with grant optio报错 ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MyS

mysql远程连接权限grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant option语句报错

chenshida_的博客

06-09

2万+

mysql远程连接权限grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant option语句报错记录一下自己安装mysql遇到的小坑 grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant option 只适用于mysql8.0之前的版本之后采用这句: create user root@'%' identif

mysql访问权限GRANT ALL PRIVILEGES ON，访问权限表

weixin_34384915的博客

11-20

1万+

开启远程连接：2, 修改 Mysql-Server 用户配置mysql> USE mysql; -- 切换到 mysql DBDatabase changedmysql> SELECT User, Password, Host FROM user; -- 查看现有用户,密码及允许连接的主机+------+----------+-----------+| User | P...

grant all privileges on *.* to root‘@‘localhost identified by ‘root‘ with grant option；运行的sql语法错误解决

qq_42381317的博客

08-08

1万+

grant all privileges on . to root’@'localhost identified by ‘root’ with grant option;运行的sql语法错误解决问题截图：问题的主要解决是是云服务上的mysql能够远程连接，这个错误试过很多种sql语句都是报错，自己手动也打了换一种方式实现云服务山的mysql的远程连接： 1.在云主机上连接mysql mysql -uroot -p #根据提示输入密码 2.依次执行以下sql命令 use my

mysql error 1130 hy000:Host 'localhost' is not allowed to connect to this mysql server 解决方案

weixin_33947521的博客

06-12

1055

ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server D:\Wamp\mysql-5.6.21\bin>mysql.exe -uroot -p Enter password: ERROR 1130 (HY000): Host 'localhost' is not ...

mysql远程连接权限grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant optio语句报错

weixin_45949736的博客

09-19

1万+

.mysql远程连接权限grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘root‘ with grant optio语句报错

insert into user mysql root_mysql创建用户并授权

weixin_39997089的博客

02-01

635

1.新建用户。//登录MYSQLmysql -u root -p//创建用户mysql> insert into mysql.user(Host,User,Password) values('localhost','test',password('1234'));/刷新系统权限表mysql>flush privileges;创建了一个名为：test密码为：1234 的用户。2.登录一下...

Mysql-8 执行授权语句错误：ERROR 1064 (42000)

-大-的博客

02-08

4228

Mysql-8 执行授权语句错误：ERROR 1064 (42000) 今天在mysql执行授权语句 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password'WITH GRANT OPTION; 时提示如下错误： ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQ

配置MySQL接受远程登录连接

weixin_34220834的博客

12-02

534

一开放mysql mysql的配置文件在/etc/mysql/my.cnf文件内，里面有一行bind-address = 127.0.0.1表示只允许本地访问，将这行注释即可 # bind-address = 127.0.0.1 二创建新的mysql用户（1）首先在本地进入mysql数据库的mysql库内 use mysql; （2）创建用户： grant ...

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; ERROR 1819

weixin_41111189的博客

08-27

1万+

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; ERROR 1819 (HY000): Your password does not satisfy the current policy requiremen 问题如上，是由于设置的密码不符合mysql的密码验证规...

grant all privileges on *.* to '***'@'%' identified by '****' with grant option

qq_20173619的博客

01-27

4071

grant all privileges on *.* to '***'@'%' identified by '****' with grant option 原因之一：阿里云安全组原因之二：数据库用户名密码的问题

mysql远程权限grant_mysql数据库设置远程连接权限，执行grant all privileges on *.* to 'root'@'%' identified by '密码' with ...

mysql远程权限grant_mysql数据库设置远程连接权限，执行grant all privileges on . to 'root'@'%' identified by '密码' with ...