Log in

View Full Version : Error: 1064 i think.. HELP!


Daedra
09-05-2003, 09:08 AM
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

09-05-2003, 09:13 AM
Your jpg is not showing up (for me), can you copy and paste your mysql command and the error message ?

Daedra
09-05-2003, 09:18 AM
well i have already fixed the jpg.. minor url fail :)


//Daedra

09-05-2003, 09:19 AM
You spelled PRIVILEGES wrong ?

Daedra
09-05-2003, 09:21 AM
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
09-05-2003, 09:26 AM
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';

09-05-2003, 09:26 AM
The guide says ...

PRIVILEGES

In your screenshot you spelled it


PRIVILIGES



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

mattmeck
09-05-2003, 09:30 AM
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
09-05-2003, 09:30 AM
DOH! :D


is that the problem?

09-05-2003, 09:31 AM
I think it is just the spelling Daedra, but I could be wrong :)

Daedra
09-05-2003, 09:33 AM
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

09-05-2003, 09:35 AM
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
09-05-2003, 09:47 AM
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???

09-05-2003, 09:52 AM
Where do you get the 1045, starting world.exe, or using mysql.exe ?

Daedra
09-05-2003, 09:53 AM
mysql.exe

09-05-2003, 09:56 AM
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
09-05-2003, 10:33 AM
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
09-05-2003, 11:01 AM
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.