469,106 Members | 2,304 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

MySQL on Linux

(I apologize for my "ugly" english... :-)

I'm a beginner with Linux (Mandrake 9.1) and try to run my own local web
server. Apache 1.3.27 et PHP 4.3.3 are OK. The problem is MySQL...

I tried with the 3.23.56 version and the 4.0.1. Always, I recompiled.

I have installed also phpMyAdmin (once agin, in 2 versions) in order to
understand what happened. It is able to connect to the database but not to
read the data. I tried to "see" my datas with phpMyAdmin ("Browse") but my
browser gives me this message in agialog box: "Connection to host localhost
is broken".

In fact, in the bottom of the phpMyAdmin interface, it is said:

The additional Features for working with linked Tables have been
deactivated. To find out why click here.

When I "click here" I read:

PMA Database ... not OK[ Documentation ]
General relation features Disabled

My PHP scripts (there are ok on a running server) doesn't work correctly.
They can connect to the DB but are note able to read the data, the same
problem. I have a message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in /home/** on line **

What's the problem? Could you help me please? If you need for more
informations, please ask, I have some things to say but I want to be sure
that it is worthy beacause it's not so easy to write in english for me...
(as you can see!)

Do you think is a permission promble on linux? A configuration error on
MySQL? Thanks in advance for your help!
Jul 19 '05 #1
6 3503

"barsepsi" <ba******@htomail.com> wrote in message
news:3f********@news.bluewin.ch...
(I apologize for my "ugly" english... :-)

I'm a beginner with Linux (Mandrake 9.1) and try to run my own local web
server. Apache 1.3.27 et PHP 4.3.3 are OK. The problem is MySQL...

I tried with the 3.23.56 version and the 4.0.1. Always, I recompiled.


<Snip>

Are you compiling everything from source or is Apache and php Mandrake RPMs?
Jul 19 '05 #2

"barsepsi" <ba******@htomail.com> wrote in message
news:3f********@news.bluewin.ch...
(I apologize for my "ugly" english... :-)

I'm a beginner with Linux (Mandrake 9.1) and try to run my own local web
server. Apache 1.3.27 et PHP 4.3.3 are OK. The problem is MySQL...

I tried with the 3.23.56 version and the 4.0.1. Always, I recompiled.


<Snip>

Are you compiling everything from source or is Apache and php Mandrake RPMs?
Jul 19 '05 #3
"sdfgsd" <sd**@sdg.com> wrote in message news:<ja**********************@twister.tampabay.rr .com>...
"barsepsi" <ba******@htomail.com> wrote in message
news:3f********@news.bluewin.ch...
(I apologize for my "ugly" english... :-)

I'm a beginner with Linux (Mandrake 9.1) and try to run my own local web
server. Apache 1.3.27 et PHP 4.3.3 are OK. The problem is MySQL...

I tried with the 3.23.56 version and the 4.0.1. Always, I recompiled.


<Snip>

Are you compiling everything from source or is Apache and php Mandrake RPMs?


If you already have a 'mysql" user on the linux box, su - mysql and
[mysql@host_name mysql_home]/path_to_mysql/safe_mysqld. That works and
you don't need to start mysqld with --user option

regards
akr
Jul 19 '05 #4
"sdfgsd" <sd**@sdg.com> wrote in message news:<ja**********************@twister.tampabay.rr .com>...
"barsepsi" <ba******@htomail.com> wrote in message
news:3f********@news.bluewin.ch...
(I apologize for my "ugly" english... :-)

I'm a beginner with Linux (Mandrake 9.1) and try to run my own local web
server. Apache 1.3.27 et PHP 4.3.3 are OK. The problem is MySQL...

I tried with the 3.23.56 version and the 4.0.1. Always, I recompiled.


<Snip>

Are you compiling everything from source or is Apache and php Mandrake RPMs?


If you already have a 'mysql" user on the linux box, su - mysql and
[mysql@host_name mysql_home]/path_to_mysql/safe_mysqld. That works and
you don't need to start mysqld with --user option

regards
akr
Jul 19 '05 #5
If you already have a 'mysql" user on the linux box, su - mysql and
[mysql@host_name mysql_home]/path_to_mysql/safe_mysqld. That works and
you don't need to start mysqld with --user option


can I jump in here?

I've got RH 9.0
I've got mysql loading at boot
but
when I try the command

../bin/mysqladmin create testDB

I get

[craig@localhost mysql]$ ./bin/mysqladmin version
../bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

can you make some sense out of this.

what is this mysql.sock

thank you
craig

Jul 19 '05 #6
If you already have a 'mysql" user on the linux box, su - mysql and
[mysql@host_name mysql_home]/path_to_mysql/safe_mysqld. That works and
you don't need to start mysqld with --user option


can I jump in here?

I've got RH 9.0
I've got mysql loading at boot
but
when I try the command

../bin/mysqladmin create testDB

I get

[craig@localhost mysql]$ ./bin/mysqladmin version
../bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

can you make some sense out of this.

what is this mysql.sock

thank you
craig

Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Randell D. | last post: by
reply views Thread by Chris Moy | last post: by
reply views Thread by google account | last post: by
67 posts views Thread by Bob Powell | last post: by
2 posts views Thread by pc | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.