You have to set-up the "user" table in "mysql" db to allow connection from localhost. Example dump:
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 | +----------------+---------+------------------+-------------+-------------+- ------------+-------------+-------------+-----------+-------------+--------- ------+--------------+-----------+------------+-----------------+----------- -+------------+ | localhost | user | 0b9eds906f2a51e3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +----------------+---------+------------------+-------------+-------------+- ------------+-------------+-------------+-----------+-------------+--------- ------+--------------+-----------+------------+-----------------+----------- -+------------+ mike -----Original Message----- From: Martin Morissette [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 8:11 PM To: MySQL Mailing List Subject: MySQL not letting me connect... PLEASE help me somebody! I've been trying to set up MySQL for quite some time now but for some reason I keep getting the following error: ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL server Is this an error due to a misconfiguration of MySQL? If so, could someone please help me out. Thank You, Martin Morissette --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
