"Leonard Miller" <[EMAIL PROTECTED]> writes: > mysql version 3.23.41 On Redhat 7.2 > I was trying to get this setup so I could limit access to future > databases, > and I think I locked my root account out. > I tried restarting with "/etc/rc.d/init.d/mysqld start > --skip-grant-tables", but I don't think it worked. > IT still gives me access denied errors. > ERROR 1044: Access denied for user: '@localhost' to database 'mysql' It looks like you are specifying the wrong parameters when connecting to the database. Could you post the command line you use to access MySQL? It should look something like 'mysql -u root -h localhost', you do not have to specify password when running without grant-tables. -- - h
åkon --------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
