Ubuntu安装mysql5.7

最新推荐文章于 2024-05-27 14:33:37 发布

Tacy0213

最新推荐文章于 2024-05-27 14:33:37 发布

阅读量428

点赞数

分类专栏： mysql 文章标签： ubuntu linux mysql

本文链接：https://blog.csdn.net/beautybug1126/article/details/131952801

版权

mysql 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

下载安装包

下载地址：mysql历史安装版本

选择版本

在这里插入图片描述

下载

wget https://cdn.mysql.com/archives/mysql-5.7/mysql-server_5.7.42-1ubuntu18.04_amd64.deb-bundle.tar

或者下载到本地，再上传至服务器

解压tar包

tar xvf ./mysql-server_5.7.42-1ubuntu18.04_amd64.deb-bundle.tar

安装

安装依赖

sudo apt-get install ./libmysql*
sudo apt-get install libtinfo5

安装客户端和服务端

一步步来，中间会设置root密码

sudo apt-get install ./mysql-community-client_5.7.36-1ubuntu18.04_amd64.deb
sudo apt-get install ./mysql-client_5.7.36-1ubuntu18.04_amd64.deb
sudo apt-get install ./mysql-community-server_5.7.36-1ubuntu18.04_amd64.deb
sudo apt-get install ./mysql-server_5.7.36-1ubuntu18.04_amd64.deb

启动

systemctl restart mysql.service
systemctl status mysql.service
systemctl start mysql.service
systemctl stop mysql.service

修改配置

修改Mysql配置（utf8mb4）

vi /etc/mysql/mysql.conf.d/mysqld.cnf
#在下面的标签中找到修改或添加这几个项
[mysqld]
    character-set-server=utf8mb4

vi /etc/mysql/conf.d/mysql.cnf
#在下面的标签中找到修改或添加这几个项
[mysql]
    default-character-set=utf8mb4

修改mysql配置文件my.cnf

vi etc/mysql/my.cnf
[client] 
default-character-set = utf8mb4 
[mysql] 
default-character-set = utf8mb4 
[mysqld] 
default-storage-engine=INNODB
character-set-server = utf8mb4 
collation-server = utf8mb4_unicode_ci

重启生效

service apparmor restart
service mysql restart