Creating Database peq;

[Havocide]

Having a bit of a problem getting this DB implanted in mysql. I am using mysql 5.0. When i open up the CMD window and cd\ to my D: root. I type as follows D:mysql "User" "password" and it brings up the Options list for mysql. But i don't get past this. I tried to D:create database peq and it says " create is not recognized as an internal or external command, operable program or batch file.

I'm not sure what to do at this point. Any help with this would be greatly appriciated.

[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');