linux 安装mysql-5.7.29

1、下载mysql
下载地址 https://dev.mysql.com/downloads/mysql/

2、解压：

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

3、主目录：

mv mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/mysql
cd /usr/local/mysql
mkdir data

4、创建用户：

groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /usr/local/mysql

5、创建配置文件及相关目录: (修改配置文件：/etc/my.cnf，配置不对的话,后面初始化不全,会拿不到默认密码)

vim /etc/my.cnf
# mysql conf /etc/my.cnf
# Created by http://www.wdlinux.cn
# Last Updated 2010.06.01
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data/
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 128M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 8M
thread_cache_size = 8
query_cache_size= 16M
max_connections = 300
wait_timeout = 30
interactive_timeout = 30
max_connect_errors = 9
long_query_time = 1
tmp_table_size = 16M
#log-bin=mysql-bin
#binlog_format=mixed
#server-id = 1
[mysqldump]
quick
max_allowed_packet = 8M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 12M
sort_buffer_size = 1M
read_buffer = 1M
write_buffer = 1M
[mysqlhotcopy]

6、创建文件/tmp/mysql.sock：设置用户组及用户，授权:

cd /tmp
touch mysql.sock
chown mysql:mysql mysql.sock
chmod 755 mysql.sock

7、创建文件/tmp/mysqld/mysqld.pid：

mkdir mysqld
cd mysqld
touch mysqld.pid
cd ..
chown -R mysql:mysql mysqld
cd mysqld
chmod 755 mysqld.pid

8、创建文件/var/log/mysqld.log：

touch /var/log/mysqld.log
chown -R mysql:mysql /var/log
cd log
chmod 755 mysqld.log

9、安装和初始化数据库:

cd /usr/local/mysql/bin/

10、初始化数据库:

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

11、保存生成的密码
12、拷贝服务到对应的目录下：

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

13、启动mysql服务

/etc/init.d/mysql start

14、登录：

mysql -uroot -p   （输入刚刚保存的密码）

15、修改密码：

set password=password('xxxxxxx');
flush privileges;

16、创建软连接：

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

完成。