[plug] mysql installation

[Mark O'Shea]

On Sun, 2004-07-11 at 10:08, William Kenworthy wrote:
> Try "mysql -u root at localhost -p mysql" and just press enter when it asks
> for the password.
> 
> Also, mysql logins usually use the originators machine name as part of
> the login name: you are trying to login from the localhost, as
> root at localhost?
> 
> BillK
> 
> On Sat, 2004-07-10 at 20:53, Dave Dartnall wrote:
> > On Sat, 10 Jul 2004 01:31 pm, Jim Householder wrote:
> > > Dave Dartnall wrote:
> > Thanks Jim and William Kenworthy...
> > I've removed and reinstalled twice, and get the feeling that the MDK has done 
> > their installation with a root password. I have indeed rtfm with little 
> > success - any effort to execute mysql -u root mysql or similar have all 
> > resulted in denial of access, contrary to what's described in the docs. I'm 
> > stumped. - but still trying. Very.
> > It's not easy reading those docs - there are over 700 pages of 'em.
> > Dave D
> > _______________________________________________

Also note that you can stop the root (mysql) password getting in your
way by stopping mysql and using this line to start it again:
safe_mysqld --skip-grant-tables

Then just use this to log in:
mysql -u root
and it will take you in.  When you are in you can use the usual:
flush privileges;
to get the password restriction back.

Regards,
-- 
Mark O'Shea