I am connecting from their web hosting package to their database - I would consider that local. Hours wasted on such a trivial matter... Dave T
From: Jay [mailto:[email protected]] Sent: Tuesday, 17 November 2009 1:52 p.m. To: [email protected] Subject: Re: [phpug] Re: Mysql connection string for Orcon Maybe, your database only can be accessed by a local user On Tue, Nov 17, 2009 at 1:00 PM, David Turton <[email protected]<mailto:[email protected]>> wrote: Yep, phpmyadmin connects to hostingdatabases.orcon.net.nz<http://hostingdatabases.orcon.net.nz> without any problem - but I can't connect to this from the webserver. Warning: mysql_connect(): Can't connect to MySQL server on 'hostingdatabases.orcon.net.nz<http://hostingdatabases.orcon.net.nz>' (4) in /home/users/username/domain.co.nz/testsite/test.php<http://domain.co.nz/testsite/test.php> on line 3 Could not connect: Can't connect to MySQL server on 'hostingdatabases.orcon.net.nz<http://hostingdatabases.orcon.net.nz>' (4) Trying localhost, I get: Warning: mysql_connect(): Access denied for user: 'usern...@localhost' (Using password: YES) in /home/users/username/domain.co.nz/testsite/test.php<http://domain.co.nz/testsite/test.php> on line 5 Could not connect: Access denied for user: 'usrn...@localhost' (Using password: YES) So I can connect to localhost, but user is not valid, whereas I can't connect to mysql @ hostingdatabases.orcon.net.nz<http://hostingdatabases.orcon.net.nz> I'm stumped, as is Orcon.... Back on the phone to them for th e10th time... Cheers Dave T ________________________________________ From: [email protected]<mailto:[email protected]> [[email protected]<mailto:[email protected]>] On Behalf Of Stu Meads [[email protected]<mailto:[email protected]>] Sent: Tuesday, 17 November 2009 10:40 a.m. To: [email protected]<mailto:[email protected]> Subject: [phpug] Re: Mysql connection string for Orcon PhpMyAdmin should have the hostname of the db server when you first log in. Possibly the host that your site's on doesn't have access to the database, if you can access 'privileges' from your PhpMyAdmin login, you may be able to see what hosts have access Warning: This email contains information which is CONFIDENTIAL and may also be LEGALLY PRIVILEGED. If you are not the intended recipient you must not peruse, use, disseminate, distribute or copy this email or attachments. If you have received this in error, please notify us immediately by return email and delete this email. Thank you. ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ##################################################################################### --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected]<mailto:[email protected]> To unsubscribe, send email to [email protected]<mailto:nzphpug%[email protected]> -~----------~----~----~----~------~----~------~--~--- -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] ________________________________ Warning: This email contains information which is CONFIDENTIAL and may also be LEGALLY PRIVILEGED. If you are not the intended recipient you must not peruse, use, disseminate, distribute or copy this email or attachments. If you have received this in error, please notify us immediately by return email and delete this email. Thank you. ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ##################################################################################### -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
