Thread: perl problem
View Single Post
  #2  
Old 03-05-2008, 02:42 PM
Secrets's Avatar
Secrets
Demi-God
 
Join Date: May 2007
Location: b
Posts: 1,449
Default

In addition to the above, i'd like to put this out here for reference.

The only reason you're getting a user not found error is because you're trying to set a password for a non-existant user.

You can do this in three simple queries:

Code:
create user eqemu;
^ creates the user

Code:
grant all on *.* TO 'eqemu'@'localhost';
^ makes it root

Code:
flush privileges;

That will set up user eqemu. Now, you can go ahead and do the things listed in the post above me.

Since there's no password for our new user, you need to set one. (Well, you don't, but it helps, right?)

Replace newpwd with the password you want, do not delete the ' marks.


Code:
set password for 'root'@'localhost' = OLD_PASSWORD('newpwd');
Got that?

After that is done, use the username and password you JUST created for your server, and it will boot up.

Good job, you fixed your username problem, remember to edit eqemu_config.xml, use the guide on the wiki to edit the eqemu_config.xml

YOU CANNOT RUN A SERVER WITHOUT DOING THAT.

sidenote:
Quote:
This is also a good idea for people who don't want to have a root account used for everything, or allowing root access to other machines, simply replace the hostname and grant privileges, and you can use another machine to run the game server, similar to a server "farm".
Reply With Quote