centos6.6安装mysql5.7.9tar包

拼搏现实的明天。 2022-07-14 07:09 269阅读 0赞

一.使用工具:

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][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若没有需要安装才可以使用

[![wKiom1gif13iNutBAAAsba1r3SI797.png][]][wKiom1gif13iNutBAAAsba1r3SI797.png]

四.安装:

1.解压包:tar -zxvf mysql-5.7.9-linux-glibc2.5-x86\_64.tar.gz

[![wKioL1gigi3jLFHNAAA1t1RR\_7U474.png][wKioL1gigi3jLFHNAAA1t1RR_7U474.png]][wKioL1gigi3jLFHNAAA1t1RR_7U474.png]

[![wKioL1gimjvSM\_GIAAA17qr5Nv0378.png][wKioL1gimjvSM_GIAAA17qr5Nv0378.png]][wKioL1gimjvSM_GIAAA17qr5Nv0378.png]

2.改名并移动:mv mysql-5.7.9-linux-glibc2.5-x86\_64 /usr/local/mysql

[![wKioL1gimw-DJ9qEAABmX2e3b8Q016.png][]][wKioL1gimw-DJ9qEAABmX2e3b8Q016.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:递归,改变目录及目录下文件权限

[![wKiom1giwEzQ7GnpAABtwhNK2JI824.png][]][wKiom1giwEzQ7GnpAABtwhNK2JI824.png]

5.安装:

\[root@study mysql\]\# ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

[![wKioL1giwRyjcwXLAACS8gFxqgo473.png][]][wKioL1giwRyjcwXLAACS8gFxqgo473.png]

把临时密码记录下来,初次登陆会用到:/lxW+2<(9jk:

配置ssl配置文件:

\[root@study mysql\]\# bin/mysql\_ssl\_rsa\_setup --datadir=/usr/local/mysql/data

[![wKioL1gixlKy0s0rAAA-mbN6meA393.png][]][wKioL1gixlKy0s0rAAA-mbN6meA393.png]

6.mysql配置:

\[root@study mysql\]\# cd support-files/

\#cp my-default.cnf /etc/my.cnf

\#cp mysql.server /etc/init.d/mysql

[![wKiom1giwtCCxjV3AABvlsaArLw155.png][]][wKiom1giwtCCxjV3AABvlsaArLw155.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

[![wKiom1gixPuRioVnAAAc0\_5BkQM095.png][wKiom1gixPuRioVnAAAc0_5BkQM095.png]][wKiom1gixPuRioVnAAAc0_5BkQM095.png]

9.登陆测试:

查看是否有mysql进程:\#ps -ef|grep mysql

\#service mysql start

\#mysql -uroot -p 回车后粘贴之前记录下来的临时密码,登陆成功

[![wKioL1gixsfzoVmLAABZ3wk71D8721.png][]][wKioL1gixsfzoVmLAABZ3wk71D8721.png]

初次使用要修改临时密码

[![wKioL1giyE\_waweGAAAYw2B3Sjg192.png][wKioL1giyE_waweGAAAYw2B3Sjg192.png]][wKioL1giyE_waweGAAAYw2B3Sjg192.png]

:修改密码

mysql> set password=password('A123456');

mysql授权:

mysql> grant all privileges on \*.\* to root@'%' identified by 'A123456';

更新权限:

mysql> flush privileges;

[![wKiom1gizELw6zi-AAA9UCTRHoI981.png][]][wKiom1gizELw6zi-AAA9UCTRHoI981.png]

[![wKioL1gizH-gize0AAAcJ5wZArY656.png][]][wKioL1gizH-gize0AAAcJ5wZArY656.png]

已经可以正常使用.

[http_downloads.mysql.com_archives_get_file_mysql-5.7.9-linux-glibc2.5-x86_64.tar]: http://downloads.mysql.com/archives/get/file/mysql-5.7.9-linux-glibc2.5-x86_64.tar
[wKiom1gif13iNutBAAAsba1r3SI797.png]: /images/20220714/6ea72267e186449eb2d72e3dab585dd4.png
[wKioL1gigi3jLFHNAAA1t1RR_7U474.png]: /images/20220714/41de1145bd8f4ce494020dc7cab6473a.png
[wKioL1gimjvSM_GIAAA17qr5Nv0378.png]: /images/20220714/ecab50a122e24acf9255f8cb233f2565.png
[wKioL1gimw-DJ9qEAABmX2e3b8Q016.png]: /images/20220714/c6af665015f242fdafebe5b747fab1fb.png
[wKiom1giwEzQ7GnpAABtwhNK2JI824.png]: /images/20220714/62b46bde4a5a4425b7e623824519dc37.png
[wKioL1giwRyjcwXLAACS8gFxqgo473.png]: /images/20220714/9a0c800a3ae44bd2b4d22bcff710dacd.png
[wKioL1gixlKy0s0rAAA-mbN6meA393.png]: /images/20220714/d4f01368798f402dbc0bcaf4be6e837f.png
[wKiom1giwtCCxjV3AABvlsaArLw155.png]: /images/20220714/e134275ade6a4a6fa9d5e873f5182c09.png
[wKiom1gixPuRioVnAAAc0_5BkQM095.png]: /images/20220714/2c0f1f9cb2c54ebaa3faeb98310c357e.png
[wKioL1gixsfzoVmLAABZ3wk71D8721.png]: /images/20220714/bccbeeb493284b6899c5f669e3faf424.png
[wKioL1giyE_waweGAAAYw2B3Sjg192.png]: /images/20220714/98fb68466c4846fb87449c076a8dfc62.png
[wKiom1gizELw6zi-AAA9UCTRHoI981.png]: /images/20220714/c4908bdaec5e4a5880697a4e4e745426.png
[wKioL1gizH-gize0AAAcJ5wZArY656.png]: /images/20220714/07482c36405349aba8b2c06175504a70.png