Create a new user and grant permissions in MySQL<\/strong> to securely manage database access for applications, websites, and other services. MySQL is a popular open-source relational database management system used to store and manage application data. Creating a new MySQL user and assigning the required permissions is an important task for database administrators and developers.<\/p>\n\n\n\n In this guide, we will explain how to create a new user and grant permissions in MySQL, including granting access to all databases, granting access to a specific database, and revoking permissions when required.<\/p>\n\n\n\n Before creating a new MySQL user and granting permissions, make sure you have the following:<\/p>\n\n\n\n MySQL, the most popular open-source SQL database management system, is developed, distributed, and supported by Oracle Corporation. Step 1:\u00a0<\/strong>A new user can be created within the MySQL shell using the following statement:<\/p>\n\n\n\n This will create a new user named \u2018pheonix\u2019 without any permissions.<\/p>\n\n\n\n Step 2:<\/strong> To give full access to all databases for the pheonix user, run the following statement:<\/p>\n\n\n\n Step 4: <\/strong>To give access to a specific database for the new user, run the following statement:<\/p>\n\n\n\n Step 5: <\/strong>To revoke access: Creating a new MySQL user and granting the appropriate permissions helps manage database access securely and efficiently. Using the For detailed information about MySQL account management and user privileges, refer to the official MySQL documentation<\/strong> Link<\/a><\/p>\n\n\n\n You can create a new MySQL user using the Use the This grants the user full privileges on all databases.<\/p>\n\n\n\n You can grant privileges to a specific database using:<\/p>\n\n\n\n Replace Configuring MySQL to Listen on a Private IP Address<\/a><\/p>\n\n\n\n How to Disable\/Lock a MySQL User Account from CLI?<\/a><\/p>\n\n\n\nPrerequisites<\/h2>\n\n\n\n
\n
Implementation<\/h2>\n\n\n\n
<\/p>\n\n\n\nCREATE USER 'pheonix<\/strong>'@'localhost' IDENTIFIED BY 'password<\/strong>';<\/code><\/p>\n\n\n\nGRANT ALL PRIVILEGES ON * . * TO 'pheonix<\/strong>'@'localhost';<\/code>
Step 3:<\/strong>Then run the following statement to reload all the privileges:
<\/p>\n\n\n\nFLUSH PRIVILEGES;<\/code><\/p>\n\n\n\nGRANT ALL PRIVILEGES ON database<\/strong> . * TO 'pheonix<\/strong>'@'localhost';<\/code><\/p>\n\n\n\nREVOKE\u00a0ALL PRIVILEGES ON\u00a0database<\/strong>.* FROM 'pheonix<\/strong>'@'localhost';<\/code>
<\/p>\n\n\n\nConclusion<\/h2>\n\n\n\n
CREATE USER<\/code>, GRANT<\/code>, and REVOKE<\/code> statements, you can control which databases a user can access and what actions they can perform. It is recommended to grant users only the permissions they require to follow the principle of least privilege and improve MySQL database security.<\/p>\n\n\n\nFAQs<\/h2>\n\n\n\n
1. How do I create a new user in MySQL?<\/h3>\n\n\n\n
CREATE USER<\/code> statement:<\/p>\n\n\n\nCREATE USER 'username'@'localhost' IDENTIFIED BY 'password';<\/code><\/p>\n\n\n\n2. How do I grant all privileges to a MySQL user?<\/h3>\n\n\n\n
GRANT ALL PRIVILEGES<\/code> statement:<\/p>\n\n\n\nGRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';<\/code><\/p>\n\n\n\n3. How do I grant access to a specific database in MySQL?<\/h3>\n\n\n\n
GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';<\/code><\/p>\n\n\n\ndatabase<\/code> with the name of the required database.<\/p>\n\n\n\nRelated Articles<\/h2>\n\n\n\n