How to Assign a Password to a Database in MySQL

Assigning a password to a database in MySQL is a crucial step to ensure the security and integrity of your data. Follow these steps to set up a password for your MySQL database:

1. Open the MySQL command line interface by running the command: mysql -u root -p
2. Enter your MySQL root password when prompted
3. Once inside the MySQL command line, you can create a new user and assign a password to it using the following commands:

CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'new_user'@'localhost';
FLUSH PRIVILEGES;

4. Remember to replace new_user with the desired username and password with the desired password
5. Exit the MySQL command line by typing exit

By following these steps, you can secure your MySQL database by assigning passwords to users and restricting unauthorized access.