[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?
Original source
You know a GUI can connect to a server not running on the same system, right?
rektbyfaith
02-05-2024, 03:21 PM #1Archived 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?
Original source
Nope. I didn't.
rektbyfaith
02-05-2024, 03:21 PM #2Archived author: nirv • Posted: 2024-02-05T15:21:43.117000+00:00
Original source
Nope. I didn't.
Original source
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 940/mysqld
rektbyfaith
02-05-2024, 03:22 PM #3Archived 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
Original source
localhost only it seems
rektbyfaith
02-05-2024, 03:22 PM #4Archived author: nirv • Posted: 2024-02-05T15:22:23.975000+00:00
Original source
localhost only it seems
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
rektbyfaith
02-05-2024, 03:22 PM #5Archived 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
Original source
and preferably dont have password "password" after doing that
rektbyfaith
02-05-2024, 03:23 PM #6Archived author: Rymercyble • Posted: 2024-02-05T15:23:11.928000+00:00
Original source
and preferably dont have password "password" after doing that
Original source
Assuming it's accessible from outside the local network.
rektbyfaith
02-05-2024, 03:23 PM #7Archived author: Revision • Posted: 2024-02-05T15:23:39.387000+00:00
Original source
Assuming it's accessible from outside the local network.
Original source
Also, restart mysql/mariadb after making that change or it won't do crap
rektbyfaith
02-05-2024, 03:24 PM #8Archived 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
Original source
*crossing fingers* systemctl restart mysql.service
rektbyfaith
02-05-2024, 03:25 PM #9Archived author: nirv • Posted: 2024-02-05T15:25:01.335000+00:00
Original source
*crossing fingers* systemctl restart mysql.service
Original source
any sql gui you recommend? I not never not use before
rektbyfaith
02-05-2024, 03:25 PM #10Archived author: nirv • Posted: 2024-02-05T15:25:41.397000+00:00
Original source
any sql gui you recommend? I not never not use before