[DiscordArchive] You know a GUI can connect to a server not running on the same system, right?
[DiscordArchive] You know a GUI can connect to a server not running on the same system, right?
Archived author: Revision • Posted: 2024-02-05T15:21:22.361000+00:00
Original source
You know a GUI can connect to a server not running on the same system, right?
Archived author: nirv • Posted: 2024-02-05T15:21:43.117000+00:00
Original source
Nope. I didn't.
Archived author: nirv • Posted: 2024-02-05T15:22:13.119000+00:00
Original source
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 940/mysqld
Archived author: nirv • Posted: 2024-02-05T15:22:23.975000+00:00
Original source
localhost only it seems
Archived author: Revision • Posted: 2024-02-05T15:22:50.142000+00:00
Original source
You would have to allow connections from outside the system. Edit `/etc/mysql/mysql.conf.d/mysqld.cnf` for mysql or `/etc/mysql/mariadb.conf.d/50-server.cnf` for mariadb and just comment out bind-address
Archived author: Rymercyble • Posted: 2024-02-05T15:23:11.928000+00:00
Original source
and preferably dont have password "password" after doing that
Archived author: Revision • Posted: 2024-02-05T15:23:39.387000+00:00
Original source
Assuming it's accessible from outside the local network.
Archived author: Revision • Posted: 2024-02-05T15:24:20.266000+00:00
Original source
Also, restart mysql/mariadb after making that change or it won't do crap
Archived author: nirv • Posted: 2024-02-05T15:25:01.335000+00:00
Original source
*crossing fingers* systemctl restart mysql.service
Archived author: nirv • Posted: 2024-02-05T15:25:41.397000+00:00
Original source
any sql gui you recommend? I not never not use before