一.使用工具:
1.vmware10虚拟机
2.centos 6.6
3.secureCRT
二.系统设置:
1.安装文件下载目录:/home/tools/
2.mysql安装目录:/usr/local/mysql
三.文件下载:
http://downloads.mysql.com/archives/get/file/mysql-5.7.9-linux-glibc2.5-x86_64.tar
1.在windows系统中下载好tar包,在centos中用rz命令导入到/home/tools/目录中.
2.在centos中使用wget命令下载.
注:rz和wget若没有需要安装才可以使用
![Image 006.png wKiom1gif13iNutBAAAsba1r3SI797.png](http://www.centoscn.com/uploads/allimg/161113/23291562H-0.png)
四.安装:
1.解压包:tar -zxvf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz
![Image 005.png wKioL1gigi3jLFHNAAA1t1RR_7U474.png](http://www.centoscn.com/uploads/allimg/161113/2329156046-1.png)
![Image 008.png wKioL1gimjvSM_GIAAA17qr5Nv0378.png](http://www.centoscn.com/uploads/allimg/161113/232915N96-2.png)
2.改名并移动:mv mysql-5.7.9-linux-glibc2.5-x86_64 /usr/local/mysql
![Image 003.png wKioL1gimw-DJ9qEAABmX2e3b8Q016.png](http://www.centoscn.com/uploads/allimg/161113/2329154a0-3.png)
3.创建mysql用户及组:
[root@study local]# id mysql
id: mysql: No such user
# useradd -s /sbin/nologin -M mysql
注:-s:指定用户登入后所使用的shell。默认值为/bin/bash。
-M:不要自动建立用户的登入目录。
4.修改权限创建data:
# mkdir /usr/local/mysql/data
# cd /usr/local
# chown -R mysql:mysql /usr/local/mysql -R:递归,改变目录及目录下文件权限
![Image 004.png wKiom1giwEzQ7GnpAABtwhNK2JI824.png](http://www.centoscn.com/uploads/allimg/161113/2329154b2-4.png)
5.安装:
[root@study mysql]# ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
![Image 005.png wKioL1giwRyjcwXLAACS8gFxqgo473.png](http://www.centoscn.com/uploads/allimg/161113/2329155027-5.png)
把临时密码记录下来,初次登陆会用到:/lxW+2<(9jk:
配置ssl配置文件:
[root@study mysql]# bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data
![Image 008.png wKioL1gixlKy0s0rAAA-mbN6meA393.png](http://www.centoscn.com/uploads/allimg/161113/2329154T8-6.png)
6.mysql配置:
[root@study mysql]# cd support-files/
#cp my-default.cnf /etc/my.cnf
#cp mysql.server /etc/init.d/mysql
![Image 007.png wKiom1giwtCCxjV3AABvlsaArLw155.png](http://www.centoscn.com/uploads/allimg/161113/2329152Q0-7.png)
7.设置环境变量:
[root@study support-files]# vim /etc/profile
文件最后一行添加:export PATH=/usr/local/mysql/bin:$PATH
wq保存退出
[root@study support-files]# source /etc/profile 环境变量生效
8.设置开机启动:
# chkconfig mysql on
# chkconfig|grep mysql
![Image 004.png wKiom1gixPuRioVnAAAc0_5BkQM095.png](http://www.centoscn.com/uploads/allimg/161113/2329153627-8.png)
9.登陆测试:
查看是否有mysql进程:#ps -ef|grep mysql
#service mysql start
#mysql -uroot -p 回车后粘贴之前记录下来的临时密码,登陆成功
![Image 009.png wKioL1gixsfzoVmLAABZ3wk71D8721.png](http://www.centoscn.com/uploads/allimg/161113/23291534H-9.png)
初次使用要修改临时密码
![Image 011.png wKioL1giyE_waweGAAAYw2B3Sjg192.png](http://www.centoscn.com/uploads/allimg/161113/2329153256-10.png)
:修改密码
mysql> set password=password('A123456');
mysql授权:
mysql> grant all privileges on *.* to root@'%' identified by 'A123456';
更新权限:
mysql> flush privileges;
![Image 013.png wKiom1gizELw6zi-AAA9UCTRHoI981.png](http://www.centoscn.com/uploads/allimg/161113/2329156444-11.png)
![Image 016.png wKioL1gizH-gize0AAAcJ5wZArY656.png](http://www.centoscn.com/uploads/allimg/161113/23291510U-12.png)
已经可以正常使用.