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 /usr/share/man/man1/mysql_waitpid.1.gz /usr/bin/mysql_waitpid I have no idea why a pid file would be missing! any ideas Syd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
