View Single Post
  #1  
Old 28th April 2010, 18:51
axtoxic107 axtoxic107 is offline
Junior Member
 
Join Date: Apr 2010
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Mysql server problem

Hello Friends,

I cannot connect to the mysql from my php applications , i have install mysql-php5 also...Below are the few result..Please help me here.

my.cnf file
Quote:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 184.82.19.178
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
Here are the result of nmap -A
Quote:
21/tcp open ftp ProFTPD 1.3.1
22/tcp open ssh (protocol 2.0)
53/tcp open domain
80/tcp open http?
3306/tcp open mysql? (sometimes here it also shows "Host blocked because of too many connections"- i have increase max_Connect_error = 1000)
Result of "mysqladmin -uroot -ppassword processlist"
Quote:

+-----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+----+---------+------+-------+------------------+
| 104 | root | localhost | | Query | 0 | | show processlist |
the result of telnet localhost 3306

Quote:
Trying 184.82.19.178...
Connected to imagezza.com.
Escape character is '^]'.
?
5.0.51a-24+lenny3i)Q<u^Vtf,"s@$1g8}0svwConnection closed by foreign host.
Here after 5 seconds or so "Connection closed by foreign host." message added..

Another result for u..
Quote:
mysqladmin -uroot -ppassword version
mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on i486
Copyright (C) 2000-2006 MySQL 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 5.0.51a-24+lenny3
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 29 min 32 sec

Threads: 1 Questions: 140 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 27 Queries per second avg: 0.079
What may be the problem here?

Thanks
Reply With Quote
Sponsored Links