Installing 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

0 vote361 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote325 views1 answer
Postgres check blocking
SQL
40 votes353 views6 answers
Update table mysql
SQL
0 vote364 views1 answer
Kimball data warehouse sql calendar
SQL
12 votes320 views2 answers
Find duplicates mysql column
SQL
103 votes522 views1 answer
Like sql
SQL
2 votes311 views1 answer
Oracle list grants on package
SQL
23 votes289 views6 answers
Create table sql
SQL
1 vote318 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote265 views1 answer
Mysql find foreign key references
SQL