https://www.notion.so/MySql-47d934e9f8a149ce91f8da82061cce4e
Docker
1
2
3
$ docker pull
$ docker run --name mysql-default -p 3306:3306 -e MYSQL_ROOT_HOST=% -e MYSQL_ROOT_PASSWORD=123456 -d mysql
$ docker exec -it mysql-default mysql -u root -p
1
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
Problem solving for remotely access
If you got the same problem like this while connect to MySQL server from another host (It depends on which version of MySQL you are using):
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
You should change your password of root user by using the native password hashing method to fix it:
1
2
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';