How To Create a Superuser Account in MySQL

preview_player
Показать описание
in This Tutorial you will learn "How To create a new user account and configure the same permission as the ROOT account on a ubutnu 20"

MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL).

Code -
mysql -V
mysql -u root -p
CREATE USER 'superuserdb'@'%' IDENTIFIED WITH mysql_native_password BY 'superuserPASS';

Grant all permissions:-
GRANT ALL PRIVILEGES ON *.* TO 'superuserdb'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;

mysql -u superuserdb -p
Verify MySQL account privileges.:- SHOW GRANTS FOR 'superuserdb';
Рекомендации по теме
visit shbcf.ru