Hi,
I am new to MySQL and SQL in genreal. I just installed mysql 3.23.55 on my Red Hat Linux 7.1.
I tried to GRANT user in the following way: CREATE DATABASE izdb; GRANT ALL ON izdb.* TO iz1 IDENTIFIED BY 'iz'; GRANT ALL ON izdb.* TO [EMAIL PROTECTED] IDENTIFIED BY 'iz'; GRANT ALL ON izdb.* TO iz3@"%" IDENTIFIED BY 'iz'; FLUSH PRIVILEGES;
It seems to me that I can only login using iz2.
The output as follows: [EMAIL PROTECTED] mysql]$ bin/mysql -u iz1 -p'iz' ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) ------------------------------------------------------------------ [EMAIL PROTECTED] mysql]$ bin/mysql -u iz2 -p'iz' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 3.23.55-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> quit Bye -------------------------------------------------------------------- [EMAIL PROTECTED] mysql]$ bin/mysql -u iz3 -p'iz' ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
------------------------------------------------------------------
Can anyone tell me what I did wrong with iz1 and iz3? I thought iz1 and iz2 should be the same and iz3 should be on any hosts.
By the way, I print out all my SHOW GRANTS command output:
Thank you.
Ian Zhang
mysql> SHOW GRANTS FOR iz1;
+---------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED] |
+---------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'iz1'@'%' IDENTIFIED BY PASSWORD '077deb434925b35d' |
| GRANT ALL PRIVILEGES ON `izdb`.* TO 'iz1'@'%' |
+---------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> SHOW GRANTS FOR iz2;
ERROR 1141: There is no such grant defined for umysql> SHOW GRANTS FOR iz3;
+---------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED] |
+---------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'iz3'@'%' IDENTIFIED BY PASSWORD '077deb434925b35d' |
| GRANT ALL PRIVILEGES ON `izdb`.* TO 'iz3'@'%' |
+---------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> SHOW GRANTS FOR [EMAIL PROTECTED];
ERROR 1141: There is no such grant defined for user 'iz3' on host 'localhost'
ser 'iz2' on host '%'
mysql> SHOW GRANTS FOR [EMAIL PROTECTED];
+-----------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED] |
+-----------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'iz2'@'localhost' IDENTIFIED BY PASSWORD '077deb434925b35d' |
| GRANT ALL PRIVILEGES ON `izdb`.* TO 'iz2'@'localhost' |
+-----------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
