mysql main

 Find all users from mysql  - select user,host from mysql.user;

create user                            - create user 'root'@'192.168.12.15' identified by 'Password';

                                                grant all privileges on *.* to 'root'@'192.168.12.15';

                                                flush privileges;

Show current user                -  select current_user;

connect host from clients      -

 C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u coot -h 100.112.14.34 -p

backup -

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqldump -u unroot -p lisQ > c:/lisque.sql

restore

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p checkLisq <c:\lisque.sql