MySQL Server Install on Ubuntu Server

This guide shows how to install and set up MySQL server on Ubuntu Server.

Installation

Update/Upgrade any pending packages

sudo apt update

sudo apt upgrade

Install MySQL Server

sudo apt install mysql-server

Configuration

Log into the SQL server as root by running

sudo MySQL

Create a new user, where 'password' is your password

CREATE USER 'joey'@'localhost' IDENTIFIED BY 'password';

Output should look like Query OK, 0 rows affected (0.01 sec)

Edit the password if needed later

ALTER USER 'joey'@'localhost' IDENTIFIED  BY 'new_password';

Next, grant privileges as needed (this example grants ALL privileges so use sparingly)

GRANT ALL PRIVILEGES ON *.* TO 'joey'@'localhost' WITH GRANT OPTION;

Management

The following apps make it easy to manage your install after setup.

Mac

• Sequel Ace

Web

• PHPMyAdmin