mysql 安装配置记录

安装

sudo apt-get update

sudo apt-get install mysql-server

mysql8

sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb
sudo apt update
sudo apt install mysql-server

mysql –u root –p

创建用户数据库并分配权限

mysql -u root -p

create user 'username'@'ip' identified by 'password';
flush privileges;

create database name character set utf8;
grant all privileges on database.* to 'username'@'ip';

配置文件

sudo vim /etc/mysql/my.cnf

# bind-address = 127.0.0.1 # 允许远程用户登录

错误

Access denied for user ‘root’@‘localhost’ ；

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
skip-grant-tables

操作

mysql -u root -p
use mysql;
update user set authentication_string='' where user='root';
update user set plugin="mysql_native_password" where user='root';
flush privileges;
quit;

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
# skip-grant-tables

操作

service msqld restart

mysql -u root -p
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';