1. mysql 忘记root 密码 mysqld_safe --skip-grant-tables &
UPDATE mysql.user SET authentication_string = PASSWORD('MY_NEW_PASSWORD') WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;
登录mysql 重新设置密码 SET PASSWORD = PASSWORD('cMY_NEW_PASSWORD');
FLUSH PRIVILEGES;
2. create database wordpress default character set utf8 collate utf8_general_ci;
3. grant all privileges on wordpress.* to wordpress@'localhost' identified by'PASSWORD';
mysql8
1.Navicat连MySql8报错的问题
用mysql命令行登陆mysql，执行以下命令，修改加密方式
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
mysql> FLUSH PRIVILEGES;
2.允许远程连接Mysql8
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'root';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
mysql> flush privileges;
