How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
- 1 Answers
- 1027 Views
- I also Faced
- E-Mail Answers
Answer Posted / Akash Kumar Varshney
To give user privileges for a database in MySQL, you need to login as root, switch to the mysql database, grant privileges using GRANT command, and update privileges using FLUSH PRIVILEGES command. Here's an example: `mysql -u root; GRANT ALL PRIVILEGES ON your_database_name.* TO 'username'@'localhost'; FLUSH PRIVILEGES;`
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
