ubuntu14.10安装mysql 5.7.15

参考 http://dev.mysql.com/doc/refman/5.7/en/binary-installation.html

groupadd mysql

shell> useradd -r -g mysql -s /bin/false mysql

shell> cd /usr/local

shell> tar zxvf /usr/xxx/Downloads/mysql-VERSION-OS.tar.gz

shell> ln -s /usr/local/mysql/xxx-VERSION-OS mysql

shell> cd mysql

shell> mkdir mysql-files

shell> chmod 750 mysql-files

shell> chown -R mysql .

shell> chgrp -R mysql .

shell> bin/mysqld --initialize --user=mysql

shell> bin/mysql_ssl_rsa_setup

shell> chown -R root .

shell> chown -R mysql data mysql-files

shell> bin/mysqld_safe --user=mysql &# Next command is optional

shell> cp support-files/mysql.server /etc/init.d/mysql.server

登陆mysql出现 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

先停止服务

xx@ubuntu:/usr/local/mysql$ sudo ./support-files/mysql.server stop

通过下面命令取消密码

root@ubuntu:/usr/local/mysql/bin# ./mysqld_safe --user=mysql --skip-grant-tables --skip-networking&

在新窗口中登陆（ctrl+alt+F3-6）

mysql -u root -p

登陆后修改密码

 update mysql.user set authentication_string=PASSWORD('****') where user='root' 

flush privileges;

再次登陆后，在修改一次密码

set password=Password('');

正常了