question about eqemu admin tool

Memener · #1 03-11-2003, 06:25 PM

Hmm just wondering on my LAN server i use a 433Mhz computer as the world server and it host mysql DB. Is there a way that i can log in to the DB using EQemu ADMIN and change, edit stuff? i have tried changing the IP from 127.0.0.1 to 192.168.2.12 and evertime i run world.exe it says bad user name a password BUT if the IP is 127.0.0.1 it has no problem, is there a way to fix this?

toiletpunks · #2 03-12-2003, 03:01 AM

You should be able to log in with the admin tool. But i think you may have to be on the same computer the database is on to log in with it. watch me be wrong though. its been a while since ive worked with it. and for the server error. have you checked the ini files to make sure that you have everything set up right and read the readme file it should help to. If you have already done this im sorry.
Here's the readme
http://www.eqemu.net/documents/readme.html
hope this helps some. ill check back up on this topic soon la8er

#3 03-13-2003, 11:24 PM

I'm having a problem similar to yours, I'm a GM on a server and the host gave me access to his DB and I try to log on and I get this error: [Endless Time] ERROR 1045: Access denied for user: 'izagod@c-66-177-194-85.se.client2.attbi.com' (Using password: YES) this error is from the MySQL Control Center but I get the error from both the CC and FQADMIN

Trumpcard · #4 03-13-2003, 11:39 PM

I'd say he wasn't very good at providing your access..;

LOL...

Heres a quick mysql permissions tutorial.

To give a user permissions in mysql, you use a command of the syntax

GRANT ALL PRIVILEGES on database.tablenames to user@ip identified by 'somepassword' with GRANT OPTIONS;

If you want that user to be able to connect from anywhere, the ip is replaced with a '%' , which is basically a wildcard.

To give someone access to your entire database, the destination would be *.*, or just say the eq database, eq.*, or just the items table, eq.items.
All of this information is readily available in the mysql manual. Not to be a stick in the mud, but if you're going to try and run a server, you really need to get familiar with using it. This is not EQEMU specific problems, this is just using a mysql database in general.

Tell him to use username@'%' to set the permissions...