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('');
正常了