Zace
11-06-2004, 09:20 AM
I am using my EQ database.
I have typed the command
GRANT ALL PRIVILEGES ON *.* TO xxxx@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
However I ALWAYS get 0 rows affected.
The problem is how do i work out which xxxx and password i use.
Am i supposed to use the oceral MySQL one ? If so (I set MySQL up last year!!) am using the name on the winmysqladmin window.
However that failed, as did root, and all the names i added as eq users. I also checked c:\winnt\my.ini and used the details stored in there too!!!
This is causing me good old 1017 error and i dont really want to have to wipe out all my other databases just to get this one running.
I have typed the command
GRANT ALL PRIVILEGES ON *.* TO xxxx@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
However I ALWAYS get 0 rows affected.
The problem is how do i work out which xxxx and password i use.
Am i supposed to use the oceral MySQL one ? If so (I set MySQL up last year!!) am using the name on the winmysqladmin window.
However that failed, as did root, and all the names i added as eq users. I also checked c:\winnt\my.ini and used the details stored in there too!!!
This is causing me good old 1017 error and i dont really want to have to wipe out all my other databases just to get this one running.