linux下安装mysql5.7.31_linux下安装mysql5.7.31(实战记录)

按照我的执行步骤和执行命令&＃xff0c;依次执行即可&＃xff0c;过程如下&＃xff1a;

1、查看是否存在mysql用户的命令&＃xff1a;

cat /etc/group | grep mysql

cat /etc/passwd |grep mysql

2、增加 mysql 用户的命令&＃xff1a;

groupadd mysql

useradd -r -g mysql mysql

3、

mysql 5.7.31版本下载路径&＃xff1a;

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

下载后安装步骤同上&＃xff0c;注意 改密码那个步骤略微有不同。

1、linux上执行下载命令&＃xff1a;wget  https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

2、网页上的下载如下所示&＃xff1a;

4、tar -zxvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz

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

5、

chmod -R 755 /usr/local/mysql

mkdir -p /data/mysql #创建目录

chown mysql:mysql -R /data/mysql #网上的 赋予权限

chmod 777 /data/mysql #自己给赋的权限

6、改写配置文件

[mysqld]

#datadir&＃61;/var/lib/mysql

#socket&＃61;/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

#symbolic-links&＃61;0

# Settings user and group are ignored when systemd is used.

# If you need to run mysqld under a different user or group,

# customize your systemd unit file for mariadb according to the

# instructions in http://fedoraproject.org/wiki/Systemd

bind-address&＃61;127.0.0.1

port&＃61;3306

user&＃61;mysql

basedir&＃61;/usr/local/mysql

datadir&＃61;/data/mysql

socket&＃61;/tmp/mysql.sock

#socket&＃61;/data/mysql/mysql.sock

log-error&＃61;/data/mysql/mysql.err

pid-file&＃61;/data/mysql/mysql.pid

##character config

character_set_server&＃61;utf8mb4

symbolic-links&＃61;0

explicit_defaults_for_timestamp&＃61;true

[mysqld_safe]

#log-error&＃61;/var/log/mariadb/mariadb.log

log-error&＃61;/data/mysql/mariadb.log

#pid-file&＃61;/var/run/mariadb/mariadb.pid

pid-file&＃61;/data/mysql/mariadb.pid

#

# include all files from the config directory

#

!includedir /etc/my.cnf.d

7、

./mysqld --initialize --user&＃61;mysql --datadir&＃61;/data/mysql --basedir&＃61;/usr/local/mysql

查看密码 cat /data/mysql/mysql.err

8、

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

service mysql start

ps -ef|grep mysql

9、

./mysql -u root -p #bin目录下

./mysql -uroot -h 127.0.0.1 -p

SET PASSWORD &＃61; PASSWORD(&＃39;Qwertyuiop1&＃39;);

ALTER USER &＃39;root&＃39;&＃64;&＃39;localhost&＃39; PASSWORD EXPIRE NEVER;

或执行命令&＃xff1a;set password for root&＃64;localhost &＃61; password(&＃39;Qwertyuiop1&＃39;);

FLUSH PRIVILEGES;

10、开启远程连接功能

use mysql;

update user set user.Host&＃61;&＃39;%&＃39; where user.User&＃61;&＃39;root&＃39;;

flush privileges;