Hey Paul,
>error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
That's a good sign, actually.
Finally a good sign.
I means that mysqladmin was able to find the server and attempt to connect to it. That's good. The server rejected the connection attempt, so that's not so good. :-)
Crap! spoke to soon! :-)
I would next ask you to try specifying your password:
mysqladmin -u root -p -h 127.0.0.1 variables
except that you may not know it, correct?
Nope, anyway to override...delete it, burn it, damn it to hell or just jump on the SOB?
Depends.
You mentioned earlier that your "MySQL start" command is:
/usr/sbin/mysqld start
Does
/usr/sbin/mysqld stop
stop the current server?
If it does not, I suggest that you force the server down with kill -9 PID (where PID is the process ID of the server).
Once the server is down, use the following procedure to restart it and reset the root password:
http://www.mysql.com/doc/en/Resetting_permissions.html
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]