Friday, 23 August 2019

Connect MySQL Workbench on PC to remote MariaDB server

MySQL Workbench operates on my PC at home with IP 1.2.3.4 and MariaDB is located on my server with IP 4.3.2.1.


https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/ describes editing /etc/my.cnf, but shows commenting out lines which do not exist in mine.


When I test my remote connection, I get error 10060 (denied).


How is this accomplished?


[root@greenbeantech etc]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[root@greenbeantech etc]#

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...