Linux下安装MySQL-5.7.29 数据库

软件安装

1.下载mysql-5.7.29-linux-glibc2.12-x86_64.tar安装包。
2.解压文件，拷贝到/usr/local/share/applications/

[root@localhost ~]# tar xvf mysql-5.7.29-linux-glibc2.12-x86_64.tar
[root@localhost ~]# tar zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
[root@localhost ~]# mv mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/share/applications/mysql-5.7

3.添加mysql用户

[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -r -g mysql mysql

4.创建data目录，修改mysql目录权限

[root@localhost mysql-5.7]# mkdir data
[root@localhost applications]# chown -R mysql.mysql mysql-5.7/

MySQL配置

修改配置文件/etc/my.cnf

[mysqld]
basedir=/usr/local/share/applications/mysql-5.7
datadir=/usr/local/share/applications/mysql-5.7/data
port=3306
socket=/tmp/mysql.sock
character-set-server=utf8


log-error = /usr/local/share/applications/mysql-5.7/data/mysqld.log
pid-file = /usr/local/share/applications/mysql-5.7/data/mysqld.pid

初始哈mysqld

[root@localhost bin]# ./mysqld --initialize --user=mysql --basedir=/usr/local/share/applications/mysql-5.7/ --datadir=/usr/local/share/applications/mysql-5.7/data/

查看初始化日志，初始密码
2020-04-14T07:16:02.256430Z 1 [Note] A temporary password is generated for root@localhost: >r#f<3tOrlbk

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

[root@localhost mysql-5.7]# cp support-files/mysql.server /etc/init.d/mysql

启动mysql服务

service mysql start

登录MySQL修改密码

[root@localhost bin]# ./mysql -u root -p

mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

添加远程访问权限

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set host='%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> 

重启mysql

[root@localhost bin]# service mysql stop
Shutting down MySQL..                                      [  OK  ]
[root@localhost bin]# service mysql start
Starting MySQL.                                            [  OK  ]