Hi All, i'm currently setting up my first mySQL database, and have made the mistake of updating the root user's password without using the Password() function, meaning i am unable to get at the mysql database, or the new one i had just created. As has been suggested on this list, i have tried using the command below: safe_mysqld --skip-grant-tables However i receive a "Permission denied : cannot unlink `/var/lib/mysql/mysql.sock' error, and nothing happens. This could be due to my inability to shut down the mysql server, as to do that (Using mysqladmin) requires the root login. Is there any other way to restore the database, or should i try and re-install? (No data will be lost) Also, if a reinstall is the only way, does anyone have any experience of doing this remotely, on a Cobalt Raq4 server? Thanks very much in advance, Mark Edward --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
