Mysql 安装笔记

卸载 mysql   https://www.cnblogs.com/alexzhang92/p/10638806.html

虚拟机上直接安装 mysql https://www.cnblogs.com/brianzhu/p/8575243.html   systemctl start  mysqld.service  启动命令
f8:1lMqEza/n

admin
docker images

mysql密码是 123456  root
启动命令:
docker run -p 3306:3306 --name mysql5.7 -v /data1/mysql57/conf:/etc/mysql/conf.d -v /data1/mysql57/logs:/logs -v /data1/mysql57/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

docker run -itd --name mysqld -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

docker rmi -f image i

docker 登陆命令

赋予 权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

https://blog.51cto.com/autophp/2319467 

SQLyog连接数据库报错plugin caching_sha2_password could not be loaded
进入mysql
执行以下命令

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码 

FLUSH PRIVILEGES; #刷新权限

alter user 'root'@'localhost' identified by '123456';#重置密码，xzx123456就是变更后的密码，自己的密码自己更改下哦

alter user 'root'@'%' identified with mysql_native_password by '123456';

select host,user,plugin,authentication_string from mysql.user;
查询密码 ;

CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pass_word` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `salt` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_time` date DEFAULT NULL,
  `parent_id` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;