Hello,
I have an interesting problem. I installed mysql client and server from Redhat
7.3 RPM. Then I set up a username and password for a user monty (to use
example from the manual).
Then I grant priveleges for the user with:
mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
and restarted mysql server. Let's assume the server name is sql.domain.edu
I then tried to connect to the server as user monty from localhost:
$> mysql -u monty -p
and then tried it from another machine console:
$> mysql -u monty -h sql.domain.edu -p
and all is well.
But when i tried to connect using the console from localhost (ie.
sql.domain.edu) by specifiying hostname:
$> mysql -u monty -h sql.domain.edu -p
I got the "cannot connect user [EMAIL PROTECTED]" error message. Why does
this happen?
I fixed this by doing
mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
but I thought I already specified the wildcard on my previous grant previlege
so that monty can access from *any* machine. Just curious as t why this
happens, can anyone help?
Thanks a lot.
Reuben D. Budiardja
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
