Allow remote access for MySQL 8.0 on Linux and Windows

[Remix]

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


--