PHPMyAdmin is just a web-based tool for administering MySQL and it's pretty intuitive, assuming you've used similar tools before. You can download it and read more here http://www.phpwizard.net/projects/phpMyAdmin/ I would recommend SQLYog as an alternative; http://www.webyog.com/sqlyog/index.html as it's VERY intuitive and pretty simple to use. But then you can't beat going straight into the MySQL prompt and learning from there Here are some good links for tutorials and examples; www.php.net and www.mysql.com for searching on specific functions - unless you have the memory of a few Cray computers ;o) http://www.evilwalrus.com http://www.zend.com/zend/tut/ http://www.devshed.com/Server_Side/MySQL/ http://www.devshed.com/Server_Side/PHP/ There are tons out there, but they are good starting points. Good luck, Nick -----Original Message----- From: Mark Loewenberg [mailto:Mark@ITSbiz.net] Sent: 13 February 2003 14:01 To: Clarkson, Nick Subject: Re: MySQL problem -- new to PHP Well you opened up my question! Do you know where to learn PHPMyAdmin? Thanks in advance, Mark Clarkson, Nick wrote: >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) > > > > > -- Mark Loewenberg 770 428 1071 Mark@ITSbiz.net http://www.ITSbiz.net Affordable Website Design Website Hosting @ $9.95/month ITSbiz also provides: IT Solutions Phone Systems Phone & Data Wiring Services 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
