Maybe, your database only can be accessed by a local user On Tue, Nov 17, 2009 at 1:00 PM, David Turton < [email protected]> wrote:
> > Yep, phpmyadmin connects to 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' (4) in /home/users/username/ > domain.co.nz/testsite/test.php on line 3 > Could not connect: Can't connect to MySQL server on ' > 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 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 > > I'm stumped, as is Orcon.... > > Back on the phone to them for th e10th time... > > Cheers > Dave T > > ________________________________________ > From: [email protected] [[email protected]] On Behalf Of Stu > Meads [[email protected]] > Sent: Tuesday, 17 November 2009 10:40 a.m. > To: [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] > To unsubscribe, send email to > [email protected]<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]
