Categories
MySQL Ubuntu

How to install MySQL on Ubuntu 18.04/19.04

I are going to install MySQL server on Ubuntu 19.04 using terminal, but you can follow the instructions and install MySQL server on Ubuntu 18.04 as well.

First thing first, we need to update the system core, so launch your terminal manually or press control+shift+t and type following command..

sudo apt update && upgrade

Wait for the updates and upgradables to be finished and then run MySQL installation command…

sudo apt install mysql-server -y

When MySQL server is installed on your Ubuntu desktop, simply exit out of the terminal and relaunch the terminal and login to MySQL with sudo right.. type –

sudo mysql

Now you in the MySQL ternimal interface, here we are now going to alter root password, so that you can login to MySQL with root username and its password.

Alter MySQL root user password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Here you should choose a secure password for the root user. Now, let’s flush the privileges

FLUSH PRIVILEGES;

Now, exit out of the MySQL interface and log back in with root user and the altered password.

exit

mysql -u root -p

Type root user password and create your very first SQL database with this simple command..

CREATE DATABASE db_name;

Check all the databases, that exist on the SQL database.

SHOW DATABASES;

If you still can’t install MySQL on Ubuntu, you can watch me install MySQL on my Ubuntu 19.04

Watch me install MySQL on ubutnu 19.04

By Tube Mint

I am a YouTuber and I also do niche marketing. In the process of create my niche blog using WordPress, Drupal, and GatsbyJS, I learned a few things like html, css, JS, CMS, MVC frameworks, C++, Python, Ruby, MySQL, Windows and Linux. After some time.. I realized that I can share my knowledge with people on YouTube and through my blog. So, here I am. You can ask me if you have any question about these technologies.
Thanks,
@TubeMint