![]() If you want to view the privileges assigned to the MySQL user account, run the following command: mysql> SHOW GRANTS FOR should see the following output: - mysql> FLUSH PRIVILEGES View MySQL User Account Privileges To grant all privileges to the MySQL user account on a specific database, run the following command: mysql> GRANT ALL PRIVILEGES ON dbname.* TO grant all privileges to the MySQL user on a specific table from a database, run the following command: mysql> GRANT ALL PRIVILEGES ON dbname.tablename TO grant multiple privileges like, SELECT, INSERT, DELETE to the MySQL user on a specific database, run the following command: mysql> GRANT SELECT, INSERT, DELETE ON dbname.* TO will need to run the flush privileges command for the changes to take effect.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |