初始化完毕后,如果没使用新版本的客户端登入,还会报告类似下面的错误:
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