List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:June 8 1999 9:17pm
Subject:Re: Please help: host access failing - doesn't make sense
View as plain text  
Hi Eduardo,

You might consider one of the graphical administration programs for MySQL
(xmysqladmin/kmysqladmin) -- they make it easy to visualize "inherited"
permissions for host/db/user

ciao,

Graeme
----- Original Message -----
From: Eduardo Fernandez Corrales <eduardo@stripped>
To: <mysql@stripped>
Sent: Tuesday, June 08, 1999 3:40 PM
Subject: Please help: host access failing - doesn't make sense


> Hello,
>
> this is my permisions configuration:
>
>  select * from host;
>
+-------------------+----+-------------+-------------+-------------+--------
-----+-------------+-----------+
> | Host              | Db | Select_priv | Insert_priv | Update_priv |
> Delete_priv | Create_priv | Drop_priv |
>
+-------------------+----+-------------+-------------+-------------+--------
-----+-------------+-----------+
> | localhost         | %  | Y           | Y           | Y           |
> Y           | Y           | Y         |
> | flik              | %  | Y           | Y           | Y           |
> Y           | Y           | Y         |
> | flik.sistelnet.es | %  | Y           | Y           | Y           |
> Y           | Y           | Y         |
>
+-------------------+----+-------------+-------------+-------------+--------
-----+-------------+-----------+
> 3 rows in set (0.00 sec)
>
> mysql> select * from user;
>
+-----------+------+----------+-------------+-------------+-------------+---
----------+-------------+-----------+-------------+---------------+---------
-----+-----------+
> | Host      | User | Password | Select_priv | Insert_priv | Update_priv
> | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |
> Process_priv | File_priv |
>
+-----------+------+----------+-------------+-------------+-------------+---
----------+-------------+-----------+-------------+---------------+---------
-----+-----------+
> | localhost | root |          | Y           | Y           | Y
> | Y           | Y           | Y         | Y           | Y             |
> Y            | Y         |
> | localhost |      |          | N           | N           | N
> | N           | N           | N         | N           | N             |
> N            | N         |
> | flik      | root |          | Y           | Y           | Y
> | Y           | Y           | Y         | Y           | Y             |
> Y            | Y         |
> | flik      |      |          | N           | N           | N
> | N           | N           | N         | N           | N             |
> N            | N         |
>
+-----------+------+----------+-------------+-------------+-------------+---
----------+-------------+-----------+-------------+---------------+---------
-----+-----------+
> 4 rows in set (0.00 sec)   select * from db;
>
+------+---------+------+-------------+-------------+-------------+---------
----+-------------+-----------+
> | Host | Db      | User | Select_priv | Insert_priv | Update_priv |
> Delete_priv | Create_priv | Drop_priv |
>
+------+---------+------+-------------+-------------+-------------+---------
----+-------------+-----------+
> | %    | test    |      | Y           | Y           | Y           |
> Y           | Y           | Y         |
> | %    | test\_% |      | Y           | Y           | Y           |
> Y           | Y           | Y         |
> | %    | %       | %    | Y           | Y           | Y           |
> Y           | Y           | Y         |
>
+------+---------+------+-------------+-------------+-------------+---------
----+-------------+-----------+
> 3 rows in set (0.00 sec)
>
> (I added this last row in utter despair)
>
> With this configuration, access via php-cgi-mysql to query a table fails
> with a message:
>
> Warning: MySQL Connection Failed: Host 'flik.sistelnet.es' is not
> allowed to connect to this MySQL server in/var/www/hefagra/hefagra.php3
> on line 18
> Unable to connect to database
>
> I also try to telnet to flik.sistelnet.es 3306 (even from the localhost)
> and I get this message;
> JHost 'flik.sistelnet.es' is not allowed to connect to this MySQL
> serverConnection closed by foreign host.
>
> Strangely enough if from that machine I type telnet localhost 3306, the
> connection is accepted.
>
> This setup was working perfectly (and really fast!) two days ago. After
> rebooting the machine, it doesn't work anymore.
>
> The system is a Debian 2.1 (kernel 2.0.34), running 3.21.33b
>
> Where can the problem be? Thanks in advance.
>
> --
> Eduardo Fernández Corrales
> eduardo@stripped
> Sistelnet Integraciones Telemáticas - http://www.sistelnet.es
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread4795@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>

Thread
Please help: host access failing - doesn't make senseEduardo Fernandez Corrales8 Jun
  • Re: Please help: host access failing - doesn't make sensewebmaster8 Jun
  • Re: Please help: host access failing - doesn't make senseEduardo Fernandez Corrales9 Jun
  • Re: Please help: host access failing - doesn't make senseGraeme B. Davis9 Jun