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
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
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';
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?
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
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???
Where do you get the 1045, starting world.exe, or using mysql.exe ?
Daedra
09-05-2003, 09:53 AM
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
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.
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.