mysql-5.7.19 压缩安装 设置密码

初始化完毕后,如果没使用新版本的客户端登入,还会报告类似下面的错误: 
mysql -uroot -p
Enter password:
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords.

上面的错误提示意思是需要用当前版本的客户端登入,因为新用户登入后需要立刻修改密码,否则无法继续后续的工作:
[(root@imysql.com)]>use mysql
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

[(root@imysql.com)]>set password = password('abcd');
Query OK, 0 rows affected, 1 warning (0.00 sec)
修改完密码后,就可以继续使用旧版本的客户端工具了。

mysql -u root -p
use mysql;
update user set authentication_string=password('您的密码') where user='root';
flush privileges;
exit

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
SET PASSWORD FOR 'root'@'%' = PASSWORD('newpass');

http://blog.csdn.net/supercrsky/article/details/64443618

http://www.cnblogs.com/rysinal/p/7565259.html
http://blog.csdn.net/bkjs626/article/details/75977262

linux安装
http://blog.csdn.net/zhou920786312/article/details/77750604

下载地址:
https://dev.mysql.com/downloads/mysql/

主从配置:
https://blog.csdn.net/qq_25663723/article/details/53695695

上一篇:java文件上传到服务器


下一篇:express+handlebars 快速搭建网站前后台