How To Fix ODFaq MYSQL Installation Errors Database Admin Login Password
RegisterLogin
How To Fix ODFaq MYSQL Installation Errors Database Admin Login Password
Post Description: How To Fix ODFaq MYSQL Installation Errors Database Admin Login Password
Tags: how, to, fix, odfaq, mysql, installation, errors, database, admin, login, password
This Post Was Posted On Sep 25, 2009 By web hosting #1851
Post Description: How To Fix ODFaq MYSQL Installation Errors Database Admin Login Password
Tags: how, to, fix, odfaq, mysql, installation, errors, database, admin, login, password
This Post Was Posted On Sep 25, 2009 By web hosting #1851
How To Fix ODFaq MYSQL Installation Errors Database Admin Login Password by web hosting
- MYSQL ERRROR -
1. the mysql error:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'ifnull'
To fix this problem these are the steps i took to fix.
1. login to mysql using phpmyadmin
2. DELETE THE CURRENT NEWLY INSTALLED DATABASE by clicking on the "Drop" tab in phpmyadmin panel. will look the picture below:
3. now create a new database, lets call it "odfaq" or whatever you want, im going to name the new database as "odfaq", IMPORTANT: now on the collation drop down menu, make sure to select latin_swedish_ci
4. now dump the database.sql included in the script and try opening the script again with your browser, this time you should not get this error:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'ifnull'
- NOW THE ADMIN ERROR -
now that you have corrected the database error, you go to the admin directory and you try to login as "admin" and "admin" for password but it doesn't work. According to the install.html file, these are the defaults. but they don't work.
When i look at the admin password in myphpadmin, its encrypted, so i need to change it. this is how you change it:
1. go to the odfaq_user table in your myphpadmin panel. you will notice that the default password is set to "43e9a4ab75570f5b" but who knows what that is, since its encrypted, i have no idea what it is. so take the next step to reset the password.
2. click on the edit button (the one that looks like a pencil)
3. when you click on the edit button, you can edit the fields. edit the following fields:
for Function select: PASSWORD
for Value enter: password
It should look like something like the image (picture) below:
now hit submit for the changes to take affect. you will notice that the password field is now encrypted by it has the following password:
*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19
Now try to login to the admin section with
username: admin
password: password
SUCCESS!!
Thats it. hope it helps. Please provide any comments to suggestions. Thanks.
Leave Your Comments
Darryl
#2077 1
this helped my login issue, thanks! but for some reason my install won't display the faq's i have entered? any thoughts?
Sep 25, 2007 Reply Report abuse
Luke Ray
#2076 2
many thanks for the solution to a very irritating problem :-)
May 12, 2007 Reply Report abuse
tesla
#2075 3
this is very helpful, thanks for posting this information here
Apr 24, 2007 Reply Report abuse
Mike
#2072 4
Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!
I could not reset the admin password after our developer left. Thank you!
I could not reset the admin password after our developer left. Thank you!
Apr 10, 2007 Reply Report abuse
Sam
#2073 5
I had this same problem but i was able to fix it with your help.
thanks
thanks
Dec 31, 1969 Reply Report abuse
Sam
#2074 6
How To Fix ODFaq MYSQL Installation Errors Database admin login password it helped me to discover the problem solution. thanks
Dec 31, 1969 Reply Report abuse
Leave Your Comments...
©2012 Webune Forums - Mon Dec 17, 2012 10:22 pm
Powered by: Webune Forums V3
Powered by: Webune Forums V3