At 21:54 +0100 3/17/04, Ryan A wrote:
>Hey Paul,
>
>> >error: 'Access denied for user: 'root@bestwebhosters'
>> (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/
