Ubuntu 安装MySQL5.7

MySQL安装

安装版本：5.7.35

#获取压缩包
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz
#解压
tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz
#重命名
mv mysql-5.7.35-linux-glibc2.12-x86_64 /usr/local/mysql

#创建data目录
mkdir /usr/local/mysql/data

#创建MySQL的用户
groupadd mysql
useradd -r -g mysql mysql

#赋予权限
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql

#进入bin目录，初始化（记住临时密码，后面需要）
cd  /usr/local/mysql/bin
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql


#创建配置文件
vim /etc/my.cnf

##内容
[mysqld]
datadir=/usr/local/mysql/data
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=400
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8


#启动
/usr/local/mysql/support-files/mysql.server start

#添加软连接并测试
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql 
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
service mysql restart

#用刚才的临时密码，登录。修改新密码
mysql -u root -p
set password for root@localhost = password('123456');

#开启远程连接！用Navicat界面管理软件去连接
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;

#放行MySQL端口
firewall-cmd --permanent --add-service=mysql
firewall-cmd --reload



# service mysql restart 启动报错:
# 来源：http://t.csdnimg.cn/HW8zk
# 如果启动时出错：Failed to start mysql.service: Unit mysql.service is masked
# 原因可能是之前使用apt-get 安装过mysql，服务被标记过，解除后即可启动：
systemctl unmask mysql.service