linux mysql部署

今天药忘吃喽~ 2023-07-13 03:46 1阅读 0赞

1.下载：

https://dev.mysql.com/downloads/mysql/5.7.html\#downloads

2.环境配置

检测系统是否自带Mysql

rpm -qa|grep mysql

如果有进行强行卸载

rpm -e --nodeps mysql-5.7.28-linux-glibc2.12-x86\_64

检测系统是否自带mariadb

rpm -qa|grep mariadb

![image.png][]

rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86\_64

3.安装

进入安装包所在目录，解压文件

cd /usr/local/src

tar -zxvf mysql-5.7.28-linux-glibc2.12-x86\_64.tar.gz

4.重命名

mv mysql-5.7.28-linux-glibc2.12-x86\_64 mysql

检查mysql组和用户是否存在，如果没有则创建

cat /etc/group|grep mysql

groupadd mysql

useradd -r -g mysql mysql

\#useradd -r参数表示mysql用户是系统用户，不可用于登录系统

5.安装数据库

创建data目录

cd /mysql

mkdir data

6.更改mysql目录下所有的目录及文件夹所属的用户组和用户，以及权限

\[root@localhost /\]\# chown -R mysql:mysql /usr/local/src/mysql

\[root@localhost /\]\# chmod -R 755 /usr/local/src/mysql

7.在mysql/support-files目录下创建my.cnf

[mysqld]
    
    
    [mysqld]
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
    basedir = /usr/local/src/mysql
    datadir = /usr/local/src/mysql/data
    port = 3306
    socket = /tmp/mysql.sock
    character-set-server=utf8
    
    log-error = /usr/local/src/mysql/data/mysqld.log
    pid-file = /usr/local/src/mysql/mysqld.pid
    #允许时间类型的数据为零(去掉NO_ZERO_IN_DATE,NO_ZERO_DATE)
    sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    #ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

拷贝my.cnf 到/etc/my.cnf

cp my.cnf /etc/my.cnf

8.初始化mysql

cd /usr/local/src/mysql/

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/src/mysql/ --datadir=/usr/local/src/mysql/data/  --pid-file=/usr/local/src/mysql/mysql.pid

9.查看临时密码

cat /usr/local/src/mysql/data/mysqld.log

A temporary password is generated for root@localhost: 6\_:75Wkc!.dg

10.把启动脚本放到开机初始化目录

cp support-files/mysql.server /etc/init.d/mysql

11.启动mysql

service mysql start

12.进入mysql并更改密码

cd /usr/local/src/mysql

./bin/mysql -u root -p

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

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

mysql> flush privileges;

****

[image.png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9jZG4ubmxhcmsuY29tL3l1cXVlLzAvMjAyMC9wbmcvNjM3NzUzLzE1ODM4MDg3MTUzODgtMmIwMzJjZWQtOTMyZi00ODViLWFmYTctZGQ5NmE2ZTk3MWFmLnBuZw?x-oss-process=image/format,png