HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Mysql server problem (http://www.howtoforge.com/forums/showthread.php?t=45470)

axtoxic107 28th April 2010 19:51

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

axtoxic107 28th April 2010 20:07

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?

falko 30th April 2010 14:41

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


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

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