HubsInfo Network

General discussions => Servers and Networking [IT & Datacenter] => Topic started by: Remix on July 02, 2019, 04:49:34 AM

Title: Allow remote access for MySQL 8.0 on Linux and Windows
Post by: Remix 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


--