Install mysql 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

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

Install mysql ubuntu

//follow this blog

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

-3

Similar codes

1 vote289 views1 answer
How to between in sql
SQL
0 vote316 views1 answer
Check database restore status sql script
SQL
13 votes308 views5 answers
Alter table query sql server change column
SQL
17 votes301 views4 answers
Mysql remove ubuntu
SQL
31 votes286 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote315 views1 answer
T-sql delete view if exists
SQL
1 vote315 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
2 votes280 views1 answer
Brew start postgres manual
SQL
3 votes358 views1 answer
Apex call duration
SQL
0 vote275 views1 answer
Select max salary from each department in sql
SQL