目录
1、准备依赖和安装包
mysql-server_5.7.41-1ubuntu18.04_i386.deb-bundle.tar
ibtinfo5_6.2-0ubuntu2_amd64.deb
libmecab2_0.996-1.2ubuntu1_amd64.deb
libaio1_0.3.110-2_amd64.deb
1.1在mysql官网选择找到安装包mysql-server_5.7.41-1ubuntu18.04_i386.deb-bundle.tar,因为没有20.04版本选,选择18.04MySQL :: Download MySQL Community Serverhttps://dev.mysql.com/downloads/mysql/
1.2依赖包准备,可以在下面的网站找到3个相关的依赖包
https://pkgs.org/ https://pkgs.org/
2、安装3个依赖包
dpkg -i libmecab2_0.996-1.2ubuntu1_amd64.deb
dpkg -i libaio1_0.3.110-2_amd64.deb
dpkg -i libtinfo5_6.2-0ubuntu2_amd64.deb
3、安装Mysql5.7
#解压 mysql-server_5.7.41-1ubuntu18.04_amd64.deb-bundle.tar:
tar -xvf mysql-server_5.7.41-1ubuntu18.04_amd64.deb-bundle.tar
#依次执行以下命令进行安装:
dpkg -i mysql-common_5.7.41-1ubuntu18.04_amd64.deb
dpkg-preconfigure mysql-community-server_5.7.41-1ubuntu18.04_amd64.deb //这里需要输入数据库root的密码
dpkg -i libmysqlclient20_5.7.41-1ubuntu18.04_amd64.deb
dpkg -i libmysqlclient-dev_5.7.41-1ubuntu18.04_amd64.deb
dpkg -i libmysqld-dev_5.7.41-1ubuntu18.04_amd64.deb
dpkg -i mysql-community-client_5.7.41-1ubuntu18.04_amd64.deb
dpkg -i mysql-client_5.7.41-1ubuntu18.04_amd64.deb
dpkg -i mysql-common_5.7.41-1ubuntu18.04_amd64.deb
dpkg -i mysql-community-server_5.7.41-1ubuntu18.04_amd64.deb
dpkg -i mysql-server_5.7.41-1ubuntu18.04_amd64.deb
#检查MySQL的安装:
mysql -u root -p //刚刚输入的密码
4、Mysql配置修改
修改mysql配置文件:mysqld.cnf
vi /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /data/mysql #自定义目录
log-error = /var/log/mysql/error.logbind-address = 0.0.0.0 #允许root 远程访问
skip-name-resolve = 0
character-set-server = utf8
lower_case_table_names = 1
innodb_large_prefix = on
symbolic-links=0
!!!如果修改了自定义目录,下面这个配置文件也要修改!!!
/etc/apparmor.d/usr.sbin.mysqld
是 Ubuntu 系统中 AppArmor 安全模块的配置文件之一,用于限制 MySQL 服务器进程(mysqld
)的访问权限。vi /etc/apparmor.d/usr.sbin.mysqld #增加 /data/mysql/ r, /data/mysql/** rwk,
# Allow data dir access
#增加自定义目录
/data/mysql/ r,
/data/mysql/** rwk,
5、重启Mysql验证,并授权允许root用户远程访问。
service mysql restart #重启mysql
mysql -u root -p123456 #123456是密码
use mysql;
grant all privileges on *.* to 'root'@'%' identified by '123456!';
flush privileges;
6、卸载Mysql
#卸载Mysql
apt purge mysql-*
rm -rf /etc/mysql/ /var/lib/mysql #数据目录,有自定义需要调整
apt autoremove
apt autoclean
apt-get remove 命令只会卸载软件包本身,而不会删除软件包的配置文件和数据。重新安装,它会保留以前的设置和数据。
apt-get purge 命令不仅会卸载软件包本身,还会删除软件包的配置文件和数据。重新安装该软件包,它将被还原为初始状态。