ubuntu16.04下安装 Mysql 5.6.40

最新推荐文章于 2025-10-10 17:33:00 发布

原创最新推荐文章于 2025-10-10 17:33:00 发布 · 2.2k 阅读

5 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

1 篇文章

订阅专栏

本文提供了一套详尽的指南，教你如何在Ubuntu系统上彻底卸载旧版MySQL，包括所有相关软件包，并重新安装MySQL 5.6版本。从卸载旧安装包到安装必要的依赖，再到下载并安装MySQL，直至配置远程访问和用户权限，每一步都配有具体的命令行操作。

1.卸载之前的安装包

sudo apt-get autoremove --purge mysql-server-5.*
sudo apt-get remove mysql-server
sudo apt-get autoremove mysql-server
sudo apt-get remove mysql-common

2.安装mysql依赖包

 sudo apt-get install libaio-dev
 sudo apt-get install libmecab2

3.下载mysql,解压

wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-server_5.6.40-1ubuntu14.04_amd64.deb-bundle.tar
tar -xvf mysql-server_5.6.40-1ubuntu14.04_amd64.deb-bundle.tar mysql5.6.40
cd mysql5.6.40

4.安装mysql

sudo dpkg -i mysql-common_5.6.40-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient18_5.6.40-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.6.40-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.6.40-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-client_5.6.40-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-client_5.6.40-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-server_5.6.40-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-server_5.6.40-1ubuntu14.04_amd64.deb

5. 开启远程访问 ,修改/etc/mysql/mysql.conf.d/mysqld.cnf如下

[mysqld]
bind-address = 0.0.0.0

6.开启远程访问

mysql -uroot -p
mysql>CREATE USER '自定义授权用户名'@'localhost' IDENTIFIED BY '自定义授权密码';
mysql>CREATE USER '自定义授权用户名'@'%' IDENTIFIED BY '自定义授权密码';
mysql>GRANT ALL ON *.* TO '自定义授权用户名'@'localhost';
mysql>GRANT ALL ON *.* TO '自定义授权用户名'@'%';
mysql>flush privileges;

7.连接测试

service mysql stop 
service mysql start

mysql -u root -p 

show variables like "char%"; 

show global variables like "%datadir%"; 查看MySQL安装的全局信息