How do I grant multiple privileges in MySQL?

How do I grant all MySQL permissions?

To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name. * TO 'username'@'localhost';

How do I grant all privileges to root user in MySQL?

this commands work for me:1login to mysql and see all users. sudo mysql -u root select user, host from mysql.user;2delete old user. drop user root@localhost;3create new user. CREATE USER 'root'@'localhost' IDENTIFIED BY 'mypassword'4add all privileges to it: ... 5finally flush privileges.How to grant all privileges to root user in MySQL 8.0 - Stack Overflow

How many privileges exist in MySQL?

Privilege levels in MySQL There are six privilege levels used for granting privileges to the user: global, database, table, column, stored procedure or function, and proxy, as shown in the below image.