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
>>