mysql二进制安装包mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz 安装步骤

1、从官网下载下载二进制安装包mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz

2、通过rz上传至服务器的指定目录，并解压

tar -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz

得到目录mysql-5.7.29-linux-glibc2.12-x86_64

 

 

 3、检查系统是否默认安装mysql或者mariadb

rpm -qa|grep -i mysql

rpm -qa|grep -i mariadb

 

 

 通过rpm -e卸载已安装的包

4、创建用户和组

groupadd  mysql

useradd -g mysql -d /data mysql

5、 mysql的base目录变更

mv mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/mysql

chown -R mysql:mysql /usr/local/mysql

6、创建数据目录和日志目录

cd /data

mkdir mysql log

7、编辑my.cnf配置文件

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
basedir=/usr/local/mysql
datadir=/data/mysql
port = 3306
socket=/tmp/mysql.sock

log-error=/data/log/mysqld.log
pid-file=/tmp/mysqld/mysqld.pid

log-bin=mysql-bin
binlog-format=ROW
max_connections=500
character-set-server=utf8

8、初始化数据库

cd /usr/local/mysql/bin/

./mysqld --initialize --user=mysql --basedir=/usr/local/mysql--datadir=/data/mysql

启动数据库

./mysqld_safe --user=mysql &

 

 

 9、修改初始root密码

通过安装日志找到初始密码

# grep password /data/log/mysqld.log

# ./mysql -u root -p

mysql> set password=password("xxxxxxxxx")

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

mysql> flush privileges;

10、设置开机自启动

cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chkconfig --add mysql
chkconfig --list mysql

11、设置快捷命令

ln -s /usr/local/mysql/bin/mysql /usr/bin