首先到官网下载MySQL的源码包
由于家里网速不好,等了好久才在官网上找到tar.gz包。不能不吐槽下这网络,选择version和platform的JS都失效,只能上阿里云通过curl来找到。
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
首先,先查看当前系统是否已安装过MySQL
#rpm -a代表all,-q代表query
[root@iZ283rmolcfZ download]# rpm -aq | grep -i mysql
mysql-libs-5.1.73-3.el6_5.x86_64
#卸载mysql
[root@iZ283rmolcfZ download]# yum -y remove mysql-libs*
1.增加用户mysql(系统用户)
#-M不创建home目录,-s指定shell为不登录 useradd -M -s /bin/nologin mysql
2.开始安装
#解压mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
tar -zxvf mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
#将解压的文件复制到安装路径/usr/local/mysql
cp -r mysql-5.6.21 /usr/local/mysq
cd /usr/local/mysq
cp support-files/my-default.cnf /etc/my.cnf
chmod 644 /etc/my.cnf
#修改my.cnf
vim /etc/my.cnf
user=mysql
datadir=/data/mysql
#创建/data/mysql
mkdir -p /data/mysql
chwon -R mysql:mysql /data/mysql
#初始化数据库
scripts/mysql_install_db --initialize
留意最后1行,root账号的初始密码
2017-02-21T13:49:42.616172Z 1 [Note] A temporary password is generated for root@localhost: -8s<iMutfDy<
#启动MySQLscripts/mysql_install_db 或者 service mysql start
3.设置开机自动启动
cd /usr/local/mysql/support-files #注册服务 cp mysql.server /etc/rc.d/init.d/mysql #让chkconfig管理mysql服务 chkconfig --add mysql #开机启动 chkconfig mysql on
4.修改MySQL的root密码
#由于没有设置密码,直接使用命令mysql就可以登录
mysql
use mysql
#将User为空的用户加上用户名
update user set User='xxx' where User='';
#设置root的密码
update user set Password=password('xxxxx') where User='root';
#刷新权限
flush privileges;
#或者使用下面这句SQL
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;
mysql修改报错:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement
解决:
alter user 'root'@'localhost' identified by 'root';