I have already changed the PW for root and I can log in no problem with mysql -p root, but I can also get in with just mysql. Someone mentioned about anonymous access, I'll have to check on that. 4.0 and above give me an error that permission is denied for [EMAIL PROTECTED] I am not using an external database so not sure why this is.
Thanks to all that posted legitimate answers. SGreen can biteme however. -----Original Message----- From: Cal Evans [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:08 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL Hi, If you've just installed it then the root user has no password. Change the root user to have a password then you will have to specify the -p parameter on the command line before you can log in. (Or you can put it in your local my.cnf file) =C= www.calevans.com Beauford wrote: > I just installed MySQL 3.23 (the only one I could get to work) and I > find that I can log into the server just by typing mysql at the DOS > prompt. Ho do make it so you have to use a user name and password to get in. > > Thanks > > Running on Win2k Advance Server. > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]