install mysql new server ubuntu code example
Example 1: install mysql ubuntu
sudo apt install mysql-server
Example 2: start mysql server ubuntu
sudo service mysql-server
Example 3: 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;