MySQL User Permissions Setup Guide

The steps to set up MySQL user permissions are as follows:

1. Log in to the MySQL server: You can use the admin account and password to log in to the MySQL server either through the command line or the MySQL client tool.
2. Create a user: Use the CREATE USER statement to create a new user. For example: CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’; This will create a user named ‘username’ and set the password to ‘password’.
3. Granting permissions: Use the GRANT statement to grant permissions to a user. For example: GRANT SELECT, INSERT, UPDATE, DELETE ON database_name.* TO ‘username’@’localhost’; This will provide the user with SELECT, INSERT, UPDATE, and DELETE permissions on the ‘database_name’ database.
4. Refresh privileges: Use the statement FLUSH PRIVILEGES to update the permissions settings. For example, use FLUSH PRIVILEGES;
5. Verify permissions: Log in to the MySQL server with a new user and attempt to execute the granted permissions to ensure that the permissions are set correctly.

Please replace ‘username’ and ‘password’ with your actual username and password in steps 2 and 3. Also, adjust ‘localhost’ to the actual hostname or IP address if necessary, and replace ‘database_name’ with the actual database name.