how to set up mysql on ubuntu code example

Example 1: how to install mysql ubuntu

sudo apt update
sudo apt install mysql-server
sudo service mysql start
sudo mysql_secure_installation
sudo mysql -u root 

In mysql console:
DROP USER 'root'@'localhost';
CREATE USER 'root'@'%' IDENTIFIED BY 'YOURPASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Example 2: setup mysql ubuntu

sudo apt install mysql-server
sudo mysql_secure_installation utility

Example 3: ubuntu install mysql

sudo apt install mysql-server

Example 4: installing mysql on ubuntu

systemctl status mysql

Example 5: how to enable mysql authentication on ubuntu 18.04

//follow this blog

https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04

Tags:

Sql Example