操作步骤:
- 下载镜像:docker pull mysql/mysql-server
- docker run -d -p 3306:3306 --name mysql01 mysql/mysql-server
- 查看:docker ps
- docker logs mysql01--拷贝密码
- docker exec -it mysql01 bash
- mysql -u root -p {password}
- use mysql
- SET PASSWORD FOR 'root'@'localhost'=PASSWORD('MyNewPassword');
- select user,host from user;
- CREATE USER 'liuguojiang'@'localhost' IDENTIFIED BY 'pwd23456';
- GRANT ALL PRIVILEGES ON *.* TO 'liuguojiang'@'localhost' WITH GRANT OPTION;
- CREATE USER 'liuguojiang'@'%' IDENTIFIED BY 'pwd123456';
- GRANT ALL ON *.* TO 'liuguojiang'@'%' WITH GRANT OPTION;
- SELECT USER,HOST FROM USER
- show vriables '%char%';
- exit;
- cd /etc
- cd my.cnf
- yun install vim
- cd /etc
- vim my.cnf
- 修改MYSQL默认字符集
- [mysql]
- character-set-server=utf8
- [client]
- default-character-set=utf8
- [mysql]
- default-character-set=utf8
- esc,输入wq
- mysql --help