How to set password in mysql

MySQL is one of the most popular relational databases. Its security is very important, and one of the important aspects is the password setting. This article explains how to set a password in MySQL to keep your database secure.

Step one: Log in to MySQL

Before setting a password, you must first log in to MySQL. You need to log in with an administrator account. You can log in through terminal commands or MySQL client tools.

Log in through the terminal command line: Use the following command:

mysql -u root -p

Among them, the "-u" parameter is used to specify the account, "root" is the administrator account, and the "-p" parameter is used to specify a password, which will prompt you for the password.

Log in via a MySQL client tool: Using your MySQL client tool, such as MySQL Workbench, enter your administrator username and password, making sure to select the correct hostname and port number. Click the "Connect" button to connect to the database.

Step 2: Create a new user

To set a password in MySQL, you first need to create a new user. A new user can be created using the following command:

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

• 'myuser': This is your new username.
• 'localhost': This is your hostname. This means that connections to the database are only allowed from the current host.
• 'mypassword': This is your new password.

Step Three: Grant Permissions to the New User

Now, you have created a new user, but it does not have permissions to access the database. To allow it to access the database, you need to give it permissions. You can assign privileges to a new user using the following command:

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

• ALL PRIVILEGES: This means you grant all privileges to the user.
• *.*: This means you assigned the user permissions on all databases and all tables.
• 'myuser'@'localhost': This is your new username and hostname.
• WITH GRANT OPTION: This means that the user can grant his permissions to other users.

Please note that "WITH GRANT OPTION" is optional. Omit it if you don't want users to grant their permissions to other users.

Step 4: Refresh Permissions

Now you have set the permissions for the new user, but MySQL in most cases requires refreshing permissions for the changes to take effect. Permissions can be refreshed using the following command:

FLUSH PRIVILEGES;

Step 5: Test the new user

Now that you have created a new user and set permissions for it, you can now test whether the user can Access the database. You can test using the following command:

mysql -u myuser -p

Enter the password you set for this user. If you can log in to MySQL and execute commands, you have successfully set the password.

Summary

It is very important to set a password in MySQL, which can help prevent unauthorized users from accessing the database. Creating a new user and giving it permissions is the best way to achieve this. You can set this up in minutes by using MySQL's command line options or client tools.

The above is the detailed content of How to set password in mysql. For more information, please follow other related articles on the PHP Chinese website!