#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
  #2  
Old 28th April 2010, 19:07
axtoxic107 axtoxic107 is offline
Junior Member
 
Join Date: Apr 2010
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
  #3  
Old 30th April 2010, 13:41
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

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).
__________________
Falko
--
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
Reply

Bookmarks

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 22:41
Unable to connect to mysql server Can't connect to local MySQL server through socket c7p Installation/Configuration 11 21st July 2009 10:27
Can't start apache Musty Server Operation 12 9th March 2008 13:58
The Perfect Setup - Debian Etch (Debian 4.0) some trouble daniel80 HOWTO-Related Questions 26 1st February 2008 16:30
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 02:30


All times are GMT +2. The time now is 19:59.


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