Hi I has someone create a website for me using modx and i only know a little bit about it. i couldnt login to the manager so I deleted the user of the database and recreated the user with the same name. the login failed and now my site is gone. the homepage says:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« PHP Parse Error »
PHP error debug
Error: mysql_connect() [function.mysql-connect]: Access denied for user ’kathyspa_kathysp’@’localhost’ (using password: YES)
Error type/ Nr.: Warning - 2
File: /home/kathyspa/public_html/manager/includes/extenders/dbapi.mysql.class.inc.php
Line: 87
Line 87 source: if (!$this->conn = ($persist ? mysql_pconnect($host, $uid, $pwd) : mysql_connect($host, $uid, $pwd, true))) {
Parser timing
MySQL: 0.0000 s (0 Requests)
PHP: 0.0166 s
Total: 0.0166 s
Error while inserting event log into database.
Any ideas?
Thanks!
-
☆ A M B ☆
- 24,524 Posts
You never, ever mess with the ’mysql’ database. That controls all access to the entire mysql engine. And never use it for anything else.
To edit the MODx manager login, use the database you used to install MODx and edit the modx_manager_users table (if you used modx_ for the table prefix; substitute whatever prefix you used). When entering a password, select the MD5 function from the drop-down for the password field.