Install and setup mysql on Ubuntu

Install and setup mysql on Ubuntu:

Origial instructions here:

https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04

Install mysql:

sudo apt install mysql-server

Setup Security:

sudo mysql_secure_installation

Allow login from other apps:

sudo mysql
SELECT user,authentication_string,plugin,host FROM mysql.user;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourSuperSecurePassword11!';
exit

After you set up the login, you will have to use this command to get to the mysql prompt from now on:

mysql -u root -p

Also consider installing:

MySQL Workbench

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.