View Single Post
  #4  
Old 03-13-2003, 11:39 PM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

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...
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.