View source for 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 WITH mysql_native_password BY 'password';

Output should look like <code>Query OK, 0 rows affected (0.01 sec)</code>

Edit the password if needed later

 ALTER USER 'joey'@'localhost' IDENTIFIED WITH mysql_native_password 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;

===Remote Access===

If you are getting "Connection refused" after setting up all the security groups and can't figure out why confirm that the bind address is 0.0.0.0 instead of 127.0.0.1.

 sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Find the section labeled <code>[mysqld]</code> and confirm the settings are as follows.

 bind-address            = 0.0.0.0
 mysqlx-bind-address     = 127.0.0.1

==Management==

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

===Mac===

*[https://apps.apple.com/us/app/sequel-ace/id1518036000 Sequel Ace]

===Web===

*[[PHPMyAdmin Install on Ubuntu Server|PHPMyAdmin]]

[[Category: Homelab]]