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

0 vote309 views1 answer
Mysql bind-address default value
SQL
2 votes326 views2 answers
Sql query to list all tables in a database sql server
SQL
4 votes296 views1 answer
Check database name postgresql
SQL
0 vote344 views1 answer
Insert value in identity
SQL
15 votes558 views2 answers
How to sort names in alphabetical order in sql
SQL
28 votes326 views6 answers
Foreign key
SQL
38 votes310 views4 answers
Count sql
SQL
2 votes327 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
1 vote327 views1 answer
Sql order by timestamp
SQL
0 vote309 views1 answer
Mysql case when null
SQL