Install mysql on ubuntu

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;

Install mysql ubuntu 18.04

sudo apt update
sudo apt install mysql-server
sudo mysql_secure_installation

Setup mysql ubuntu

sudo apt install mysql-server
sudo mysql_secure_installation utility

Install mysql on ubuntu

sudo apt-get update
sudo apt-get install mysql-server

Source: docs.rackspace.com

Installing mysql on ubuntu

systemctl status mysql

-1

Install mysql ubuntu

$ mysql
$ sudo apt-get install mysql-server
$ mysql -u root -p
$ sudo mysql -u root -p
$ use mysql;
$ update user set plugin=”mysql_native_password” where user=’root’;
$ flush privileges;
$ exit
$ mysql -u root -p
$ create database demo;
$ show databases;

-2

Similar codes

13 votes270 views5 answers
Select last row mysql
SQL
1 vote252 views1 answer
Python escape string for sql
SQL
1 vote300 views1 answer
How to get the date diff on once field in sql server
SQL
2 votes272 views1 answer
Oracle sql concatenate results into string
SQL
-1 vote272 views3 answers
Psql get last rows
SQL
1 vote275 views1 answer
Select 2 rows in sql
SQL
0 vote292 views1 answer
Top 3 salary in sql
SQL
-1 vote318 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote289 views1 answer
Sql server insert inner join
SQL
49 votes320 views6 answers
Alter table add column
SQL