SEO

Hi,

I'm on Gentoo and emerged Apache2+MySQL4.0.24+php4.3.11.

I can't make sqld starting on port 3306 although I can access it on
localhost.
I commented the line: bind-address=127.0.0.1 and that permitted to get an
answer on port 3306.

When I telnet from another computer on port 3306, I get :
<----------------------------------
'
4.0.24&4?"(APOy,?

???Bad handshake
---------------------------------->

When I ask mysqladmin version, I get:

<----------------------------------

mysqladmin Ver 8.40 Distrib 4.0.24, for unknown-linux-gnu on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.0.24
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 33 min 15 sec

Threads: 1 Questions: 225 Slow queries: 0 Opens: 13 Flush tables: 1
Open tables: 7 Queries per second avg: 0.113

---------------------------------->

Here is my my.cnf file:

<----------------------------------

[client]
#password = my_password
port = 3306
socket = /var/run/mysqld/mysqld.sock

[safe_mysqld]
err-log = /var/log/mysql/mysql.err

[mysqld]
skip-innodb
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
# keep secure by default!
#bind-address = 127.0.0.1
port = 3306
# this can make it even more secure:
#skip-networking

[mysqldump]
quick
set-variable = max_allowed_packet=1M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
set-variable = key_buffer=16M

---------------------------------->

If you have any idea ...

Tnx,

Mike

On Wed, 29 Jun 2005 00:17:59 +0200, Mamisoa wrote:

> When I telnet from another computer on port 3306, I get :
> <----------------------------------
> '
> 4.0.24&4?"(APOy,?

Try using `mysql -p' on another computer that has the MySQL client
installed.

$ telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
'
4.0.24 x)a/b"!|,Connection closed by foreign host.
$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 4.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye

Maybe the problem is at the user account.

Default do mysqld an user 'root@localhost' that means that only a user
with username root (=an other user that the root user of Unix/Linux)

Create an other user wich had also access from not localhost (outside).
How to do?? See mysql manual!

Feaster



Mamisoa wrote:
> Hi,
>
> I'm on Gentoo and emerged Apache2+MySQL4.0.24+php4.3.11.
>
> I can't make sqld starting on port 3306 although I can access it on
> localhost.
> I commented the line: bind-address=127.0.0.1 and that permitted to get an
> answer on port 3306.
>
> When I telnet from another computer on port 3306, I get :
> <----------------------------------
> '
> 4.0.24&4?"(APOy,?
>
> ???Bad handshake
> ---------------------------------->
>
> When I ask mysqladmin version, I get:
>
> <----------------------------------
>
> mysqladmin Ver 8.40 Distrib 4.0.24, for unknown-linux-gnu on powerpc
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version 4.0.24
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /var/run/mysqld/mysqld.sock
> Uptime: 33 min 15 sec
>
> Threads: 1 Questions: 225 Slow queries: 0 Opens: 13 Flush tables: 1
> Open tables: 7 Queries per second avg: 0.113
>
> ---------------------------------->
>
> Here is my my.cnf file:
>
> <----------------------------------
>
> [client]
> #password = my_password
> port = 3306
> socket = /var/run/mysqld/mysqld.sock
>
> [safe_mysqld]
> err-log = /var/log/mysql/mysql.err
>
> [mysqld]
> skip-innodb
> user = mysql
> pid-file = /var/run/mysqld/mysqld.pid
> socket = /var/run/mysqld/mysqld.sock
> log-error = /var/log/mysql/mysqld.err
> basedir = /usr
> datadir = /var/lib/mysql
> tmpdir = /tmp
> language = /usr/share/mysql/english
> skip-locking
> set-variable = key_buffer=16M
> set-variable = max_allowed_packet=1M
> set-variable = thread_stack=128K
> # keep secure by default!
> #bind-address = 127.0.0.1
> port = 3306
> # this can make it even more secure:
> #skip-networking
>
> [mysqldump]
> quick
> set-variable = max_allowed_packet=1M
>
> [mysql]
> #no-auto-rehash # faster start of mysql but no tab completition
>
> [isamchk]
> set-variable = key_buffer=16M
>
> ---------------------------------->
>
> If you have any idea ...
>
> Tnx,
>
> Mike
>
>

Oops, missing some text in previous post :$

Maybe the problem is at the user account.

Default do mysqld an user 'root@localhost' that means that only a user
with username root (=an other user that the root user of Unix/Linux) can
access the datase ONLY from localhost (@localhost says that). You should
create an user account like 'a_user' without '@localhost'.


How to do?? See mysql manual!

Feaster


feaster wrote:
>
> Maybe the problem is at the user account.
>
> Default do mysqld an user 'root@localhost' that means that only a user
> with username root (=an other user that the root user of Unix/Linux)
>
> Create an other user wich had also access from not localhost (outside).
> How to do?? See mysql manual!
>
> Feaster
>
>
>
> Mamisoa wrote:
>
>> Hi,
>>
>> I'm on Gentoo and emerged Apache2+MySQL4.0.24+php4.3.11.
>>
>> I can't make sqld starting on port 3306 although I can access it on
>> localhost.
>> I commented the line: bind-address=127.0.0.1 and that permitted to get
>> an answer on port 3306.
>>
>> When I telnet from another computer on port 3306, I get :
>> <----------------------------------
>> '
>> 4.0.24&4?"(APOy,?
>>
>> ???Bad handshake
>> ---------------------------------->
>>
>> When I ask mysqladmin version, I get:
>>
>> <----------------------------------
>>
>> mysqladmin Ver 8.40 Distrib 4.0.24, for unknown-linux-gnu on powerpc
>> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
>> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>> and you are welcome to modify and redistribute it under the GPL license
>>
>> Server version 4.0.24
>> Protocol version 10
>> Connection Localhost via UNIX socket
>> UNIX socket /var/run/mysqld/mysqld.sock
>> Uptime: 33 min 15 sec
>>
>> Threads: 1 Questions: 225 Slow queries: 0 Opens: 13 Flush tables:
>> 1 Open tables: 7 Queries per second avg: 0.113
>>
>> ---------------------------------->
>>
>> Here is my my.cnf file:
>>
>> <----------------------------------
>>
>> [client]
>> #password = my_password
>> port = 3306
>> socket = /var/run/mysqld/mysqld.sock
>>
>> [safe_mysqld]
>> err-log = /var/log/mysql/mysql.err
>>
>> [mysqld]
>> skip-innodb
>> user = mysql
>> pid-file = /var/run/mysqld/mysqld.pid
>> socket = /var/run/mysqld/mysqld.sock
>> log-error = /var/log/mysql/mysqld.err
>> basedir = /usr
>> datadir = /var/lib/mysql
>> tmpdir = /tmp
>> language = /usr/share/mysql/english
>> skip-locking
>> set-variable = key_buffer=16M
>> set-variable = max_allowed_packet=1M
>> set-variable = thread_stack=128K
>> # keep secure by default!
>> #bind-address = 127.0.0.1
>> port = 3306
>> # this can make it even more secure:
>> #skip-networking
>>
>> [mysqldump]
>> quick
>> set-variable = max_allowed_packet=1M
>>
>> [mysql]
>> #no-auto-rehash # faster start of mysql but no tab completition
>>
>> [isamchk]
>> set-variable = key_buffer=16M
>>
>> ---------------------------------->
>>
>> If you have any idea ...
>>
>> Tnx,
>>
>> Mike
>>

Hi, thanks, it is actually working using mysql client on another station.

The trouble is I cannot get dreamweaver to connect the mysql server...

++

"Ben Peddell" <klightspeed@klightspeed.is-a-geek.net> a écrit dans le
message de news: pan.2005.06.29.03.26.50.63550@klightspeed.is-a-geek.net...
> On Wed, 29 Jun 2005 00:17:59 +0200, Mamisoa wrote:
>
>> When I telnet from another computer on port 3306, I get :
>> <----------------------------------
>> '
>> 4.0.24&4?"(APOy,?
>
> Try using `mysql -p' on another computer that has the MySQL client
> installed.
>
> $ telnet localhost 3306
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> '
> 4.0.24 x)a/b"!|,Connection closed by foreign host.
> $ mysql -uroot -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 10 to server version: 4.0.24
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> quit
> Bye
>

ok finally got it working with dreamweaver...

The user who connects via ftp had no privileged to upload anything. chown
got it working.

thnx!

"Mamisoa" <none@hotmail.com> a écrit dans le message de news:
V-ednSKdevr-nV7fRVnyjw@scarlet.biz...
> Hi, thanks, it is actually working using mysql client on another station.
>
> The trouble is I cannot get dreamweaver to connect the mysql server...
>
> ++
>
> "Ben Peddell" <klightspeed@klightspeed.is-a-geek.net> a écrit dans le
> message de news:
> pan.2005.06.29.03.26.50.63550@klightspeed.is-a-geek.net...
>> On Wed, 29 Jun 2005 00:17:59 +0200, Mamisoa wrote:
>>
>>> When I telnet from another computer on port 3306, I get :
>>> <----------------------------------
>>> '
>>> 4.0.24&4?"(APOy,?
>>
>> Try using `mysql -p' on another computer that has the MySQL client
>> installed.
>>
>> $ telnet localhost 3306
>> Trying 127.0.0.1...
>> Connected to localhost.
>> Escape character is '^]'.
>> '
>> 4.0.24 x)a/b"!|,Connection closed by foreign host.
>> $ mysql -uroot -p
>> Enter password:
>> Welcome to the MySQL monitor. Commands end with ; or \g.
>> Your MySQL connection id is 10 to server version: 4.0.24
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> quit
>> Bye
>>
>
>