Connect to MySQL

[Mr Dygi]

Hi,

PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a
problem with this simple code:

<?php
$link = mysql_connect(" 127.0.0.1",""," ")
or die("Could not connect: " . mysql_error());
echo "Connected successfully";
mysql_close($li nk);
?>

And this error occurs:

Warning: mysql_connect() : Can't connect to MySQL server on '127.0.0.1'
(10061) in C:\usr\Apache2\ htdocs\friko.pl \index.html on line 18
Could not connect: Can't connect to MySQL server on 'localhost' (10061)

The settings are:

Active Persistent Links 0
Active Links 0
Client API version 3.23.49

Directive Local Value Master Value
mysql.allow_per sistent On/On
mysql.connect_t imeout 60/60
mysql.default_h ost localhost/localhost
mysql.default_p assword no value/no value
mysql.default_p ort no value/no value
mysql.default_s ocket no value/no value
mysql.default_u ser no value/no value
mysql.max_links Unlimited/Unlimited
mysql.max_persi stent Unlimited/Unlimited
mysql.trace_mod e Off/Off

Thanks for any hints :--|

--
pozdr. Dygi [GG 1027078]
dygimail(at)poc zta(dot)fm

[Tim Van Wassenhove]

On 2004-02-04, Mr Dygi <dy********@SPA Mpoczta.fm> wrote:

Hi,

PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a
problem with this simple code:

<?php
$link = mysql_connect(" 127.0.0.1",""," ")
or die("Could not connect: " . mysql_error());
echo "Connected successfully";
mysql_close($li nk);
?>

And this error occurs:

Warning: mysql_connect() : Can't connect to MySQL server on '127.0.0.1'
(10061) in C:\usr\Apache2\ htdocs\friko.pl \index.html on line 18
Could not connect: Can't connect to MySQL server on 'localhost' (10061)

Have you installed mysql? and is it running?

--
http://home.mysth.be/~timvw

[Mr Dygi]

Tim Van Wassenhove <eu**@pi.be> wrote in news:bvqth6$vnk 5c$2@ID-
188825.news.uni-berlin.de:

Have you installed mysql? and is it running?

Here I have another problem. I think, yes. I have installed MyODB 3.51.06
fo Windows with small configure problems. I have done this with
instructions from MyQSL Reference Manual for version 4.0.5 chapter 8.3.1
and 8.3.2.

But I'am not sure I should execute these section:

* To make a connection to a Unix box from a Windows box, with an ODBC
application (one that doesn't support MySQL natively), you must first
install MyODBC on the Windows machine.
* The user and Windows machine must have the access privileges to the MySQL
server on the Unix machine. This is set up with the GRANT command. See
section 4.3.1 GRANT and REVOKE Syntax.
+ You must create an ODBC DSN entry as follows:
+ Open the Control Panel on the Windows machine.
+ Double-click the ODBC Data Sources 32-bit icon.
+ Click the tab User DSN.
+ Click the button Add.
+ Select MySQL in the screen Create New Data Source and click the Finish
button.
* The MySQL Driver default configuration screen is shown. See section 8.3.2
How to Fill in the Various Fields in the ODBC Administrator Program.
* Now start your application and select the ODBC driver with the DSN you
specified in the ODBC administrator

I have done the section but something is still wrong. I can do some screen-
prints to show You what I have done, if you need to see it.

ps
I think I have some mistakes done about installing and configuring MyODBC.

--
pozdr. Dygi [GG 1027078]
dygimail(at)poc zta(dot)fm

[Tim Van Wassenhove]

On 2004-02-04, Mr Dygi <dy********@SPA Mpoczta.fm> wrote:

Tim Van Wassenhove <eu**@pi.be> wrote in news:bvqth6$vnk 5c$2@ID-
188825.news.uni-berlin.de:

Have you installed mysql? and is it running?

Here I have another problem. I think, yes. I have installed MyODB 3.51.06
fo Windows with small configure problems. I have done this with
instructions from MyQSL Reference Manual for version 4.0.5 chapter 8.3.1
and 8.3.2.

I'm not sure, but i think MyODB provides a driver to let ODBC talk with
your MySQL server.

Thus my question remains: Have you installed mysql server? and is it
running? :)

--
http://home.mysth.be/~timvw

[rostik]

"Mr Dygi" <dy********@SPA Mpoczta.fm> wrote in message
news:Xn******** *************** *******@127.0.0 .1...

$link = mysql_connect(" 127.0.0.1",""," ")

Make sure that your MySQL is running and does have the user with no-name and
no-password.

[Mr Dygi]

Tim Van Wassenhove <eu**@pi.be> wrote in news:bvrb4s$v7e q1$2@ID-
188825.news.uni-berlin.de:

I'm not sure, but i think MyODB provides a driver to let ODBC talk with
your MySQL server.
Thus my question remains: Have you installed mysql server? and is it
running? :)

Oh noooo... What a stupid. I was reading too fast and misunderstand the
text: "Note that MySQL and ODBC support is now built in, so no dll is
needed for it." from php package. I thought it is included like a module or
sth like that :--|

Ok. I've found it. Is this correct file:

http://www.mysql.com/get/Downloads/M...mysql-3.23.58-
win.zip/from/ftp://sunsite.icm.edu .pl/pub/unix/mysql/

About 13MB ;--[

--
pozdr. Dygi [GG 1027078]
dygimail(at)poc zta(dot)fm

[Mr Dygi]

Tim Van Wassenhove <eu**@pi.be> wrote in news:bvrb4s$v7e q1$2@ID-
188825.news.uni-berlin.de:

I'm not sure, but i think MyODB provides a driver to let ODBC talk with
your MySQL server.

You were right. I didn't have SQL Server installed. I have found 3.21.29a -
for win95 version on the CD form one of the old PC Magazines. I hope it
will not be a very problemous software (version) becasuse of my WinXP ;--)

I am newbie so i don't need very new functions of the sql database. What
you think?

ps
Thanks. You've pointed me in right direction.

--
pozdr. Dygi [GG 1027078]
dygimail(at)poc zta(dot)fm

[Five Cats]

In message <Xn************ *************** ***@127.0.0.1>, Mr Dygi
<dy********@SPA Mpoczta.fm> writes

You were right. I didn't have SQL Server installed. I have found
3.21.29a - for win95 version on the CD form one of the old PC
Magazines. I hope it will not be a very problemous software (version)
becasuse of my WinXP ;--)
This is a very old release - they MySQL site is recommending V4.1 for
new developments. On XP (and 2K & NT) it runs as a service (starts
automatically when the PC boots) which is probably what you want. I am
not using ODBC to connect to it on my PC either - presumably the PHP
functions are picking up information in the configuration file which
includes which TCP port to communicate with the server on.

I am newbie so i don't need very new functions of the sql database.
What you think?

I do think you should use an up-to-date version. You don't have to get
very far with SQL to find you want some of the features in it that are
not in 3.21 such as subqueries. I also wish that Informix had 'CREATE
TABLE x LIKE y'.

Lots more at:

http://www.mysql.com/doc/en/Nutshell_4.1_features.html
--
Five Cats
Email to: cats_spam at uk2 dot net

[Mr Dygi]

Five Cats <ca*******@[127.0.0.1]> wrote in
news:Wt******** ******@[127.0.0.1]:

This is a very old release - they MySQL site is recommending V4.1 for
new developments. On XP (and 2K & NT) it runs as a service (starts
automatically when the PC boots) which is probably what you want.
Yes. I configured it as service. It works in system background.
I am
not using ODBC to connect to it on my PC either - presumably the PHP
functions are picking up information in the configuration file which
includes which TCP port to communicate with the server on.
Hm. I've installed MySQL as service (mysqld) so I think php is not using
this way to connect to MySQL. Right? How can I check it?
I do think you should use an up-to-date version. You don't have to get
very far with SQL to find you want some of the features in it that are
not in 3.21 such as subqueries.
Yes. Yesterday I read some tutorials and I saw this version have not some
basic feautures that later have.
http://www.mysql.com/doc/en/Nutshell_4.1_features.html

Thanks a lot. I've already started to download newer version.

--
pozdr. Dygi [GG 1027078]
dygimail(at)poc zta(dot)fm

[Five Cats]

In message <Xn************ *************** ***@127.0.0.1>, Mr Dygi
<dy********@SPA Mpoczta.fm> writes

Five Cats <ca*******@[127.0.0.1]> wrote in
news:Wt******* *******@[127.0.0.1]:

This is a very old release - they MySQL site is recommending V4.1 for
new developments. On XP (and 2K & NT) it runs as a service (starts
automatically when the PC boots) which is probably what you want.
Yes. I configured it as service. It works in system background.

Have you tested it by connecting & so on from a DOS box?

I am
not using ODBC to connect to it on my PC either - presumably the PHP
functions are picking up information in the configuration file which
includes which TCP port to communicate with the server on.
Hm. I've installed MySQL as service (mysqld) so I think php is not using
this way to connect to MySQL. Right? How can I check it?

It is connecting to the service through a TCP port, as specified in the
my.ini file. Of course it might depend on what PHP commands you are
using - I'm assuming you are using the specific MySQL ones (see
http://www.php.net/manual/en/ref.mysql.php). The entry for
mysql_connect makes it quite explicit it's connection via a TCP port
(the default is localhost:3306 but best see the manual page,
http://www.php.net/manual/en/functio...l-connect.php), but if you are
using the ODBC functions then you would need an appropriate ODBC driver
installed. There is a big assumption on my part here, which is that you
*can* use ODBC to access a MySQL database - it's not mentioned in the
manual (http://www.php.net/manual/en/ref.odbc.php) but I know there is a
driver and I've managed to use it to get data into Excel before now.
This could well be an assumption too far.

I do think you should use an up-to-date version. You don't have to get
very far with SQL to find you want some of the features in it that are
not in 3.21 such as subqueries.
Yes. Yesterday I read some tutorials and I saw this version have not some
basic feautures that later have.

;-)

http://www.mysql.com/doc/en/Nutshell_4.1_features.html

Thanks a lot. I've already started to download newer version.

The manuals (MySQL & PHP) might be a useful download as well if you
don't already have them!

--
Five Cats
Email to: cats_spam at uk2 dot net