Looks like is to do with MySQL permissions. Check your host's (the one you
are trying to connect from) permissions to the server.

To change permissions, from the MySQL prompt type;

GRANT ALL ON * TO username@host IDENTIFIED BY password;

Substitute in username, host and password for your ones.

Easier to use PHPMyAdmin or SQLYog (www.sqlyog.com) if you're new to it. I'm
pretty new, so learning all the time.

A couple of links to get you started;
http://www.mysql.com/doc/en/GRANT.html
http://www.mysql.com/doc/en/GRANT.html

Good luck,

Nick



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2003 13:20
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL problem -- new to PHP


Hi all

I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.

My sample code is:

----------------------------------
<?php
mysql_connect(localhost,"username","password") or die ("Unable to connect to
MySQL server.");
$db = mysql_select_db("DB_NAME") or die ("Unable to select requested
database.");
?>
-----------------------------------

This throws the following error:

-----------------------------------
Warning: MySQL Connection Failed: Host 'my.host.name' is not allowed to
connect to this MySQL server
-----------------------------------

Now, the mySQL server and the web server reside on the same machine. This
warning is therefore saying that this machine does not have permission to
connect to itself. Hmm. I have put entries in the host table and the user
table, using both hostname and ip address, but no luck. I keep getting the
same error.

What am I doing wrong?

Any and all help appreciated.

Thanks

Evan Morris
[EMAIL PROTECTED]
+27 11 792 2777 (tel)
+27 11 792 2711 (fax)



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


This private and confidential e-mail has been sent to you by Egg.
The Egg group of companies includes Egg Banking plc
(registered no. 2999842), Egg Financial Products Ltd (registered
no. 3319027) and Egg Investments Ltd (registered no. 3403963) which
carries out investment business on behalf of Egg and is regulated
by the Financial Services Authority.  
Registered in England and Wales. Registered offices: 1 Waterhouse Square,
138-142 Holborn, London EC1N 2NA.
If you are not the intended recipient of this e-mail and have
received it in error, please notify the sender by replying with
'received in error' as the subject and then delete it from your
mailbox.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to