MySQL : how to connect to a mysql server locally with mysql workbench

Описание

MySQL : How to Connect to a MySQL Server with MySQL Workbench/ Command Line


mysql -u root -p Mysql@1234

Select host, user from mysql.user;

CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'Password#123';

GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER ON *.* TO 'mysqlbackup'@'localhost';
GRANT LOCK TABLES ON *.* TO 'mysqlbackup'@'localhost';
Select host, user from mysql.user;
flush privileges;


mysql -u mysqlbackup -p Password#123