So, I hope you will understand these steps easily. At last, we granted the privileges to the created user account. To do so, enter the following command: sudo mysql u root p 2. We checked the list of users with other details. Before you can create a new MySQL user, you need to open a terminal window and launch the MySQL shell as the root user. Also, we have seen the user account for any specific host. In the password, we used both encrypted and without encrypted. Bottom Lineįinally, we understand how to create user in Mysql with a password. You can define the specific privileges as from the above list. Here, I have defined ‘*’ for the privileges type. The above command will grant all privilegs to the specified user. Second, use the GRANT ALL PRIVILEGES statement to grant all. grant all privileges on *.* to with grant option How To Grant Different User Permissions ALL PRIVILEGES- as we saw previously, this would allow a MySQL user all access to a designated database (or if no. Run the SHOW GRANTS command to get a list of the permissions that are currently available to the admin. Note that you should use a secure password instead of abcd124. UPDATE – The user account is allowed to update table rows.SELECT – To select and read the database and table this privilege is used. ![]()
0 Comments
Leave a Reply. |