Create a MySQL User on Linux via Command Line

by Ismail.EL
0 comment

The CREATE USER statement creates new MySQL accounts. It enables account authentication properties to be established.

To create the new user on MySQL, enter the command CREATE USER <USERNAME> and Replace <USERNAME> with the name of your user.

Step 1: Login to MySQL:

To begin, sign into MySQL with the following command:

Enter the administrator password you set up during installation.

Step 2: Create MySQL User :

We’ll create a user with the name TestUser , and the password TestUser.

Step 3: Create your database:

To give the new user proper permissions, work through our tutorial on granting permissions to MySQL user’s via the command line.

Step 4: View a List of MySQL Users :

Viewing a full list of MySQL users, including the host they’re associated with, can be done with the following select statement:

Conclusion

IIn this post, i have explained how to Create a MySQL User on Linux via Command Line.
If you have any questions or feedback, feel free to leave a comment.
As always, if you found this post useful, then click like and share it 🙂

19360cookie-checkCreate a MySQL User on Linux via Command Line

Related Posts

Leave a Comment