Mr_chenweida的博客

防火墙原因设置防火墙 3306为mysql默认端口firewall-cmd --zone=public --add-port=3306/tcp --permanent重启防火墙systemctl restart firewalld

cd /etc/mysql/mysql.conf.d/（没有找到就去 /etc/my.cnf ）sudo vim mysqld.cnf在[mysqld] 下添加sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"重启mysql：/etc/init.d/mysql restart (Debia.

- mysql -u root -p # 先登录mysql - use mysql # 切换到mysql这个数据库 - select host from user where user='root'; # 会发现root这个用户只有localhost权限 - update user set host = '%' where user ='root'; # 更改权限 - flush privileges; # 刷新数据库，成功解决...

在mysql交互模式下输入：1、mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘12345’ WITH GRANT OPTION;2、mysql> flush privileges;3、cd /etc/mysql/mysql.conf.d修改文件sudo gedit mysqld.cnf注释掉这句话：#bind-address = 127.0.0.14、/etc/init.d/mysql r

1、mysql –uroot –p #进入mysql环境，语法：mysql –u用户名 –p数据库密码2、mysql> set password for ‘root’@’%’ =password(‘数据库英文密码’); #设置mysql数据库密码3、mysql> FLUSH PRIVILEGES; # 刷新权限，授权修改生效4、当再用Navicat连接时，密码输入上面修改的密码...