MySQL php error
Edward Iglesias
iglesias at loyno.edu
Fri Nov 12 20:56:26 UTC 2004
Somewhat along the same lines, I keep getting a mysql_connect error when
trying to install postnuke. The Postnuke website suggests that it is a
php configuration error. I tried changingmysql.default_host to
127.0.0.1 in php.ini.
Any suggestions?
Edward
J G wrote:
>Hi Pete
>
>I looked at the ps -ef output and saw that mysqld had already started.
>
>SO <slapping forehead>, like i mentioned below, i just killed the existing processes, and the restarted the safe_mysqld command and BOOM, it worked.!!!!
>
>able to go to ./mysqladmin and create dbases now..:)
>
>thanks for your help...
>
>Pete Nesbitt <pete at linux1.ca> wrote:
>Please see the botom post.
>
>
>On November 9, 2004 02:35 pm, J G wrote:
>
>
>>Hi Pete
>>
>>here are my findings per your suggestion:
>>
>>-when you changed "permissions' on /var/lib/mysql to be owned by
>>mysql, did
>>you also ensure the dir is writeable by mysql? Isn't the group 'mysql'
>>as not
>>'daemon'?
>>reply: I just changed it to 777 to be sure, and started ./bin/mysqld_safe
>>& and still got the error.
>>
>>-is there anything in /var/log/mysqld.log or /var/log/messages ?
>>reply: mysqld.log does not exist and there is nothing in dmesg. (weird)
>>
>>-make sure /var/log/mysqld.log is writeable by the mysql user
>>(probably
>>mysql)
>>reply: there is no such log either...:)
>>
>>-that seems like strange place for a pid file, they usually go in
>>/var/run
>>reply: there is no pid file located in var/run/
>>
>>there is however, a "server.err" file that is generated under
>>/var/lib/mysql. it states that port 3306 is already in use and mysql cannot
>>be started. so maybe I will start with that one and go from there..
>>
>>thanks
>>
>>
>>
>>Pete Nesbitt
>>
>>
>wrote:
>
>
>>On November 8, 2004 04:50 pm, J G wrote:
>>
>>
>>>Hi all,
>>>
>>>just installed Mysql binaries.
>>>
>>>When i try to start Mysql using the mysql_safe
>>>command, i get the message:
>>>
>>>[root at palrhsrv /]# /usr/bin/mysqld_safe &
>>>[1] 18547
>>>[root at palrhsrv /]# Starting mysqld daemon with
>>>databases from /var/lib/mysql
>>>STOPPING server from pid file
>>>/var/lib/mysql/palrhsrv.pid
>>>041108 16:44:48 mysqld ended
>>>
>>>
>>>[1]+ Done /usr/bin/mysqld_safe
>>>
>>>************************************
>>>
>>>then, when I start the command:
>>>
>>>[root at palrhsrv bin]# ./mysqladmin create testDB
>>>./mysqladmin: connect to server at 'localhost' failed
>>>error: 'Can't connect to local MySQL server through
>>>socket '/var/lib/mysql/mysql.sock' (2)'
>>>Check that mysqld is running and that the socket:
>>>'/var/lib/mysql/mysql.sock' exists!
>>>
>>>
>>>I looked under the var/lib/mysql and obviously the
>>>mysql.sock does not exist.
>>>
>>>I changed permissions under /var/lib/mysql to chown -R
>>>mysql and chrgp to daemon.
>>>Still getting the same errors.
>>>
>>>any help?
>>>
>>>thanks
>>>
>>>
>
>
>
>HI,
>what does your /etc/my.cnf file show. If you don't have that, look in
>/usr/local/etc
>
>Just curious, why didn't you just install the rpm?
>
>What version of rh & mysql?
>
>Did you follow all the steps for the binary install? (they show about a dozen
>steps for a generic unix-like install)
>
>
--
Edward Iglesias
Integrated Library Systems Coordinator
504.864.7838 (work)
504.864.7842 (FAX)
More information about the redhat-list
mailing list