Old 28th April 2010, 19: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
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.
socket = /var/run/mysqld/mysqld.sock
nice = 0

# * 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
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address =
# * 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
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"

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

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

Reply With Quote
Sponsored Links
Old 28th April 2010, 20:07
axtoxic107 axtoxic107 is offline
Junior Member
Join Date: Apr 2010
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts

IN my PHp app, i am writing query of creating table but it shows me this error..
"Can't create table "

Do i need to give permission to mysql process? if yes then How to do that?
Reply With Quote
Old 30th April 2010, 14:41
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts

Does the MySQL user that you use in your PHP app have the permissions to create the table?
Maybe you can post your PHP code (if it's not too long).
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Email problem 'Cannot set my user or group id.' (using ISPConfig 3 + OpenSuSE 11.2) urosm Installation/Configuration 5 19th June 2010 23:41
Unable to connect to mysql server Can't connect to local MySQL server through socket c7p Installation/Configuration 11 21st July 2009 11:27
Can't start apache Musty Server Operation 12 9th March 2008 14:58
The Perfect Setup - Debian Etch (Debian 4.0) some trouble daniel80 HOWTO-Related Questions 26 1st February 2008 17:30
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 03:30

All times are GMT +2. The time now is 20:56.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.