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

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)

How to support Tls1.2 with .net framework 4.0

How to get to resources by giving resource file as a string ?

Virtualization..

https://www.makeuseof.com/tag/best-virtual-machine-windows/

How to match not string with C# regular expression ?

Regular expression:
INSERT INTO \[TABLICA_REJ\](?:(?!VALUES).)*VALUES \(([^,]+,){4}'(?[A-Z0-9]+)'
input:
IF NOT EXISTS (SELECT 1 FROM VEHICLE_PLATES WHERE id = 2191007153548014038060268115) INSERT INTO [VEHICLE_PLATES] ([id],[id2],[name],[name2],[number],[date]) VALUES (2191007153548014038060268115,2190926111229058038052754,'00','0','PZ407TV','2019-10-07 15:27:27');
Check in http://regexstorm.net
example and check
http://regexstorm.net/tester?p=INSERT+INTO+%5c%5bTABLICA_REJ%5c%5d%28%3f%3a%28%3f!VALUES%29.%29*VALUES+%5c%28%28%5b%5e%2c%5d%2b%2c%29%7b4%7d%27%28%3f%3ctab_rej%3e%5bA-Z0-9%5d%2b%29%27&i=IF+NOT+EXISTS+%28SELECT+1+FROM+TABLICA_REJ+WHERE+idr+%3d+2191007153548014038060268115%29%0d%0aINSERT+INTO+%5bTABLICA_REJ%5d+%28%5bidr%5d%2c%5bidw%5d%2c%5bwt_tr%5d%2c%5bkt_rej%5d%2c%5bnr_tab_rej%5d%2c%5bnr_tab_rej_dr%5d%2c%5bdt_wyd%5d%2c%5bdod_tab%5d%2c%5bdt_dodania_dod_tab%5d%2c%5bidentyfikatorSystemowyCepik%5d%2c%5bidentyfikatorStanuCepik%5d%2c%5bzwezone_litery%5d%29+VALUES+%282191007153548014038060268115%2c2190926111229058038052754%2c%2700%27%2c%270%27%2c%27PZ407TV%27%2c%27PZ+407TV%27%2c%272019-10-07+15%3a27%3a27%27%2c%270%27%2cNULL%2c4977814074663942%2c4619151641798971%2c1%29%3b%0d%0a&o=s