MYSQL环境搭建,百试不爽系列
第一步
完成的命令
C:\Windows\system32>g:
G:\>cd G:\database\mysql\bin
G:\database\mysql\bin>mysqld --initialize --user=mysql --console
G:\database\mysql\bin>mysqld -install
G:\database\mysql\bin>net start mysql
G:\database\mysql\bin>mysql -u root -p
Enter password: ************
mysql> alter user root@localhost identified by "12345";
mysql> show variables like 'character%';
mysqld --initialize --user=mysql --console
mysqld -install
net start mysql
mysql -u root -p
alter user root@localhost identified by "12345";
---------------------
作者:王小雷-多面手
来源:CSDN
原文:https://blog.csdn.net/dream_an/article/details/51058710
版权声明:本文为博主原创文章,转载请附上博文链接!
第二步
#修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
#更新密码(mysql_native_password模式)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345';