Thursday, April 22, 2004, 9:21:35 PM, Dave Dennis wrote: DD> Is there a procedure to follow for this exactly, step by step?
Yes. DD> Its on a running production server, don't want to lose data. Note: If you run MySQL server with --skip-grant-tables option, MySQL will not use privilege tables. So everyone will have full access to the databases. When you execute FLUSH PRIVILEGES MySQL server will use privilege tables again. DD> On Thu, 22 Apr 2004, Egor Egorov wrote: >> Dave Dennis <[EMAIL PROTECTED]> wrote: >> > Dear MySQL list, >> > >> > Managed to create a problem where: >> > >> > mysql > use mysql; >> > >> > ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' >> > >> > Need a procedure to follow / documented steps to restore root's access >> > to database mysql, version 4.0.17 . >> > >> >> Start MySQL server with --skip-grant-tables option, then connect to the MySQL >> server and change privileges for 'root' user. Don't forget FLUSH PRIVILEGES. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]