Hi listers,
[EMAIL PROTECTED]:~> rpm -qa |grep -i mysql
MySQL-server-4.1.14-0
MySQL-shared-4.1.14-0
MySQL-client-4.1.14-0
[EMAIL PROTECTED]:~>
[EMAIL PROTECTED]:~> uname -a
Linux myhost 2.6.5-7.108-default #1 Wed Aug 25 13:34:40 UTC 2004 i686
i686 i386 GNU/Linux
[EMAIL PROTECTED]:~>
on 12.feb.2005 i reported a problem with the privilege system of mysql.
The workaround i had found at that time was the command
flush privileges;
--------------
this morning, with the newest version of mysql before version 5, i again
did changes in the privilege domain of mysql, using commands of the type
revoke...
grant...
for which, according to the doc, no terminating
flush privileges;
should be necessary.
--------------
But, alas, clients complained that they got the following error when
trying to connect to their database:
MySQL Error Number: 1130: Host 'myhost.mydomain.com' is not allowed to
connect to this MySQL server
which, from the shell client, looks like:
[EMAIL PROTECTED]:~> mysql -h myhost -u myuser -p
Enter password:
ERROR 1130 (00000): #HY000Host 'myhost.mydomain.com' is not allowed to
connect to this MySQL server
[EMAIL PROTECTED]:~>
i then did the
flush privileges;
and everything again workes fine.
suomi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
