ubuntu18安装MySQL8

ubuntu安装mysql8

MySQL8安装

Ubuntu18

源

/etc/apt/sources.list

# 163
deb <http://mirrors.163.com/ubuntu/> bionic main restricted universe multiverse
deb <http://mirrors.163.com/ubuntu/> bionic-security main restricted universe multiverse
deb <http://mirrors.163.com/ubuntu/> bionic-updates main restricted universe multiverse
deb <http://mirrors.163.com/ubuntu/> bionic-proposed main restricted universe multiverse
deb <http://mirrors.163.com/ubuntu/> bionic-backports main restricted universe multiverse
#deb-src <http://mirrors.163.com/ubuntu/> bionic main restricted universe multiverse
#deb-src <http://mirrors.163.com/ubuntu/> bionic-security main restricted universe multiverse
#deb-src <http://mirrors.163.com/ubuntu/> bionic-updates main restricted universe multiverse
#deb-src <http://mirrors.163.com/ubuntu/> bionic-proposed main restricted universe multiverse
#deb-src <http://mirrors.163.com/ubuntu/> bionic-backports main restricted universe multiverse
# aliyun
deb <http://mirrors.aliyun.com/ubuntu/> bionic main restricted universe multiverse
deb <http://mirrors.aliyun.com/ubuntu/> bionic-security main restricted universe multiverse
deb <http://mirrors.aliyun.com/ubuntu/> bionic-updates main restricted universe multiverse
deb <http://mirrors.aliyun.com/ubuntu/> bionic-proposed main restricted universe multiverse
deb <http://mirrors.aliyun.com/ubuntu/> bionic-backports main restricted universe multiverse
deb-src <http://mirrors.aliyun.com/ubuntu/> bionic main restricted universe multiverse
deb-src <http://mirrors.aliyun.com/ubuntu/> bionic-security main restricted universe multiverse
deb-src <http://mirrors.aliyun.com/ubuntu/> bionic-updates main restricted universe multiverse
deb-src <http://mirrors.aliyun.com/ubuntu/> bionic-proposed main restricted universe multiverse
deb-src <http://mirrors.aliyun.com/ubuntu/> bionic-backports main restricted universe multiverse

下载

失效

wget http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-server_8.0.20-1ubuntu18.04_amd64.deb-bundle.tar

有效

搜狐的

wget http://mirrors.sohu.com/mysql/MySQL-8.0/mysql-server_8.0.20-1ubuntu18.04_amd64.deb-bundle.tar

解压

tar xvf mysql-server_8.0.20-1ubuntu18.04_amd64.deb-bundle.tar

删除多余deb

rm mysql-community-test-debug_8.0.20-1ubuntu18.04_amd64.deb
rm mysql-testsuite_8.0.20-1ubuntu18.04_amd64.deb
rm mysql-community-test_8.0.20-1ubuntu18.04_amd64.deb
rm mysql-community-server-debug_8.0.20-1ubuntu18.04_amd64.deb

预设置

支持表名小写

sudo debconf-set-selections <<< "mysql-server mysql-server/lowercase-table-names select Enabled"

安装deb

sudo dpkg -i *.deb

会有依赖错误

更新

sudo apt update
sudo apt upgrade

修复

sudo apt-get -f -y install

然后就能看到让你输入密码了

上图我们选择老的5.x的认证方法，你可以选择第一个也OK。

稍等一会就OK了。

检查mysql状态

service mysql status

登录

mysql -u root -p

然后输入你的密码，如果可以，那就是OK了。

开启远程访问

默认只能localhost访问

root登录

use mysql

update user set host='%' where user ='root';

FLUSH PRIVILEGES;

# 这里根据你的需求来写，可以只给某些IP授权。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;

配置

如果需要修改配置 改写/etc/mysql/mysql.conf.d/mysqld.cnf。

停止mysql

service mysql stop

sudo /usr/sbin/mysqld --initialize --user=mysql --lower-case-table-names=1

启动

service mysql start

如果要修改配置

参考配置

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
log-error       = /var/log/mysql/error.log
character-set-server=utf8

卸载

查询MySQL的依赖项

dpkg --list|grep mysql

卸载命令：

sudo apt-get autoremove --purge  mysql-common    mysql-community-client-core  mysql-community-client mysql-community-client-plugins   mysql-community-server    mysql-community-server-core  mysql-community-server-debug

再查看应该没有了