Administrators, Swags, Bureaucrats, Administrators
3,841
edits
MySQL Server Install on Ubuntu Server: Difference between revisions
Jump to navigation
Jump to search
MySQL Server Install on Ubuntu Server (view source)
Revision as of 19:38, 20 February 2025
, 20 February→Configuration
(Created page with "This guide shows how to install and setup 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 Category: Homelab") |
|||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
This guide shows how to install and | This guide shows how to install and set up MySQL server on Ubuntu Server. | ||
==Installation== | ==Installation== | ||
| Line 12: | Line 12: | ||
sudo apt 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; | |||
After this you will need to log out and log back into any running sessions. | |||
===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]] | [[Category: Homelab]] | ||