- Login to mysql
mysql -u username -p
2. Create user
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
3. Set permission
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
4. Permission for a specific database
GRANT ALL PRIVILEGES ON `databasename`.* TO 'username'@'localhost' WITH GRANT OPTION;
5. Rerfresh
FLUSH PRIVILEGES;
How To Grant Different User Permissions
Here is a short list of other common possible permissions that users can enjoy.
- ALL PRIVILEGES- as we saw previously, this would allow a MySQL user full access to a designated database (or if no database is selected, global access across the system)
- CREATE- allows them to create new tables or databases
- DROP- allows them to them to delete tables or databases
- DELETE- allows them to delete rows from tables
- INSERT- allows them to insert rows into tables
- SELECT- allows them to use the
SELECT
command to read through databases - UPDATE- allow them to update table rows
- GRANT OPTION- allows them to grant or remove other users’ privileges