ubuntu 之 安装mysql8

安装

wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb
sudo apt-get update sudo apt-get install mysql-server mysql-client

安装完如果没有提示输入密码

sudo cat /etc/mysql/debian.cnf 用debian.cnf里面的用户名和密码来登录
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
FLUSH PRIVILEGES;
sudo service mysql restart
mysql -u root -p #就好了

修改远程访问

mysql -u root -p
use mysql;
update user set host='%' where user='root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
FLUSH PRIVILEGES;

group by 不能用

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf 在[mysqld]的下面添加如下语句，然后重启
sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’