#Installing MySQL on Ubuntu
#To install MySQL on your Ubuntu server follow the steps below:
First, update the apt package index by typing:
sudo apt update
#Then install the MySQL package with the following command:
sudo apt install mysql-server
#Once the installation is completed, the MySQL service will start automatically. To check whether the MySQL server is running, type:
sudo systemctl status mysql
#To secure MySQL
#Run the script by typing:
sudo mysql_secure_installation
#To log in to the MySQL server as the root user type:
sudo mysql
#If you want to login to your MySQL server as root from an external program such as phpMyAdmin you have two options.
The first one is to change the authentication method from auth_socket to mysql_native_password. You can do that by running the following command:
mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'very_strong_password';
mysql > FLUSH PRIVILEGES;
#The second, recommended option is to create a new administrative user with access to all databases:
mysql > GRANT ALL PRIVILEGES ON *.* TO 'administrator'@'localhost' IDENTIFIED BY 'very_strong
