CentOS 7.6 Mysql离线安装，Mysql-5.7.29安装，tar.gz安装

1.解压

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

2.移动并将解压文件夹改名/data1/mysql5.7.29下(注:数据存储在/data1目录下)

mv mysql-5.7.29-linux-glibc2.12-x86_64 /data1/mysql5.7.29

3.再创建用户和用户组

groupadd mysql

useradd -r -g mysql mysql

cd /data1/mysql5.7.29

mkdir data mysql_log mysql_pid

touch /data1/mysql5.7.29/mysql_log/mysql.log

touch /data1/mysql5.7.29/mysql_pid/mysql.pid

5.更改文件的权限

chown -R mysql.mysql /data1/mysql5.7.29

6.关于my.cnf的配置

[root@localhost] vi /etc/my.cnf

[mysqld]

bind-address=0.0.0.0

port=3306

user=mysql

basedir= /data1/mysql5.7.29

datadir= /data1/mysql5.7.29/data

socket=/tmp/mysql.sock

log-error=/data1/mysql5.7.29/mysql_log/mysql.log

pid-file=/data1/mysql5.7.29/mysql_pid/mysql.pid

character_set_server=utf8

symbolic-links=0

[mysql]

default-character-set = utf8

[mysqld_safe]

!includedir /etc/my.cnf.d

7.初始化数据库

/data1/mysql5.7.29/bin/mysqld

--user=mysql

--basedir=/data1/mysql5.7.29

--datadir=/data1/mysql5.7.29/data

--initialize

密码保存路径：/data1/mysql5.7.29/mysql_log/mysql.log文件中,如下图：

cat /data1/mysql5.7.29/mysql_log/mysql.log

2021-10-22T06:36:02.581231Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2021-10-22T06:36:03.515804Z 0 [Warning] InnoDB: New log files created, LSN=45790

2021-10-22T06:36:03.754344Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2021-10-22T06:36:03.891926Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 544ce401-3302-11ec-a85d-702084302102.

2021-10-22T06:36:03.907816Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2021-10-22T06:36:04.607437Z 0 [Warning] CA certificate ca.pem is self signed.

2021-10-22T06:36:04.837732Z 1 [Note] A temporary password is generated for root@localhost: -M(0+ThNqEok

8.设置mysql开机自启

cp /data1/mysql5.7.29/support-files/mysql.server /etc/init.d/mysql

chkconfig --add mysql

chkconfig

9.启动mysql（如果遇到异常，请确认data, mysql_log, mysql_pid的文件权限）

service mysql start

10.登录(密码在步骤7)

/data1/mysql5.7.29/bin/mysql -uroot -p

11.修改密码（引号内设置自己的密码）

set password=password("**自己的密码**");

flush privileges;

12.设置远程连接

grant all privileges on *.* to 'root'@'%'identified by '** 自己的密码**' with grant option;

flush privileges;

13.再次查询用户表命令：

use mysql;

select User,authentication_string,Host from user;

+---------------+-------------------------------------------+-----------+

| User | authentication_string | Host |

+---------------+-------------------------------------------+-----------+

| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | localhost |

| mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost |

| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost |

| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | % |

+---------------+-------------------------------------------+-----------+

14.如果mysql远程还是连接不上，请检查防火墙是否关闭！(centos7)

firewall-cmd --state

systemctl stop firewalld.service

systemctl disable firewalld.service

15.关于Mysql登录密码错误的处理

vi/etc/my.cnf

skip-grant-tables # [mysqld]下添加该项，然后重启mysql : service mysql restart 然后进入mysql

mysql> flush privileges;

ERROR 1290 (HY000): The MySQL server is running withthe --skip-grant-tables option so it cannot execute this statement

mysql> set password for root@localhost=password('**密码**');

mysql> flush privileges;

再注销# skip-grant-tables

再重启mysql

最后编辑于：2021.10.22 15:44:17

禁止转载，如需转载请通过简信或评论联系作者。