1[失败]下载源到本地
经测试配置mysql-community.repo下载5次都失败
2[成功]手动下载最新源到linux服务器上
在上面找到相应的版本
https://dev.mysql.com/downloads/repo/yum/
下载到本地
wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm
检查mysql源
yum repolist enabled | grep "mysql.*-community.*"
安装
yum localinstall mysql80-community-release-el7-1.noarch.rpm
安装服务端
yum install mysql-server
参考文档
https://blog.csdn.net/qq_42166308/article/details/108849906
3[重启服务器]因为阿里云共享服务器重启后删除了run下面的mysqld
所以需要手动赋权文件夹并手动启动mysql
cd /run
mkdir mysqld
chown -R mysql /run/mysqld
systemctl start mysqld
systemctl status mysqld.service
加入开机启动:systemctl enable mysqld.service
登录
mysql -uroot -p
修改密码mysqladmin -u root -p
使用mysql库:use mysql
查询信息:select user,host from user
修改root用户的host字段,命令:update user set host="%" where user="root"
使本次修改立即生效,命令:flush privileges
显示进程列表
show processlist;
杀死进程
kill id
ONLY_FULL_GROUP_BY问题
select @@sql_mode;
set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
https://blog.csdn.net/yubin1285570923/article/details/83352491