URN Logo
UNIX Resources » Linux » Linux Forum » Gentoo Help » Page.10 » MySQL server only starting on localhost
announcement The content of this page is collected from Linux Forum, All copyrights and other associated rights are reserved by the original authors of the articles.
Resources
China Linux Forum(finished)
Linux Forum(finished)
FreeBSD China(finished)
linuxforum.com
  LinuxForum General Chat
  Linux Advocacy
  LinuxForum Polls
  Introductions
  Linux Kernel Support
  Patch Management
  Development Release
  Linux Programming
  Linux Security
  Linux Software
  Linux Hardware Problems
    Linux Video Problems
    Linux Sound Problems
  Linux Networking Support
  Linux Printing Support
  Linux Human Interface Devices Support
  Linux Data Storage Support
  Linux Applications Support
  Linux Installation Support
  Linux Laptops Support
  Linux Motherboard, Chipsets, CPU, Memory
  Miscellaneous
  Debian Linux Support
  Ubuntu Linux Support
  LiveCD Discussions
  Gentoo Linux Support
  Mandrake Linux Support
  Redhat / Fedora Linux Support
  Slackware Linux Support
  SuSE Linux Support
  CentOS Linux Support
  Linux Web Servers
  Linux DNS Servers
  Linux Database Servers
  Linux Email Servers
  Linux FTP Servers
  Linux Squid Proxy Server
  Linux Samba Help
  Linux cPanel Help
  Linux Ensim Help
  Linux Plesk Help
  Linux Webmin / Usermin Help
  Qmail Toaster Help
  Linux Games
  Windows Game Emulation
  Linux Discussions
  General Linux Discussions
  Red Hat Linux Discussions
  More Red Hat Linux Discussions
  Mandrake Linux Discussions
  Slackware Linux Discussions
  SuSE Linux Discussions
  Debian Discussions
  Samba Help
  Linux Security
  Linux Networking
  Gentoo Help
  Operating System Rant Forum
  Hardware Rants
   
MySQL server only starting on localhost
Subject: MySQL server only starting on localhost
Author: Mamisoa    Posted: 2005-06-28 16:17:59    Length: 2,728 byte(s)
[Original] [Print] [Top]
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 © 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

[Original] [Print] [Top]
Subject: MySQL server only starting on localhost
Author: Ben Peddell    Posted: 2005-06-28 21:26:51    Length: 962 byte(s)
[Original] [Print] [Top]
On Wed, 29 Jun 2005 00:17:59 +0200, Mamisoa wrote:

QUOTE
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

[Original] [Print] [Top]
Subject: MySQL server only starting on localhost
Author: feaster    Posted: 2005-06-29 11:47:50    Length: 3,305 byte(s)
[Original] [Print] [Top]
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:
QUOTE
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 © 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



[Original] [Print] [Top]
Subject: MySQL server only starting on localhost
Author: feaster    Posted: 2005-06-29 11:50:31    Length: 3,819 byte(s)
[Original] [Print] [Top]
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:
QUOTE

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


[Original] [Print] [Top]
Subject: MySQL server only starting on localhost
Author: Mamisoa    Posted: 2005-06-29 14:11:09    Length: 1,307 byte(s)
[Original] [Print] [Top]
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...
QUOTE
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


[Original] [Print] [Top]
Subject: MySQL server only starting on localhost
Author: Mamisoa    Posted: 2005-06-30 09:19:48    Length: 1,617 byte(s)
[Original] [Print] [Top]
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...
QUOTE
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




[Original] [Print] [Top]
« Previous thread
Gnome question
Gentoo Help
Page. 10
Next thread »
slip and slattach
     

Copyright © 2007 UNIX Resources Network, All Rights Reserved.      About URN | Privacy & Legal | Help | Contact us
Powered by FreeBSD    webmaster: webmaster@unixresources.net
This page created on 2007-08-01 13:18:19, cost 0.043666839599609 ms.