View Single Post
  #1  
Old 07-18-2003, 04:46 AM
IAsp4mm
Fire Beetle
 
Join Date: Jan 2003
Posts: 6
Default MySQL; Unable to create users... (this is a new one)

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. "