MySql Table (Users) Problem

  You are currently not logged in. You can view the forums, but cannot post messages. Log In | Register

18-Sep-11 12:05
I changed a field or two in the "user" table. I now can not log into my CMS. When I try to log in I receive this message "invalid credentials". Can anyone help with this?
22-Sep-11 01:36
@linc: If you mean the MySQL "user" table, try running mysqld with the --skip-grant-tables option:

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-grant-tables

You can then recreate your "user" table records as required.

If you mean your CMS users table then just login to your MySQL server using the MySQL Monitor or phpMyAdmin and recreate the CMS users table entries.

--
Matt Doyle, Elated
3rd Edition of my jQuery Mobile book out now! Learn to build mobile web apps. Free sample chapter: http://store.elated.com/

 
New posts
Old posts

Follow Elated