Hi All, Can anyone tell me how can i select and upload files using php. Thanks in advance, Gabriel, ----- Original Message ----- From: "Clarkson, Nick" <Nick.Clarkson@egg.com> To: <php-db@lists.php.net> Sent: Thursday, February 13, 2003 10:59 AM Subject: RE: MySQL problem -- new to PHP > > 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: evan@exclusivebooks.com [mailto:evan@exclusivebooks.com] > Sent: 13 February 2003 13:20 > To: php-db@lists.php.net > Subject: 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 > evan@exclusivebooks.com > +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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php