• Create User MySQL

To create a new user in MySQL, you can follow these steps:

1. Log In to the MySQL Shell

Open your terminal and connect to your MySQL server with an account that has administrative privileges (like root):

mysql -u root -p

Enter your root password when prompted.

2. Create the User

Use the CREATE USER statement with the following syntax:

CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';

• 'new_user' is the username you want to create.
• 'localhost' specifies that the user can connect only from the local machine. To allow connections from any host, use '%' instead.
• 'password' should be replaced with a strong password for the user.

For example:

CREATE USER 'johndoe'@'localhost' IDENTIFIED BY 'SecureP@ssw0rd';

3. Grant Privileges to the User

After creating the user, grant the necessary privileges. For instance, to allow the user to select, insert, update, and delete on a specific database, use:

GRANT SELECT, INSERT, UPDATE, DELETE ON your_database.* TO 'johndoe'@'localhost';

If you need to grant all privileges on a database:

GRANT ALL PRIVILEGES ON your_database.* TO 'johndoe'@'localhost';

4. Apply Changes