Exactly what I was going to say ... go to www.download.com and search for
PHP Triad, which is PHP, Apache, and MySQL all in one for Windows, all FREE.
And yes, some web hosts are too cheap to give database access to their
clients for their money. If you want a good host, I can refer you to one
for a very reasonable price ...
Regards,
Matthew Moldvan
---------------------------------------
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce/
---------------------------------------
-----Original Message-----
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 4:50 PM
To: 'Robert Wagner'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: Is MySQL available from my host.
I'm pretty sure it is possible. Unless I'm wrong, PHP, by default, is
compiled with MySQL support. So, what you're seeing could be a result of
that default condition. Just because it's compiled with support for MySQL,
doesn't necessarily mean that they will provide the database server.
Please, other list members correct me if I'm wrong.
On the other hand, you don't need a web host to try out dynamic web pages.
You can configure Apache, MySQL and PHP on your local machine and do
everything locally that you would do remotely.
> -----Original Message-----
> From: Robert Wagner [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 03, 2003 4:48 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Re: Is MySQL available from my host.
>
>
> Richard:
> Thanks for your rapid reply. What their tech support is saying is
> >> Sorry, we do not offer a database server. <<
> Based on the results of the phpinfo output, is that possible?
> Thanks again,
> Robert
> ------------------
> "Richard Hutchins" <[EMAIL PROTECTED]> wrote
> in message
> 1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC">news:1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC...
> > I know when I first started working with a host that provided MySQL
> support,
> > there was a very specific path I had to use in the connection string
> because
> > "...the MySQL server is behind a very strict firewall." If I didn't
> use the
> > path exactly as their prototype indicated, I'd get errors like you
> have
> > posted.
> >
> > I'd suggest you check your host's self-help tech support pages, drop
> them an
> > e-mail or call them.
> >
> > > -----Original Message-----
> > > From: Robert Wagner [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, January 03, 2003 4:27 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP-DB] Re: Is MySQL available from my host.
> > >
> > >
> > > "Robert Wagner" <[EMAIL PROTECTED]> wrote in message
> > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > I recently signed up with a "low-cost" web server, in order
> > > to do some
> > > > web-page accessed database work. The server has PHP Version
> > > 4.0.6 and
> > > > phpinfo() yields (in part):
> > > >
> > > > PHP Version 4.0.6
> > > >
> > > > System SunOS src 5.7 Generic_106541-12 sun4u sparc
> > > > SUNW,UltraSPARC-IIi-cEngine
> > > > Build Date Feb 28 2002
> > > > Configure Command './configure' '--disable-pear'
> > > '--enable-ftp'
> > > > '--with-sybase-ct=/usr/local/freetds' '--enable-trans-sid'
> > > > '--enable-force-cgi-redirect'
> > > > Server API CGI
> > > > Virtual Directory Support disabled
> > > > Configuration File (php.ini) Path
> > > /usr/local/affinity/etc/php.ini
> > > > ZEND_DEBUG disabled
> > > > Thread Safety disabled
> > > >
> > > > This program makes use of the Zend scripting language
> engine:
> > > > Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend
> Technologies
> > > >
> > > >
> > > >
> > > > |
> > > > (Some output omitted here)
> > > > |
> > > > mysql
> > > > MySQL Support enabled
> > > > Active Persistent Links 0
> > > > Active Links 0
> > > > Client API version 3.23.32
> > > > MYSQL_MODULE_TYPE builtin
> > > > MYSQL_SOCKET /tmp/mysql.sock
> > > > MYSQL_INCLUDE
> > > > MYSQL_LIBS
> > > >
> > > >
> > > >
> > > > Directive Local Value Master Value
> > > > mysql.allow_persistent
> > > > On On
> > > > mysql.default_host
> > > > no value no value
> > > > mysql.default_password
> > > > no value no value
> > > > mysql.default_port
> > > > no value no value
> > > > mysql.default_socket
> > > > no value no value
> > > > mysql.default_user
> > > > no value no value
> > > > mysql.max_links
> > > > Unlimited Unlimited
> > > > mysql.max_persistent
> > > > Unlimited Unlimited
> > > >
> > > >
> > > > ftp
> > > > FTP support enabled
> > > >
> > > >
> > > > Additional Modules
> > > >
> > > >
> > > > Environment
> > > > Variable Value
> > > > TZ US/Pacific
> > > > DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
> > > > HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg,
> > > image/pjpeg,
> > > > application/vnd.ms-excel, application/msword,
> > > > application/vnd.ms-powerpoint,
> application/x-shockwave-flash, */*
> > > > HTTP_ACCEPT_ENCODING gzip, deflate
> > > > HTTP_ACCEPT_LANGUAGE en-us
> > > > HTTP_CONNECTION Keep-Alive
> > > > HTTP_HOST www.mymain.com (<Renamed for his message!)
> > > > HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows
> NT
> > > 5.1)
> > > > PATH /usr/bin:/bin:/usr/local/bin
> > > > REDIRECT_DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
> > > > REDIRECT_STATUS 200
> > > > REDIRECT_URL /Experiments/PHP_Info.php
> > > > REMOTE_ADDR (Deleted for this message)
> > > > REMOTE_PORT 7016
> > > > SCRIPT_FILENAME /usr/local/apache/cgi-bin/php.cgi
> > > > SERVER_ADDR 10.3.1.126
> > > > SERVER_ADMIN [EMAIL PROTECTED] (<Renamed for his
> message!)
> > > > SERVER_NAME www.mymain.com (<Renamed for his message!)
> > > > SERVER_PORT 80
> > > > SERVER_SIGNATURE
> > > > SERVER_SOFTWARE Apache/1.3.26 (Unix) mod_mhp mod_mhp_log
> > > > mod_virtcgi frontPage/5.0 mod_status_mhp
> > > > GATEWAY_INTERFACE CGI/1.1
> > > > SERVER_PROTOCOL HTTP/1.1
> > > > REQUEST_METHOD GET
> > > > QUERY_STRING
> > > > REQUEST_URI /Experiments/PHP_Info.php
> > > > SCRIPT_NAME /bin/php.cgi
> > > > PATH_INFO /Experiments/PHP_Info.php
> > > > PATH_TRANSLATED
> > > > /nfs/cust/9/36/06/260639/web/ET_Experiments/PHP_Info.php
> > > > REMOTE_HOST (Deleted for this message)
> > > > (Moreoutput omitted after this)
> > > ---------------
> > > When I posted my original message, I forgot to include the result
> I'm
> > > getting from the script:
> > > <?php
> > > mysql_connect() or
> > > die("Could not connect (sob): " . mysql_error());
> > > printf ("MySQL host info: %s\n", mysql_get_host_info());
> > > ?>
> > > ----------
> > > The result:
> > > ----------
> > > Warning: Can't connect to local MySQL server through socket
> > > '/tmp/mysql.sock' (2) in
> > >
> /nfs/cust/9/36/06/260639/web/ET_Experiments/MySQL_Info.php on line 7
> > >
> > > Warning: MySQL Connection Failed: Can't connect to local MySQL
> server
> > > through socket '/tmp/mysql.sock' (2) in
> > >
> /nfs/cust/9/36/06/260639/web/ET_Experiments/MySQL_Info.php on line 7
> > > Could not connect (sob): Can't connect to local MySQL
> server through
> > > socket '/tmp/mysql.sock' (2)
> > > ---------------
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
