mysql password

[wilsonpaul]

What directory and file is the mysql root user password found in?

[[Dan]]

it's encrypted in the "mysql" database, in the "user" table. If you lost it, your best bet is to kill it manually and restart it with the option --skip-grant-tables<br /><br />this will allow you to log in mysql as root with a blank password. Set a new one, shutdown it again and restart it without the above option.<br /><br />Good luck <img border="0" title="" alt="[Smile]" src="smile.gif" />

[druhix]

don't forget to use the password function<br /><br />UPDATE table user set Password=password('yourpass') where User='root';<br /><br /> <img border="0" alt="[Hi]" title="" src="graemlins/hi.gif" />