目录
【按需】卸载旧版mysql
#查看依赖项
dpkg --list|grep mysql
#卸载
sudo apt-get remove mysql-common
sudo apt-get autoremove --purge mysql-server*
#清除残留数据
dpkg -l|grep ^rc|awk '{print$2}'|sudo xargs dpkg -P
#查看是否剩余依赖项
dpkg --list|grep mysql
#删除剩余依赖
sudo apt-get autoremove --purge mysql-apt-config
安装MySQL8
访问MySQL :: Download MySQL APT Repository 获取下载地址(点击download>选择No thanks, just start my download.>复制链接)
#下载MySQL的APT配置包
wget https://dev.mysql.com/get/mysql-apt-config_0.8.20-1_all.deb
#安装配置包
sudo dpkg -i mysql-apt-config_0.8.20-1_all.deb
#更新源
sudo apt-get update
#安装mysql
sudo apt-get install mysql-server
#查看mysql状态
sudo service mysql status
【按需】修改配置项
#打开配置文件,追加或修改配置项
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
#忽略大小写
lower_case_table_names=1
#数据库时区
default-time_zone='+8:00'
#拼接字符串长度限制
group_concat_max_len=-1
#binlog保存时间
expire_logs_days=30
#监听任意地址,以便远程访问
bind-address = 0.0.0.0
#重启MySQL服务
sudo systemctl restart mysql
#登录mysql
sudo mysql -u root -p
#查看配置项
SHOW VARIABLES where Variable_name like 'lower%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | OFF |
| lower_case_table_names | 1 |
+------------------------+-------+
创建一个远程访问用户
#查看权限
show grants for 'root'@'localhost';
#创建用户
create user`username`@`%` identified by'passwd';
#授权
grant all privileges on *.* to `username`@`%`;
#修改加密方式为mysql_native_password,以便远程访问
use mysql;
select host,user,authentication_string,plugin from user;
alter user 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'passwd';
#刷新权限
flush privileges;
#end