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

3 votes209 views2 answers
Postgres alter table owner
SQL
0 vote195 views1 answer
Grepper sql workbench download
SQL
1 vote216 views1 answer
How to fetch alternate records from two tables
SQL
0 vote229 views2 answers
Sql server select first day of previous year
SQL
11 votes227 views3 answers
Sql line numbers
SQL
14 votes208 views5 answers
Set password for postgres user ubuntu
SQL
0 vote197 views1 answer
Login failed for login due to trigger execution
SQL
0 vote214 views1 answer
Postgresql function ROUND
SQL
1 vote195 views3 answers
Mariadb add foreign key
SQL
0 vote226 views1 answer
How convert into in in sql query
SQL