Did you remove the my.cnf file and then run /etc/init.d/mysql stop? The my.cnf probably had non-default paths for the pid file, so if you remove the config file, now the startup script is looking in the wrong location.
Also for your password issue, please show use the exact command you're using to try to log in, and the exact error message you get.
From: Sydney Puente [mailto:firstname.lastname@example.org]
Sent: Friday, November 13, 2009 5:31 AM
Subject: Re: cannot find my.cnf file
Yes I enter the password manually into the remote mysql client (actually Oracle's SQL developer) when I login.
I thought I would restart mysql with the /etc/init.d/mysql script and go back to the original "default" settings without any my.cnf present. Just to check it was some setting in my.cnf that caused the log in problem.
# ./mysql status
MySQL is running but PID file could not be found [FAILED]
# ./mysql stop
MySQL manager or server PID file could not be found! [FAILED]
In fact I cannot find a pid file anywhere on the box.
# ps -ef | grep mysql
root 6517 1 0 10:10 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/radium01.pid
mysql 6623 6517 0 10:10 pts/0 00:00:24 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid --socket=/var/lib/mysql/mysql.sock --port=3306
# locate pid | grep mysql
I have no idea why a pid file would be missing!
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gtowey@stripped
The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.