New Server Install

Tom Chubb wrote:
>
>
> 2008/9/11 Ashley Sheridan <ash@ashleysheridan.co.uk
> <mailto:ash@ashleysheridan.co.uk>>
>
> I believe that MySQL uses a particular port when connecting over a
> network such as you're doing. I can't remember the exact port number,
> but you can Google it. Just check that there's nothing blocking this
> port either on your computer, the server, or the router/switch or
> whatever else you are using to connect the computers on the network
>
>
> Ash
> www.ashleysheridan.co.uk <http://www.ashleysheridan.co.uk>
>
>
> ---------- Forwarded message ----------
> From: Shawn McKenzie <nospam@mckenzies.net
> <mailto:nospam@mckenzies.net>>
> To: php-general@lists.php.net <mailto:php-general@lists.php.net>
> Date: Wed, 10 Sep 2008 21:31:41 -0500
> Subject: [php] Re: New Server Install
> Shawn McKenzie wrote:
>
> Robbert van Andel wrote:
>
> I am working on a new webserver running Fedora 9. I
> installed php-mysql and
> php-mssql via yum. When I try to connect to our mysql
> server using php, I
> get the following error: Can't connect to MySQL server on
> 'mysqlservername'
> (13)
>
>
> Here's the weird part, I can connect to the mysql database
> server just fine
> from the web server's command line so I'm pretty confident
> that it's not a
> firewall issue. While trying to connect using PHP, I see
> no packets leaving
> the webserver.
>
> Any thoughts?
>
>
> Thanks,
>
> Robbert
>
>
>
> Well, for MySQL there are multiple user perms. In the user
> table you may see multiple entries for, let's say root.
>
> mysql> use mysql;
> mysql> select host,user,password from user;
>
> host user password
> * root *22669F8A96AC3CE42B3E5E8087893840412E035F
> localhost root
>
> So, root, if accessing from localhost, requires NO paswword.
> But root, accessing from any other host requires a password.
> Also, this could have more host entries, but probably not by
> default.
>
> If your db server is on a different host from your web server,
> this or similar is most likely your problem.
>
> -Shawn
>
>
> Or, there is no * entry (all hosts). In which case you should add
> a specific entry for your web server.
>
> -Shawn
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> I was trying to access MySQL on a remote server from an Excel
> spreadsheet and I think it was port 3306 but I still haven't got it
> working yet!
> HTH

Install MyODBC and setup an ODBC connection on your PC.

-Shawn

2008/9/11 Shawn McKenzie <nospam@mckenzies.net>

>
>
> Tom Chubb wrote:
>
>>
>>
>> 2008/9/11 Ashley Sheridan <ash@ashleysheridan.co.uk <mailto:
>> ash@ashleysheridan.co.uk>>
>>
>> I believe that MySQL uses a particular port when connecting over a
>> network such as you're doing. I can't remember the exact port number,
>> but you can Google it. Just check that there's nothing blocking this
>> port either on your computer, the server, or the router/switch or
>> whatever else you are using to connect the computers on the network
>>
>>
>> Ash
>> www.ashleysheridan.co.uk <http://www.ashleysheridan.co.uk>
>>
>>
>> ---------- Forwarded message ----------
>> From: Shawn McKenzie <nospam@mckenzies.net
>> <mailto:nospam@mckenzies.net>>
>> To: php-general@lists.php.net <mailto:php-general@lists.php.net>
>> Date: Wed, 10 Sep 2008 21:31:41 -0500
>> Subject: [php] Re: New Server Install
>> Shawn McKenzie wrote:
>>
>> Robbert van Andel wrote:
>>
>> I am working on a new webserver running Fedora 9. I
>> installed php-mysql and
>> php-mssql via yum. When I try to connect to our mysql
>> server using php, I
>> get the following error: Can't connect to MySQL server on
>> 'mysqlservername'
>> (13)
>>
>> Here's the weird part, I can connect to the mysql
>> database
>> server just fine
>> from the web server's command line so I'm pretty confident
>> that it's not a
>> firewall issue. While trying to connect using PHP, I see
>> no packets leaving
>> the webserver.
>> Any thoughts?
>>
>> Thanks,
>>
>> Robbert
>>
>>
>>
>> Well, for MySQL there are multiple user perms. In the user
>> table you may see multiple entries for, let's say root.
>>
>> mysql> use mysql;
>> mysql> select host,user,password from user;
>>
>> host user password
>> * root *22669F8A96AC3CE42B3E5E8087893840412E035F
>> localhost root
>>
>> So, root, if accessing from localhost, requires NO paswword.
>> But root, accessing from any other host requires a password.
>> Also, this could have more host entries, but probably not by
>> default.
>>
>> If your db server is on a different host from your web server,
>> this or similar is most likely your problem.
>>
>> -Shawn
>>
>>
>> Or, there is no * entry (all hosts). In which case you should add
>> a specific entry for your web server.
>>
>> -Shawn
>>
>> -- PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>> I was trying to access MySQL on a remote server from an Excel spreadsheet
>> and I think it was port 3306 but I still haven't got it working yet!
>> HTH
>>
>
> Install MyODBC and setup an ODBC connection on your PC.
>
> -Shawn
>

Did that and got an error response. I think it's the remote host but was
late Friday afternoon last week and haven't got round to trying it again.
Thanks though.
Anyway, sorry this is veering OT