标签: mysql

2 篇文章

Navicat Premium打开数据库出现:1449 – The user specified as a definer (‘mysql.infoschema’@’localhost’) does not exist
由于mysql_upgrade 功能在 mysql8.0 之后版本已经停用了,所以用一下命令即可mysql -u root -p #你的root密码 use mysql create user 'mysql.infoschema'@'%' identified by '密码'; grant all privileges on *.* to 'mys…
mysql出现ERROR 1130 (HY000): Host ‘172.17.42.1’ is not allowed to connect to this MySQL server
ERROR 1130: Host ... is not allowed to connect to this MySQL server说明所连接的用户帐号没有远程连接的权限,只能在本机(localhost)登录。 需更改 mysql 数据库里的 user表里的 host项把localhost改称%具体步骤:登陆到MySQL 首先 use mysql…