MySQL : How to Connect MySQL locally using command line and workbench

preview_player
Показать описание
MySQL : How to Connect to a MySQL Server locally using MySQL Workbench and 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
Рекомендации по теме
Комментарии
Автор

Thanks! It is one hundred percent correct.

thiagodacosta
welcome to shbcf.ru