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

0 vote294 views1 answer
Sql select all tables from database change url
SQL
33 votes310 views6 answers
Change column name in mysql
SQL
14 votes290 views2 answers
How to auto increment in sql
SQL
8 votes292 views1 answer
Insert a select statement into a table
SQL
0 vote285 views1 answer
Mariadb LOAD DATA INFILE
SQL
9 votes330 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote315 views1 answer
Count database access django
SQL
0 vote293 views1 answer
Json_remove mysql
SQL
1 vote316 views1 answer
Postgresql export output table as a csv
SQL
0 vote270 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL