1:查看系统版本
1 2 | [root@10-4-5-9 mysql]# cat /etc/redhat-release CentOS release 6.5 (Final) |
2:下载MySQL5.6二进制包
1 | #wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.6/mysql-5.6.39-linux-glibc2.12-x86_64.tar.gz |
3:添加用户和组
1 2 | #groupadd mysql #useradd -g mysql mysql |
4:安装mysql到/usr/local/mysql下
1 2 3 4 5 6 7 | #cd /usr/ local #tar zxvf /{MySQL5.6_path}/mysql-{version}.tar.gz 例如我的配置路径为: #cd /usr/ local #tar zxvf /root/mysql-5.6.20-linux-glibc2.5-i686.tar.gz |
5:修改解压后文件夹名为 mysql
1 | #mv mysql-5.6.20-linux-glibc2.5-i686 mysql |
6:修改mysql的各级文件夹和文件的创建者、创建组为mysql(注意语句后面有个.)
1 2 3 | cd mysql chown -R mysql . chgrp -R mysql . |
7:至此mysql已经安装完了,但还需要初始化,初始化mysql表、test表、infomation表等。
1 | #scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data<br><br> |
1 | #cp support-files/mysql.server /etc/init.d/mysqld |
1 2 3 | --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data |
1 2 | PS:该步骤有可能会报错误 安装需要的包即可:libstdc++.so.6和libaio.so.1和libncurses.so.5 |
8:修改配置文件
1 2 3 | [root@10-4-5-9 mysql]# cp my.cnf /etc/my.cnf /usr/ local /mysql [root@10-4-5-9 mysql]# vi /etc/my.cnf |
1 2 3 4 5 6 | [mysqld]中添加: basedir = /usr/ local /mysql datadir = /usr/ local /mysql/data port = 3306 server_id = 1 |
9:启动mySQL服务
1 | #ln -s /usr/ local /mysql/bin/mysql /usr/bin |
10:登陆MySQL并且删除空用户
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | mysql> SELECT user ,host, password FROM mysql. user ; + ------+-----------+----------+ | user | host | password | + ------+-----------+----------+ | root | localhost | | | root | 10-4-5-9 | | | root | 127.0.0.1 | | | root | ::1 | | | | localhost | | | | 10-4-5-9 | | + ------+-----------+----------+ 6 rows in set (0.00 sec) mysql> UPDATE mysql. user set password = PASSWORD ( 'kunge' ) WHERE user = 'root' ; mysql> DROP USER '' @localhost; mysql> FLUSH PRIVILEGES ; |