linux怎么用pip安装mysql_Linux安装mysql

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;