Skip to main content
Home
  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact
programsbuzz facebook programsbuzz twitter programsbuzz linkedin
  • Log in

Main navigation

  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact

MySQL: Create User

Profile picture for user arilio666
Written by arilio666 on 01/03/2022 - 09:13

MySQL determines which database a user can connect to and contains two vital pieces of information the username and the host's name to which it is trying to connect.

  • So the format for that can be put like this username@hostname.
  • Let it be the admin user who is trying to connect here. They all go through the same format.
  • These user accounts are stored up in the user grant table in the MySQL database.
  • To connect to a database using a user credential based upon the privileges granted to them, CREATE USER is used in MySQL.

Syntax

CREATE USER username IDENTIFIED BY password;

Creating A New User

To create a new user, we need to use the CREATE USER statement in MySQL followed by the username of your choice and the local instance to connect to your database. Then followed by after that, will be your password.

CREATE USER 'naruto'@'LocalInstance' IDENTIFIED BY 'abcd';

This only created a new user and does not grant any permissions to it.

Creating More Than One User

Creating more than one user can also be done with the help of the same query which we used for making the single user. It goes like this.

CREATE USER 
'sai'@'LocalInstance' IDENTIFIED BY 'vgma';
'sasuke'@'LocalInstance' IDENTIFIED BY 'dcba';

User Connection From Any Host Account

% wildcard is used to create a user who can connect via any host in the MySQL database.

'sasuke'@'%' IDENTIFIED BY 'dcba';

In the place of the hostname, add the % wildcard to allow users to connect through any hosts.

Using Grants To View Permission

This one is used to view the permissions granted to the user.

SHOW GRANTS FOR naruto@LocalInstance;

Related Content
MySQL Tutorial
MySQL: SHOW DATABASES Statement
MySQL: SELECT DATABASE Statement
Tags
MySQL
  • Log in or register to post comments

Choose Your Technology

  1. Agile
  2. Apache Groovy
  3. Apache Hadoop
  4. Apache HBase
  5. Apache Spark
  6. Appium
  7. AutoIt
  8. AWS
  9. Behat
  10. Cucumber Java
  11. Cypress
  12. DBMS
  13. Drupal
  14. GitHub
  15. GitLab
  16. GoLang
  17. Gradle
  18. HTML
  19. ISTQB Foundation
  20. Java
  21. JavaScript
  22. JMeter
  23. JUnit
  24. Karate
  25. Kotlin
  26. LoadRunner
  27. matplotlib
  28. MongoDB
  29. MS SQL Server
  30. MySQL
  31. Nightwatch JS
  32. PactumJS
  33. PHP
  34. Playwright
  35. Playwright Java
  36. Playwright Python
  37. Postman
  38. Project Management
  39. Protractor
  40. PyDev
  41. Python
  42. Python NumPy
  43. Python Pandas
  44. Python Seaborn
  45. R Language
  46. REST Assured
  47. Ruby
  48. Selenide
© Copyright By iVagus Services Pvt. Ltd. 2023. All Rights Reserved.

Footer

  • Cookie Policy
  • Privacy Policy
  • Terms of Use