Article View: dk.edb.database
Article #15060connection til mysql fra fremmet host!
From: jaton
Date: Wed, 25 Jul 2001 12:09
Date: Wed, 25 Jul 2001 12:09
27 lines
2589 bytes
2589 bytes
Jeg har f�lgende rettigheder p� min mysql. 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 | Grant_priv | References_priv | Index_priv | Alter_priv | +------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | % | | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ 1 row in set (0.00 sec) Hvilket vil sige alle kan connect fra alle hosts uden password. Hvorfor skiver den s�, ERROR 1130: Host 'host.domain.dk' is not allowed to connect to this MySQL Server n�r jeg taster $ mysql -h hostname fra en anden server. P� forh�nd tak, Jannik
Technical Details
Message-ID:
<3B5EB6E8.232C4E1D@orangedk.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.mobilixnet.dk!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,edba496d63cb8c7c,start X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-07-25 05:09:58 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.mobilixnet.dk!not-for-mail Message-ID: <3B5EB6E8.232C4E1D@orangedk.com> From: jaton <jaton@orangedk.com> X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: dk.edb.database Subject: connection til mysql fra fremmet host! Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cache-Post-Path: gwhost.mobilix.dk!unknown@jaton.intra.mobilix.dk X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) Lines: 30 Date: Wed, 25 Jul 2001 14:09:12 +0200 NNTP-Posting-Host: 212.97.206.26 X-Complaints-To: abuse@orangedk.com X-Trace: news.mobilixnet.dk 996062992 212.97.206.26 (Wed, 25 Jul 2001 14:09:52 CEST) NNTP-Posting-Date: Wed, 25 Jul 2001 14:09:52 CEST Organization: Mobilix Internet -- http://www.orangedk.com/