[FX.php List] [OFF] Anyone Fluent with setting up Wordpress?

[Gareth Evans]

MySQL is running but the user you are connecting with doesn't have
privileges to connect from that hostname. You'll need to GRANT privileges
for that specific hostname or use a wildcard for the host. I use phpMyAdmin
for this, don't know if the MySQL Manager can but I would imagine it should.
-- 
GARETH EVANS


> From: Bob Patin <bob at patin.com>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Tue, 27 Jan 2009 17:33:34 -0600
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: Re: [FX.php List] [OFF] Anyone Fluent with setting up Wordpress?
> 
> It was all working, but I decided to update PHP, which went fine.
> 
> But now, I can't connect to my MySQL databases; I have a messageboard
> on this server too, something my client bought and I installed, which
> also uses MySQL, and it also fails to connect now.
> 
> So something I did seems to be keeping the databases from being
> accessible.
> 
> On OS X Server there's a handy tool called MySQL Manager; I double-
> checked it and confirmed that MySQL's running.
> 
> Then I restarted the machine, but that didn't help either. Neither
> database can be connected to...
> 
> I then found a script for testing MySQL connections, and that shows
> failure too.
> 
> In Navicat, which is an app I use to set up databases, it has a
> Connection Test button, which works. But that's local, so maybe that's
> why it works and the outside world does not? However, that being the
> case, why can't these 2 sites connect, since they're also local?
> 
> I found this PHP, which tests a connection:
> 
> $link = mysql_connect($hostname,$dbuser,$dbpassword);
> if (!$link) {
> die('Could not connect to MySQL: ' . mysql_error());
> }
> 
> echo 'Connection OK';
> mysql_close($link);
> 
> I put this into a PHP page with a little form that sends the values to
> it, and it shows this error:
> 
> Could not connect to MySQL: Host
> 'dsl253-081-208.bna1.dsl.speakeasy.net' is not allowed to connect to
> this MySQL server
> 
> The host above is the web server...
> 
> Anyone know why I'm getting this error? Does this mean that MySQL
> really *isn't* running, even though MySQL Manager says that it is?
> 
> Oh-so-confusing,
> 
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> Twitter: bobpatin
> iChat/AIM: bobpatin
> FileMaker 9 Certified Developer
> Member of FileMaker Business Alliance & TechNet
> --------------------------
> FileMaker hosting and consulting for all versions of FileMaker
> PHP € Full email services € Free DNS hosting € Colocation € Consulting
> 
> On Jan 27, 2009, at 5:21 PM, Karl Johnson wrote:
> 
>> Min requirements are MySQL 4.0, and PHP 4.3.  OS X server 10.4 comes
>> with Apache 1.3 installed, 2 is available on the dvd but at the time
>> 2 was not production ready.  The best option to updating Apache is
>> to download the newest version and update.
>> 
>> Apache 1.3 is still valid for WordPress based on what I have seen
>> but Apache 2.2.11 is the current version.
>> 
>> If the php upgrade doesn't help, I would recommend updating Apache
>> as well.
>> 
>> Karl
>> 
>> 
>> On Jan 27, 2009, at 2:21 PM, Bob Patin wrote:
>> 
>>> Karl,
>>> 
>>> The web server is running PHP 4, so it may be time to update to PHP
>>> 5, which might fix the problem.
>>> 
>>> It's an Apple Xserve running OS X Server, which is Apache.
>>> 
>>> I couldn't tell you what version of MySQL is running on it, or
>>> Apache, for that matter. It's OS X Server 10.4.11, for what that's
>>> worth.
>>> 
>>> I think it's Apache 2, from what I'm seeing on Apple's website.
>>> 
>>> I'm updating PHP now... that might fix it...
>>> 
>>> Thanks,
>>> 
>>> BP
>>> 
>>> Bob Patin
>>> Longterm Solutions LLC
>>> bob at longtermsolutions.com
>>> 615-333-6858
>>> http://www.longtermsolutions.com
>>> Twitter: bobpatin
>>> iChat/AIM: bobpatin
>>> FileMaker 9 Certified Developer
>>> Member of FileMaker Business Alliance & TechNet
>>> --------------------------
>>> FileMaker hosting and consulting for all versions of FileMaker
>>> PHP € Full email services € Free DNS hosting € Colocation €
>>> Consulting
>>> 
>>> On Jan 27, 2009, at 3:55 PM, Karl Johnson wrote:
>>> 
>>>> Most of the sites I maintain we can use cPanel to update.  But I
>>>> did have to manually update from 2.07 to 2.7 and it worked fine.
>>>> I was a little concerned as it was such a large update but
>>>> following the update instructions it worked like a charm.
>>>> 
>>>> Let me think on this for a bit and see if I can come up with a
>>>> possible solution for why admin is giving you problems.  It
>>>> shouldn't be an issue.
>>>> 
>>>> Can you give me some specs on the server - mysql version, php
>>>> version, apache version?  I am wondering if there is a problem
>>>> there.
>>>> 
>>>> Karl
>>> 
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
>> Karl Johnson, Tech Dog
>> "to code or not to code, that is the question"
>> beachdog.com:  are you ready to wag?
>> PO Box 954 € 1517 Pacific Ave N € Long Beach, WA 98631
>> http://www.beachdog.com € 360.642.4431 € karl at beachdog.com
>> 
>> websites € brochures € business cards € postcards € logos
>> It's not about what we do.  It's about what our process and products
>> do for you.
>> 
>> 
>> 
>> 
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list