Error: 1064 i think.. HELP!

[Daedra]

Hi all...

I'm trying to make my own server, but i dont got any idea how mysql works or anything, but when... well look for your self.

http://www.z-tec.dk/pics/error-1064.jpg


well the problem is, what should i write in :

GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

//Daedra

Your jpg is not showing up (for me), can you copy and paste your mysql command and the error message ?

[Daedra]

well i have already fixed the jpg.. minor url fail :)


//Daedra

You spelled PRIVILEGES wrong ?

[Daedra]

thats strange, on the guide i follow there stands :

<More lines will scroll by, you might wanta go make some food at this point ,as this will take 10min plus to finish, again ignore the beeping. Then type >

GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

After it finishs Type " Exit " . MySQL will close.

http://www.eqemulator.net/serverguide.php

[Daedra]

Well, my real problem is that : i dont know what to write, it does'nt seem right to write:


GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

is it something like :

GRANT ALL PRIVILEGES ON *?* to 'Username/password'@localhost IDENTIFIED BY 'Username/password';

The guide says ...

PRIVILEGES

In your screenshot you spelled it


PRIVILIGES



i.e. should be E, not I, in position 7

[mattmeck]

there is a whole lot of threads answering this question, go to search and put in your error number and you will be surprised at how many diferent fixxes for this there is, some work for 1 person not for others others work for other people ect. just keep trying the fixes till you find the one that works for you.

[Daedra]

DOH! :D


is that the problem?

I think it is just the spelling Daedra, but I could be wrong :)

[Daedra]

hmm well i still keep getting the same error


ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near ''* to '%'@lo
calhost IDENTIFIED BY '%';
Grant ALL PRIVILEGES ON

C:\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.12-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';
Query OK, 0 rows affected (0.00 sec)

mysql>

*shrug* ... it works for me :(

EDIT: Copy and paste this

GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

into mysql and see if that works

[Daedra]

well there's a good news, and a bad...


The good first : it got pass the error:1064,

The bad : error-1045, something about i dont got a password?


where should i write the pass???

Where do you get the 1045, starting world.exe, or using mysql.exe ?

[Daedra]

mysql.exe

If you're starting mysql with ...

mysql -u root

then I am out of ideas, sorry. Try searching the forums for 1045 ... might be an answer there, or hopefully someone else might know what is wrong :)

[Daedra]

hmm, oh i guess you went to bed... well hope somebody can help me tomorrow or maybe later tonight, i really need this... :)


// :twisted: Daedra :twisted:

[mattmeck]

there is a whole lot of threads answering this question, go to search and put in your error number and you will be surprised at how many diferent fixxes for this there is, some work for 1 person not for others others work for other people ect. just keep trying the fixes till you find the one that works for you.

......i already told you how to find your answer.