MySQL; Unable to create users... (this is a new one)

[IAsp4mm]

I've logged on as root; ( mysql.exe --user=root eq ) ... did the:

mysql> GRANT ALL PRIVILEGES ON *.* TO eqemu@localhost
-> IDENTIFIED BY 'testpass' WITH GRANT OPTION;

..and I always get this:

Query OK, 0 rows affected (0.00 sec)

.. It's suposed to be 1 rows affected I assume? Because no matter what user I create, and no matter what host I give ( localhost, 127.0.0.1, '%' ) ... It never seems to properly execute and save.

I've even gone so far as to download a MySQL managing software, and added full powerusers via the GUI... but same deal.. It doesnt seem to save.

and PS. It's definately a problem with the user accounts, and not something else, because I'm able to log into the database with EQItemEditor.exe, using the 'root' login, but not any of the other accounts I create.

I hope somebody recognizes this problem.

(edit): One more thing, anybody seen this before?;

" Failed to connect to database: Error: #1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. "

[Muuss]

i think you're mixing some things :

the accounts you add in the account table of your eq database won't allow you to log into mysql. They will allow you to log into your EQ server with minilogin.

the accounts that will permit a mysql login are in the table 'user' of the 'mysql' database. (the 'root' u're using is one of them).

--

for the grant all privileges, you might just do a

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

--

for the #1249 error, what version of mysql are u running ? have you modified some parameters in your mysql config ?

[IAsp4mm]

That's the problem, I can't log onto the database using anything other than the root account, even the login/pw I make when I first set-up the "../windows/my.ini" via the "WinMySQLAdmin" doesn't work.

Regarding the #1245 error, I was using a .zip'ed MySQL version, downloaded from Tucows (not edited at all), which I have now scrapped for a release downloaded straight from the MySQL website. I suspect that will solve it, but I haven't checked yet.

But basically, my problem is that nothing but 'root' works, which wouldn't really be a problem, except that it's not possible to configure the EQemu db.ini file to login via 'root'... because it demands that I fill in the "password=" field.

[IAsp4mm]

Scratch that actually, I *seem* to be able to login now using the command you suggested and the new MySQL, thanks...

And for those other novice MySQL users browsing this forum, I suggest trying out "MySQL control center", it's a GUI controller that makes the process of learning this all go by just a little bit faster.

[Muuss]

Glad you made it working :D)