Also be careful with this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html
(after to establish a connection) Edwin. -----Mensaje original----- De: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 09 de Marzo de 2006 02:17 p.m. Para: Mary Adel CC: [EMAIL PROTECTED]; mysql@lists.mysql.com Asunto: RE: php and mysql If you still have issues after that, then read http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html Regards --------------------------------------------------------------- ********** _/ ********** David Logan ******* _/ ******* ITO Delivery Specialist - Database ***** _/ ***** Hewlett-Packard Australia Ltd **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] **** _/ _/ _/ _/ **** Desk: +618 8408 4273 **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 ***** _/ ****** ****** _/ ******** Postal: 148 Frome Street, ******** _/ ********** Adelaide SA 5001 Australia i n v e n t --------------------------------------------------------------- -----Original Message----- From: JC [mailto:[EMAIL PROTECTED] Sent: Friday, 10 March 2006 6:42 AM To: Mary Adel Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: php and mysql On Thu, 9 Mar 2006, Mary Adel wrote: > Thanks for al your help and i di that and now i have another error > > Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) my code is as follows: > > <?php > print "hi"; > mysql_connect('localhost', 'root','') or die(mysql_error()); echo > "Connected to MySQL<br />"; print "connected"; > ?> > if u can help in this i ll appreciate that a lot > > > On Thu, 2006-03-09 at 13:37 -0500, fbsd_user wrote: >> You need a login id and password unless this is test DB added under >> ID "root" You have to use the same login id as the one you created >> the db/table with. >> >> mysql_connect('localhost', 'Login id', 'pw') or die(mysql_error()) >> >> mysql_connect('localhost', 'root') or die(mysql_error()) >> >> >> -----Original Message----- >> From: Mary Adel [mailto:[EMAIL PROTECTED] >> Sent: Thursday, March 09, 2006 3:06 PM >> To: mysql@lists.mysql.com >> Subject: php and mysql >> >> >> I have a severe problem that php5 cannot connect to mysql and i don't >> know why >> also i am using linux >> here is my peice of code >> :<?php >> print "hi"; >> mysql_connect('localhost', '', '') or die(mysql_error()); >> echo "Connected to MySQL<br />"; >> print "connected"; >> ?> >> if their is any configuration please tell me >> >> thanks, >> mary >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> > > > -- hi mary, take a look at http://www.stanton-finley.net/fedora_core_5_installation_notes.html#MySQ L. basically, you need to make sure that your mysql server accepts local connection. if you login to your mysql server: mysql -u root (if no password for root) or mysql -u root -p (if there is pw for root) and then: select user,host,password from mysql.user; if you don't see an entry for root & localhost, then you need to add it in. hope that help. JC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
