I thought I had a handle on this, but now I'm all screwed up.
Windows 2000 Server
I'm trying to create a user roby with a password of 'foo' with access to everything.
Here's what happens:
- Sign in as root on the local host.
- GRANT ALL PRIVILEGES ON *.* TO roby@'%' IDENTIFIED BY 'foo' WITH GRANT OPTION;
- On same machine, try to login with: mysql -u roby -pfoo -h localhost
- Receive: ERROR 1045 (28000): Access denied for user: 'roby'@'localhost' (Using password:
I'm wondering why that doesn't work, but here's where I get REALLY confused. I can then
sign in with NO PASSWORD and get into the system:
- mysql -u roby
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 44 to server version: 4.1.1a-alpha-max-debug-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Moreoever... there is no entry for roby in the mysql.db database, which I thought was
supposed to happen when I granted everything.
I then issued:
mysql> SET PASSWORD FOR roby = PASSWORD('foo');
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.10 sec)
But still received:
C:\mysql\bin>mysql -u roby -pfoo
ERROR 1045 (28000): Access denied for user: 'roby'@'localhost' (Using password: YES)
Any help is appreciated!