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 vote105 views1 answer
Select first rows postgresql
SQL
0 vote124 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
2 votes61 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote100 views1 answer
Where in clause tsql
SQL
2 votes112 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
2 votes119 views1 answer
How to make multiple keys as primary in bdms
SQL
24 votes111 views4 answers
Postgres delete database
SQL
0 vote113 views1 answer
Sql add calculated column
SQL
7 votes114 views2 answers
MySQL IF without else
SQL
0 vote112 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL