filmov
tv
How To Create a Superuser Account in MySQL

Показать описание
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';
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';