HOWTO: Host a 6.0 Server on Windows (Perl Quests enabled!!)

[leonskennedy]

Yeah, I cant make it work.

On the 'grant all options' part, It says

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17 to server version: 4.0.24-nt

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

mysql> GRANT ALL PRIVILEGES ON *.* TO ______@localhost IDENTIFIED BY '_____' WITH GRANT OPTION;
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
mysql>


Rest assured my mysql is in c:\mysql\bin and thats what i put. Any help?

[sysadmin]

try 127.0.0.1 instead of localhost

[leonskennedy]

Its still saying the same thing... :-(

[Cutter]

here is what i did... instead of typing all those commands..

i downloaded a program called front mysql

i use it alot to edit my database anyways..

once you get it launched...
you can goto users.. right click on the name
properties.. and you can edit the permissions .. which would include "grant"

this works..

everything you do in a command prompt you can do with this program...

just a thought and hope it helps out.. i just found this much easier to work with and this is how i got by that annoying error message