Expertise over technologies, commitment to deadlines, experienced corporate trainers and more makes us an ideal IT solution provider to your enterprise. Isn’t it the right time to work together?
Step 1 – Install MySQL
# sudo apt-get update

# sudo apt-get install mysql-server

Step 2 – Configuring MySQL

Enter a three level of password validation and also given a root password:

# sudo mysql

Step 3 – Create a MySQL User
Creating a new user and give it a strong password.
mysql> CREATE USER ‘magento’@’localhost’ IDENTIFIED BY ‘magento123’;

You could grant the user privileges to all tables within the database, as well as the power to add, change, and remove user privileges, with this command.
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘magento’@’localhost’ WITH GRANT OPTION;

mysql> FLUSH PRIVILEGES;

mysql> exit;
Step 4 – Testing MySQL
# sudo systemctl status mysql


bluethinkinc_blog
2022-07-11