|Printable Version of Topic
Click here to view this topic in its original format
|Dingetje's Forum > Tips & Tricks > reset mySQL root password|
|Posted by: dingetje Oct 21 2003, 03:42 PM|
| if you get an error like:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
when you try to gain access to mySQL database (either via mysql or mysqladmin) and you cannot remember what your mySQL password was for user 'root' then follow this procedure to set the password to a known value:
for FREESCO 03x /path/to = /usr/local/mySQL/bin
for FREESCO 027 /path/to = /mnt/router/packages/mySQL/bin
your_new_password can also be empty:
based on http://www.mysql.com/doc/en/Resetting_permissions.html
|Posted by: phbc50 Sep 18 2005, 05:51 AM|
For mysql-4.1.7a-lightning, the safe_mysqld is replaced by mysqld_safe
in the howto above.
with this package : /path/to = /usr/local/mysql/bin (all lower case).