View Single Post
  #5  
Old 06-08-2003, 05:44 AM
personasect
Fire Beetle
 
Join Date: Jun 2003
Posts: 1
Default Re: Newbie LAN Creation Guide...

Quote:
Originally Posted by Ragnarok
Now type:

INSERT INTO account SET name='Test', password='123', status=200;

GRANT ALL PRIVILEGES ON *.* TO 'Test'@192.168.0.1 IDENTIFIED BY '123' WITH GRANT OPTION;
Do not run Grant... That gives access to your mySQL server. This may be fine if it is just for everquest, but for most it isnt. From what I can see, the way this is writen, only the insert needs to be done, as the user does not have to log into the mySQL server, the eqemu app does that. I personaly use mySQL for web based development, and can honestly tell you that that is a major security risk, and you are also leaving yourself open to having one of your players signing into the sql server and setting their level to 200