CentOS7 安装单机 Mysql

我会带着你远行 2021-09-29 06:30 419阅读 0赞

1.解压文件

\[root@centos3 ~\]\# tar -zxvf mysql-5.7.19-linux-glibc2.12-x86\_64.tar.gz -C /usr/local/

![1250673-20170930113924106-107368634.png][]

#### 2.重命名 ####

\[root@centos3 ~\]\# cd /usr/local/

\[root@centos3 local\]\# mv mysql-5.7.19-linux-glibc2.12-x86\_64/ mysql

![1250673-20170930114326653-308004593.png][]

#### 3.配置环境变量 ####

\[root@centos3  local\]\# vi + /etc/profile

![1250673-20170930114622715-986634533.png][]

\[root@centos3  local\]\# source  /etc/profile

#### 4.创建组和用户并授权 ####

\[root@centos3 local\]\# groupadd mysql

\[root@centos3 local\]\# useradd -r -g mysql -s /bin/false mysql

\[root@centos3 local\]\# chown -R mysql mysql/  
\[root@centos3 local\]\# chgrp -R mysql mysql/

![1250673-20170930115443512-1419532963.png][]

#### 5.修改mysql.server.文件并复制到 /etc/init.d/目录下 ####

\[root@centos3 local\]\# cd /usr/local/mysql/support-files/  
\[root@centos3 support-files\]\# vi mysql.server

![1250673-20170930120228997-621243457.png][]

\[root@centos3 support-files\]\# cp mysql.server /etc/init.d/mysqld

**6.设置开机启动**

\[root@centos3 support-files\]\# chmod +x /etc/init.d/mysqld  
\[root@centos3 support-files\]\# chkconfig --add mysqld  
\[root@centos3 support-files\]\# chkconfig mysqld on

//查看开机启动是否成功

\[root@centos3 support-files\]\# chkconfig --list mysqld

![1250673-20170930120455309-839080781.png][]

#### 7.编辑my.cnf ####

\#\#\#修改/etc/my.cnf中datadir的值和/usr/local/mysql/support-files/mysql.server中的datadir的值一样

\[root@centos3 support-files\]\# vi /etc/my.cnf

#### ![1250673-20190611103908081-484639953.png][] ####

#### 8.为/etc/my.cnf中socket创建目录 和log-error创建目录及文件并修改用户和组 ####

\[root@centos3 local\]\# mkdir /var/run/mariadb

\[root@centos3 local\]\# chown -R mysql /var/run/mariadb  
\[root@centos3 local\]\# chgrp -R mysql /var/run/mariadb

\[root@centos3 local\]\# mkdir /var/log/mariadb

\[root@centos3 local\]\# touch /var/log/mariadb/mariadb.log

\[root@centos3 local\]\# chown -R mysql /var/log/mariadb  
\[root@centos3 local\]\# chgrp -R mysql /var/log/mariadb

\[root@centos3 local\]\# mkdir /var/lib/mysql

\[root@centos3 local\]\# chown -R mysql /var/lib/mysql

*\[root@centos3 local\]\# chgrp -R mysql /var/lib/mysql*

**9.初始化并记住最后的12位密码**

\[root@centos3 local\]\#  /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --lc\_messages\_dir=/usr/local/mysql/share --lc\_messages=zh\_CN

![1250673-20170930115553825-352970870.png][]

**10.启动服务**

\[root@centos3 support-files\]\# /etc/init.d/mysqld start  
\[root@centos3 support-files\]\# service mysql start

![1250673-20170930121125950-89493843.png][]

#### 11.为/etc/my.cnf中socket文件创建软连接 ####

\[root@centos3 support-files\]\# ln -s /var/lib/mysql/mysql.sock /tmp/

#### 12.登录修改密码，密码就是第5步系统生成的 ####

\[root@centos3 support-files\]\# mysql -uroot -p

mysql> set password=password("1234");

![1250673-20170930121518965-1629762397.png][]

转载于:https://www.cnblogs.com/jottings/p/7614523.html

[1250673-20170930113924106-107368634.png]: /images/20210726/d23098762d324b07899afaa3f370acdd.png
[1250673-20170930114326653-308004593.png]: /images/20210726/7cba7b2c25814e3493427439fa7228ac.png
[1250673-20170930114622715-986634533.png]: /images/20210726/80fff5e11f1d47b5a267a2259510b8da.png
[1250673-20170930115443512-1419532963.png]: /images/20210726/a0c5eb20836942209b4b28da829f33ea.png
[1250673-20170930120228997-621243457.png]: /images/20210726/ceae201d9a8845b6aba5413ebb7f9fca.png
[1250673-20170930120455309-839080781.png]: /images/20210726/d7ae122f717f4897966a3b0742545625.png
[1250673-20190611103908081-484639953.png]: /images/20210726/07c1bf5d604d4f9aab0baa0cf9929012.png
[1250673-20170930115553825-352970870.png]: /images/20210726/8710c4d843f148ccbf101cd9f8a840eb.png
[1250673-20170930121125950-89493843.png]: /images/20210726/2a726dc7ab4943389554213938c85e83.png
[1250673-20170930121518965-1629762397.png]: /images/20210726/222bf968ee1f4475870c2329625da1af.png