Scribd
Upload
26 views3 pages

User Creation Using MySQL

This document outlines the steps to create a new user in a MySQL database, including logging in, creating the user, granting privileges, flushing privileges, and verifying the user creation. It also explains how to grant all privileges on all databases using a wildcard and the necessary SQL commands. The process ensures that the user has the required access to specified databases or all databases on the MySQL server.

Uploaded by

akhil84
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
26 views3 pages

User Creation Using MySQL

This document outlines the steps to create a new user in a MySQL database, including logging in, creating the user, granting privileges, flushing privileges, and verifying the user creation. It also explains how to grant all privileges on all databases using a wildcard and the necessary SQL commands. The process ensures that the user has the required access to specified databases or all databases on the MySQL server.

Uploaded by

akhil84
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

ChatGPT Page 1 of 3

Export to Google Doc


Copy with formatting
Select for Multi-select

To create a new user in a MySQL database, you can use the following steps. Ensure you have
the necessary privileges to create a user (e.g., root or an admin account).

1. Log in to MySQL: Open your terminal or command prompt and enter the following to log
in to MySQL:

css

mysql -u root -p

After entering your password, you'll be in the MySQL shell.

2. Create the User: Use the following SQL statement to create a new user. Replace
username with the desired username and password with the desired password:

sql

CREATE USER 'username'@'hostname' IDENTIFIED BY 'password';

'hostname' : This can be localhost if the user should only connect from the local

machine, or % for any host.

'password' : The password for the new user.

Example:

sql

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'newpassword';

3. Grant Privileges: After creating the user, you must grant the necessary privileges. For
example, if you want to grant all privileges on a specific database, you can do so like this:

sql

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'hostname';


Example: Page 2 of 3

sql

GRANT ALL PRIVILEGES ON mydatabase.* TO 'newuser'@'localhost';

4. Flush Privileges: To apply the changes, you need to flush the privileges:
sql

FLUSH PRIVILEGES;

5. Verify the User Creation: You can check if the user was created and granted privileges by
running:

sql

SELECT user, host FROM mysql.user;

This process will create the user and grant them the necessary privileges to access the
specified database.

Let me know if you need further clarification!

Export to Google Doc


Copy with formatting
Select for Multi-select

If you want to grant privileges to a user for all databases in MySQL, you can modify the
GRANT statement to target all databases using the wildcard * .

Here's how you can do it:

1. Create the User: First, create the user as before. For example, to create a user named
newuser with a password newpassword :

sql

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'newpassword';

2. Grant All Privileges on All Databases: To grant the user all privileges on all databases, use
the following SQL command:

sql

GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' WITH GRANT OPTION;


*.* means all databases ( * ) and all tables within those databases ( * ). Page 3 of 3

WITH GRANT OPTION allows the user to grant privileges to other users.

3. Flush Privileges: Always run FLUSH PRIVILEGES to make the changes take effect:
sql

FLUSH PRIVILEGES;

4. Verify the User and Privileges: To verify the privileges granted, you can run:
sql

SHOW GRANTS FOR 'newuser'@'localhost';

This will give the user full access to all databases on the MySQL server.

Let me know if you need any more details!

Export to Google Doc


Copy with formatting
Select for Multi-select

You might also like