HubsInfo Network
Discord Social hublist.config Web Hosting Online Games WoW servers L2 servers Free Web Directory

Allow remote access for MySQL 8.0 on Linux and Windows

0 Members and 1 Guest are viewing this topic.

Allow remote access for MySQL 8.0 on Linux and Windows
« on: July 02, 2019, 04:49:34 AM »
For MySQL 8.0

Edit your mysqld.cnf (Open Terminal Ctrl+Alt+T)
Code: [Select]
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Add these lines right after [mysqld]
Code: [Select]
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
log-error = /var/log/mysql/error.log
bind_address = 0.0.0.0
max_allowed_packet = 256M
max_connect_errors = 100000
skip_external_locking
skip_name_resolve


--

 


Linux Ubuntu Guides Linux games - Lutris.net