mysql安装

系统环境

CentOS Linux release 7.7.1908

1.下载mysql

mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

2.将文件放置/usr/local目录下

3.解压文件

tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

4.将解压后的文件重命名为mysql

mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql

5.创建mysql用户组及用户

groupadd mysql
useradd -r -g mysql mysql

6.进入到mysql目录，执行添加mysql配置的操作

cp support-files/my-default.cnf /etc/my.cnf

7.修改/etc/my.cnf文件内容

basedir =/usr/local/mysql
datadir =/data/mysql

explicit_defaults_for_timestamp=true
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
max_allowed_packet = 20K
8.在mysql当前目录下设定目录的访问权限

chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data

9.初始化数据，进入mysql/bin目录

./mysql_install_db --verbose --user=root --defaults-file=/etc/my.cnf --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql --pid-file=/usr/local/mysql/data/mysql.pid --tmpdir=/tmp

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

10.启动mysql，进入/usr/local/mysql/bin目录，执行下面命令

./mysqld_safe --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root &

 

11.设置开机启动，新开启shell中断后，进入mysql目录，执行下面命令

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql

chmod 700 /etc/init.d/mysql
chkconfig --add mysqld
chkconfig --level 2345 mysqld on
chown mysql:mysql -R /usr/local/mysql/

12.添加mysql命令

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

13.登录mysql,执行下面命令
mysql -uroot -p 
密码为空直接回车,运行以下两条命令
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' with grant option;
Flush privileges;

14.修改密码

set password=password('123456')

或update user set authentication_string=passworD("123456") where user='root';