filmov
tv
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
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';
flush privileges;
mysql -u mysqlbackup -p Password#123
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';
flush privileges;
mysql -u mysqlbackup -p Password#123