![]() Developers, business users, contractors, vendors, and more all need access. Once you set up databases, users, and permissions, consider what the daily management of your MySQL databases, user accounts, and privileges look like. Effectively managing your MySQL databases and user accounts Copy each command and run it to see all the privileges the user has in the MySQL instance. This will display all of the SHOW GRANTS commands the user can run, one for each host the user has permission to access the database from. Mysql> SELECT CONCAT('SHOW GRANTS FROM er WHERE user=’local_user’ Information about MySQL privileges are stored in grant tables in the `mysql` database within your MySQL instance, as follows: You can also grant database object privileges globally.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |