[DiscordArchive] hey ppl. ive a bit lost. what do i have to put in heidisql to connect to the database?
[DiscordArchive] hey ppl. ive a bit lost. what do i have to put in heidisql to connect to the database?
Original source
hey ppl. ive a bit lost. what do i have to put in heidisql to connect to the database?
rektbyfaith
08-12-2025, 01:34 AM #1Archived author: Chris • Posted: 2025-08-12T01:34:59.807000+00:00
Original source
hey ppl. ive a bit lost. what do i have to put in heidisql to connect to the database?
Original source
The address of where the db is hosted, so if it's on the same pc, 127.0.0.1 then the username and password of the default account that is made to connect. Assuming you didn't alter it, the user and pass are both acore
rektbyfaith
08-12-2025, 01:38 AM #2Archived author: Mithria • Posted: 2025-08-12T01:38:27.413000+00:00
Original source
The address of where the db is hosted, so if it's on the same pc, 127.0.0.1 then the username and password of the default account that is made to connect. Assuming you didn't alter it, the user and pass are both acore
Original source
i made this: CREATE USER IF NOT EXISTS 'chris'@'%' IDENTIFIED BY 'mypassword';GRANT ALL PRIVILEGES ON *.* TO 'chris'@'%' WITH GRANT OPTION;
rektbyfaith
08-12-2025, 01:39 AM #3Archived author: Chris • Posted: 2025-08-12T01:39:23.873000+00:00
Original source
i made this: CREATE USER IF NOT EXISTS 'chris'@'%' IDENTIFIED BY 'mypassword';GRANT ALL PRIVILEGES ON *.* TO 'chris'@'%' WITH GRANT OPTION;
Original source
but cant connect, access denied
rektbyfaith
08-12-2025, 01:39 AM #4Archived author: Chris • Posted: 2025-08-12T01:39:38.349000+00:00
Original source
but cant connect, access denied
Original source
ip is correct
rektbyfaith
08-12-2025, 01:39 AM #5Archived author: Chris • Posted: 2025-08-12T01:39:45.093000+00:00
Original source
ip is correct
Original source
If you're using % for host then never open your mysql port unless you have a very strong password
rektbyfaith
08-12-2025, 01:41 AM #6Archived author: Mithria • Posted: 2025-08-12T01:41:12.965000+00:00
Original source
If you're using % for host then never open your mysql port unless you have a very strong password
Original source
oh man, its always the same. i tried 2h to find it out, asking you now - tried again, works....
rektbyfaith
08-12-2025, 01:42 AM #7Archived author: Chris • Posted: 2025-08-12T01:42:19.927000+00:00
Original source
oh man, its always the same. i tried 2h to find it out, asking you now - tried again, works....
Original source
is the db running, if the server is stopped?
rektbyfaith
08-12-2025, 01:42 AM #8Archived author: Chris • Posted: 2025-08-12T01:42:28.391000+00:00
Original source
is the db running, if the server is stopped?
Original source
Db is handled through the mysql service, which is separate from the Auth and worldserver executables. If mysql service is not running then the db is down
rektbyfaith
08-12-2025, 01:43 AM #9Archived author: Mithria • Posted: 2025-08-12T01:43:21.433000+00:00
Original source
Db is handled through the mysql service, which is separate from the Auth and worldserver executables. If mysql service is not running then the db is down
Original source
its only local - no open ports
rektbyfaith
08-12-2025, 01:43 AM #10Archived author: Chris • Posted: 2025-08-12T01:43:30.108000+00:00
Original source
its only local - no open ports