Administrators, Swags, Bureaucrats, Administrators
3,838
edits
MySQL Server Install on Ubuntu Server: Difference between revisions
MySQL Server Install on Ubuntu Server (view source)
Revision as of 20:49, 15 November 2024
, 15 November 2024no edit summary
(→Web) |
No edit summary |
||
| Line 32: | Line 32: | ||
GRANT ALL PRIVILEGES ON *.* TO 'joey'@'localhost' WITH GRANT OPTION; | 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== | ==Management== | ||