Ubuntu安装Myslq5.7

发表于2020-08-03更新于2023-02-22字数统计885

1.下载 Myslq5.7

下载地址：https://downloads.mysql.com/archives/community/

图片加载失败

2.移动压缩包并解压

图片中的目录是本人创建的用于安装各种环境的目录，根据个人习惯不同目录可自行创建。

图片加载失败

3.重命名解压后的文件夹

将解压后的文件夹重命名为 mysql-5.7.30

1
mv mysql-5.7.30-linux-glibc2.12-x86_64 mysql-5.7.30

4.添加用户组

1
groupadd mysql

5.添加用户

1
useradd -r -g mysql mysql

6.更新系统依赖环境

1
apt-get update

7.下载libaio依赖

1
apt-get install libaio*

8.下载libncurses依赖

1
2
apt-get install libncurses*
#执行玩以上命令会问你是否继续执行。输入 Y 继续执行

9.创建data目录

1
2
cd mysql-5.7.30
mkdir data

10.将mysql-5.7.30的所有者以及所属组改为mysql

1
chown -R mysql:mysql /usr/Environment/Mysql/mysql-5.7.30

11.在/usr/Environment/Mysql/mysql-5.7.30/support-files目录下创建my_default.cnf

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[mysql]
default-character-set=utf8
socket=/tmp/mysql.sock
[mysqld]
port=3306
socket=/tmp/mysql.sock
#根据个人目录不同basedir、datadir需要选择你自己的目录
basedir=/usr/Environment/Mysql/mysql-5.7.30
datadir=/usr/Environment/Mysql/mysql-5.7.30/data
max_connections=250
character-set-server=utf8
default-storage-engine=INNODB
max_allowed_packet=16M
log-error=/usr/Environment/Mysql/mysql-5.7.30/data/mysqld.log
pid-file=/usr/Environment/Mysql/mysql-5.7.30/data/mysqld.pid

12.将my_default.cnf拷贝至/etc/mysql下

1
cp my_default.cnf /etc/mysql/my.cnf

13.初始化mysqld

1
2
cd /usr/Environment/Mysql/mysql-5.7.30
./bin/mysqld --initialize --user=mysql --basedir=/usr/Environment/Mysql/mysql-5.7.30/ --datadir=/usr/Environment/Mysql/mysql-5.7.30/data/

14.初始化完成后查看日志中的临时密码

1
2
cd data/
cat mysqld.log

临时密码为：i>;+lyB5Ojon

1
2
3
4
5
6
7
2020-08-07T07:37:17.198965Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-08-07T07:37:17.594529Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-08-07T07:37:17.700675Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-08-07T07:37:17.769067Z 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: d1ee4afd-d880-11ea-8942-a0c589328791.
2020-08-07T07:37:17.772722Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-08-07T07:37:19.446295Z 0 [Warning] CA certificate ca.pem is self signed.
2020-08-07T07:37:19.783441Z 1 [Note] A temporary password is generated for root@localhost: i>;+lyB5Ojon

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

1
2
cd /usr/Environment/Mysql/mysql-5.7.30/support-files/
cp mysql.server /etc/init.d/mysql

16.编辑 /etc/init.d/mysql 文件

1
vim /etc/init.d/mysql

将文件中的basedir、datadir赋值为上面配置的目录即可

图片加载失败

17.配置环境变量

1
2
3
4
5
6
vim /etc/profile

#环境变量下面增加以下两行，目录根据个人不同进行修改
#目的是可以在任意目录下启动 mysql 服务与登录 mysql
export MYSQLBIN_HOME=/usr/Environment/Mysql/mysql-5.7.30
export PATH=$MYSQLBIN_HOME/bin:$PATH

18.使配置文件生效

1
source /etc/profile

如果切换回普通用户，或者重启之后环境变量失效，配置 ~/.bashrc 文件 在最下面添加 source /etc/profile 即可

19.启动MySQL服务

1
service mysql start

20.查看MySQL服务是否正常启动

1
service mysql status

如下图，已经启动成功

图片加载失败

21.登录mysql

1
mysql -r root -p #执行完此命令会让你输入密码，密码为上文日志中的初始密码，输入的时候密码是不可见的，直接复制过去也可以

图片加载失败

22.修改密码并授权远程连接

1
2
3
set password=password('123456');
grant all privileges on *.* to root@'%' identified by '123456';
flush privileges;

23.退出MySQL

1
exit

24.重启MySQL生效

1
2
3
4
service mysql stop
service mysql start
#或
service mysql restart

至此 MySQL 安装配置完成 ，可以用连接工具进行连接了。