you can always reset the mysql root passwd http://www.mysql.com/doc/en/Resetting_permissions.html
Saqib Ali --------- http://validate.sf.net <--- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, Carol Andrejak wrote: > Hello Listers, > > I have a problem in that I cannot find my user id and password to log into mysql as > administrator. I can never remember passwords so I write them all down in a small > book however when I reinstalled mysql early last month, evidently I neglected to > write down the new user id and password in my book. I haven't touched telnet since > then. > > So now I can't log in to create a new user or do anything else. <sigh> > > Is it possible to sit down in front of the server logged in as root and find the > file that has this information and have a look at it? Maybe if I can see the user > names it'll jog my memory as to the password. I can try a couple to see if any work. > > If this is not possible, what recourse do I have? I don't want to mess with the > database and start over and I seriously don't want to have to do anything to mysql > as it took me two weeks to get it to work with the DBI perl module. Now that it's > working, I'm terrified to touch it in case it breaks. Thanks for any guidance. I > promise this time to not forget to write it down. > > > > Carol Andrejak > Webmaster > Delaware State University > Grossley Hall Rm. 1 > 302-857-7045 > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]