I must be overlooking something

[Sylverlin]

Ok I'm at this point of setting up the server(pc2):

4. Now go to the machine that has c:\mysql\bin file and run the mysql.exe window.
Type in "use eq" without quote, and press Enter
type in "INSERT INTO account" without quote, and press Enter
Type in "SET name='eqemu', password='eqemu', status=200;" without quote, and press ENTER
type in "exit" without quote, and press enter

now when I start to type in "use eq" at the command prompt I get an error saying invalid login. Now if I just type it as "useeq" I can continue on. The rest of it I have typed it in exactly how the tutorial says and this is the error I get:

Error 1064: You have an error in your SQL syntax near 'useeq
INSERT INTO account
SET name='eqemu', password='eqemu', status=200' at line 1


now after the status=200 I did type in the ";" even though it is not showing in the error part of the command window.

Thank you in advance. =)

[rmm99]

Type in "use eq" without quote, and press Enter
type in "INSERT INTO account" without quote, and press Enter
Type in "SET name='eqemu', password='eqemu', status=200;" without quote, and press ENTER
type in "exit" without quote, and press enter

use eq; and press Enter

[rmm99]

Oops, doubled it trying to back out =b

[arkaria]

Did you create the "eq" DB first and source in the db.sql that came with your realease or one of the other 3rd party DB out there?

If you're loggin in as a user other than root you will need to make sure you executed a grant command as root to allow access to the "eq" DB

[Shawn319]

Try this...

Start->run->CMD

cd\mysql\bin

mysql -u root mysql


mysql> use eq;
mysql>

then whatever other commands you want to do..

BTW, i would highly reccomend NOT using the eqemu/eqemu account (and defenitly not make it serverop). you give too many priviliges to anyone that simply connects to your server with telnet.


ps. MySQL-Front (2.5) is a great tool for editing your DB. i'd look into that.