How do I delete the root password from MySQL?

I dont want to change it, because I know what the password is. I want
it delete it so I can run mysql -u root and get in as root without the
need for a password.

This is so I can install DBD::Mysql which expects no password to be
set for root.

Suk wrote:
> How do I delete the root password from MySQL?
> 
> I dont want to change it, because I know what the password is. I want
> it delete it so I can run mysql -u root and get in as root without the
> need for a password.
> 
> This is so I can install DBD::Mysql which expects no password to be
> set for root.
> 

> How do I delete the root password from MySQL?
> 
> I dont want to change it, because I know what the password is. I want
> it delete it so I can run mysql -u root and get in as root without the
> need for a password.
> 
> This is so I can install DBD::Mysql which expects no password to be
> set for root.


That's not true, you specify the password like any other user.

http://search.cpan.org/~capttofu/DBD-mysql-4.005/lib/DBD/mysql.pm


-- 
Brian Wakem

Suk <sukesh@zoom.co.uk> wrote in news:1182181238.423498.306620
@q75g2000hsh.googlegroups.com:

> How do I delete the root password from MySQL?
> 
> I dont want to change it, because I know what the password is. I want
> it delete it so I can run mysql -u root and get in as root without the
> need for a password.

uh, keep in mind that anyone with shell access will be able to do the same 
thing....