2020/12/03
2020/11/09
How to clear Reasharper in VS 2019
Clear all subdirectories contents (try not to remove subdir itself) from directory
C:\Users\{your_user_data}\AppData\Local\JetBrains\Transient
2020/10/14
2020/09/29
2020/09/02
2020/05/31
2020/05/04
2020/05/02
How to create and connect with mysql client to mysql server running on docker container ?
1/ Download Docker form WIndows
https://docs.docker.com/toolbox/toolbox_install_windows/
2/Download mysql image and run mysql container
docker container run -it --detach --name mysql-server -p 3306:3306 --env MYSQL_RANDOM_ROOT_PASSWORD=yes mysql:latest
3/Configure mysql
docker container logs mysql-server
find secret random password under"GENERATED ROOT PASSWORD"
Set up access users and passwords
Ensure that there is at least one user that has configured remote connection fg '%'
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MNBVCXZ987654321';
ALTER USER 'root'@'%' IDENTIFIED BY 'MNBVCXZ987654321';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
UPDATE mysql.user SET Host='%' WHERE Host='127.0.0.1' AND User='root';
4/Connect to mysql using MySql client
Do not forget to stop IIS or at least change ip for mysql service (docker bridge)
https://docs.docker.com/toolbox/toolbox_install_windows/
2/Download mysql image and run mysql container
docker container run -it --detach --name mysql-server -p 3306:3306 --env MYSQL_RANDOM_ROOT_PASSWORD=yes mysql:latest
3/Configure mysql
docker container logs mysql-server
find secret random password under"GENERATED ROOT PASSWORD"
Set up access users and passwords
Ensure that there is at least one user that has configured remote connection fg '%'
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MNBVCXZ987654321';
ALTER USER 'root'@'%' IDENTIFIED BY 'MNBVCXZ987654321';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
UPDATE mysql.user SET Host='%' WHERE Host='127.0.0.1' AND User='root';
4/Connect to mysql using MySql client
host: 127.0.0.1
port: 3306
user: root
password: (known)
Do not forget to stop IIS or at least change ip for mysql service (docker bridge)
Subscribe to:
Posts (Atom)