1.下载mysql5.6的二进制安装包
#wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.26-linux-glibc2.5-i686.tar.gz
2.添加用户和组
#groupadd mysql #useradd -g mysql mysql
3.解压安装包
#tar zxvf mysql-5.6.26-linux-glibc2.5-i686.tar.gz
4.修改文件夹名为mysql
#mv mysql-5.6.26-linux-glibc2.5-i686 mysql
5.修改mysql的各级文件夹和文件的创建者、创建组为mysql(注意语句后面有个.)
#cd mysql #chown -R mysql . #chgrp -R mysql .
6.初始化mysql
#scripts/mysql_install_db --user=mysql --basedir=/data/mysql --datadir=/data/mysqldata #cp support-files/mysql.server /etc/init.d/mysqld
如果出现类似提示:/lib/ld-linux.so.2: bad ELF interpreter: 没有那个文件或目录
#yum install glibc.i686
如果出现类似提示:error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file or directory
#yum install libstdc++ #yum install libstdc++.so.6
如果出现类似提示:Installing MySQL system tables.../data/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
#yum install libaio.so.1
7.修改配置文件:
#cp my.cnf /etc/my.cnf #vim /etc/my.cnf
添加一下内容
basedir = /usr/local/mysql datadir = /usr/local/mysql/data port = 3306 server_id = 11
8.启动mysql
#ln -s /data/mysql/bin/mysql /usr/bin #service mysqld start
9.登陆mysql ,并删除空用户
#mysql #mysql > SELECT user,host,password FROM mysql.user; #mysql > update mysql.user set password =password('imouse7914') where user='root'; #mysql > DROP USER ''@localhost; #mysql> FLUSH PRIVILEGES;