MySQL Server Install on Ubuntu Server: Difference between revisions

From Joey's Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 21: Line 21:
Create a new user, where 'password' is your password
Create a new user, where 'password' is your password


  CREATE USER 'joey'@'localhost' IDENTIFIED BY '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>
Output should look like <code>Query OK, 0 rows affected (0.01 sec)</code>
Line 27: Line 27:
Edit the password if needed later
Edit the password if needed later


  ALTER USER 'joey'@'localhost' IDENTIFIED BY 'new_password';
  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)
Next, grant privileges as needed (this example grants ALL privileges so use sparingly)

Revision as of 21:10, 15 November 2024

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 Query OK, 0 rows affected (0.01 sec)

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 [mysqld] 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

Web

Retrieved from "https://joeybabcock.me/wiki/index.php?title=MySQL_Server_Install_on_Ubuntu_Server&oldid=3550"