Ubuntu - mysql8.0.28安装

//mysql下载
https://downloads.mysql.com/archives/community/

//alien下载
http://ftp.de.debian.org/debian/pool/main/a/alien/

//libaio 包下载
https://ubuntu.pkgs.org/18.04/ubuntu-main-amd64/libaio1_0.3.110-5_amd64.deb.html

//用find命令找mysql的依赖包libaio.so.1,找不到就安装libaio包
find /usr -name libaio.so.1 

//安装alien命令包
tar -zxvf alien_8.92.tar
cd alien
sudo ./Makefile.PL
sudo make
sudo make install

//安装libaio包
dpkg -i libaio1_0.3.110-5_amd64.deb

//解压
tar -xvf mysql-8.0.28-linux-glibc2.12-x86_64.tar
tar -xf mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz
tar -zxvf mysql-8.0.28-linux-glibc2.12-x86_64.tar.gz

//移动并重命名
mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql

//创建mysql用户组和用户并修改权限
sudo groupadd mysql
sudo useradd -r -g mysql mysql

//配置my.cnf
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true

//进入mysql的bin目录,初始化数据库,并查看记住密码
cd /usr/local/mysql/bin/
sudo ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
sudo cat /data/mysql/mysql.err

//启动mysql,不行就重启虚拟机
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
sudo service mysql start
sudo ps -ef|grep mysql

//登录mysql,修改密码
./mysql -u root -p

//配置远程连接
#访问mysql库
use mysql
#使root能再任何host访问                                           
update user set host = '%' where user = 'root'; 
#刷新     
FLUSH PRIVILEGES;

//建立全局的软连接,可以使你不用进入mysql的bin目录下敲命令
ln -s /usr/local/mysql/bin/mysql /usr/bin