Creating Database peq;

[Havocide]

Could really use some help with this. I have followed the Wikka setup guide http://www.eqemulator.net/wiki/wikka...=ws70845mysql5 from the start and have double checked all the versions of the programs needed and everything up to creating database looks like I'm on the right track but lack the database install . Anyone know what I might be doing wrong?

[John Adams]

I am not so sure we should be posting short-hand in our Wiki guides, so maybe I'll change that later. The proper command is:

C:> mysql -u root -p
Password:

^ then enter your password at that prompt.

You should now be in a prompt like:

mysql>

At that prompt, you can do those commands \u peq

Or, go long hand, and enter:

mysql> create database peq;
mysql> use peq;
mysql> GRANT ALL PRIVILEGES ON peq.* TO eq@localhost IDENTIFIED BY 'eq' WITH GRANT OPTION;
mysql> flush privileges;
mysql> source load_empty_users.sql;
mysql> source load_system.sql;

You can also try other Wiki articles that are not specific to your SQL version, they sometimes offer missing bits or clarification of syntax.

http://www.eqemulator.net/wiki/wikka...indowsServer70

[Havocide]

Not working. I cant even access the mysql>

[mickey3506]

under your start menu you should have a mysql and in it there should be a mysql commandline and you can enter that way

[Angelox]

did you do this?

SET PASSWORD FOR eq@localhost = OLD_PASSWORD('eq');

[Kayot]

You did check add path to bin right?

[Darkonig]

did you do this?

Code:
SET PASSWORD FOR eq@localhost = OLD_PASSWORD('eq');

That is only needed if you are converting a database from 4.x not for loading up a fresh database in 5.x from a dump. Did not use this command on my install and it works great.