Using the commands you have offered...
Egor> Your 'root' user doesn't have GRANT privilege ... Egor> Egor> You should change Grant_priv to 'Y' Egor> You can do this using UPDATE statement: Egor> UPDATE user SET Grant_priv='Y' WHERE user='root'; I get this response...... ERROR 1017: Can't find file: 'user.frm' (errno: 2) ----------------------------------------------- Endeavouring to run mysqld as per....... Egor> or you run mysqld with "--skip-grant-tables" option and set Grant_priv Egor> using GRANT statement: Egor> GRANT ALL ON *.* to 'root'@'localhost' identified by Egor> 'password_obscured' WITH GRANT OPTION; myslqd tells me it's it is ready for input..... But I'm not sure what to input? Ian --------------------------------------------------------------------- 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
