Linux安装mysql

Mysql官方下载地址：https://downloads.mysql.com/archives/community/
采用压缩文件包方式安装：

0.安装一些库

sudo apt install libaio-devel numactl

1.新建mysql组和用户

sudo groupadd mysql
sudo useradd -r -g mysql mysql

2.解压压缩文件并移动

sudo mv mysql-5.7.30-linux-glibc2.12-x86_64/ /usr/local/mysql
sudo mkdir /usr/local/mysql/data
sudo chown -R mysql:mysql /usr/local/mysql
sudo chmod -R 755 /usr/local/mysql

3.安装并设置

cd /usr/local/mysql/bin
sudo ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
sudo gedit /etc/my.cnf
'''
配置文件：
[mysqld]
datadir=/usr/local/mysql/data
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=600
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8
'''
sudo /usr/local/mysql/support-files/mysql.server start
//这一步最后的字符串为初始的密码，请记住
sudo ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
sudo ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
sudo service mysql restart
sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
sudo chmod +x /etc/init.d/mysqld
sudo systemctl enable mysqld

4.修改密码并开启远程

mysql -u root -p
set password for root@localhost = password('yourpass');
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;