Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: FrancisT on March 13, 2011, 03:03:22 AM

Title: MYSQL password after installing epiware
Post by: FrancisT on March 13, 2011, 03:03:22 AM
I installed epiware a few days ago.  As part of the install I had to provide mysql's password for root.  I could not get the correct password so did a google search & found how to reset the password, which is FINE!!!

Now at startup the templates to do with mysql fail, the log for the first 2 follows:

Mar 13 13:33:43 ibmeserver 10fix_privilege_tables: ERROR
Mar 13 13:33:43 ibmeserver 10fix_privilege_tables:  1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Mar 13 13:33:43 ibmeserver 10fix_privilege_tables: waiting for mysqld to restart
Mar 13 13:33:44 ibmeserver mysql.init: Loading 10fix_privilege_tables into mysql succeeded
Mar 13 13:33:44 ibmeserver 20mysql_migrate_horde: ERROR
Mar 13 13:33:44 ibmeserver 20mysql_migrate_horde:  1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


How do I fix these to use the new password?  Any help would be greatly appreciated as epiware is not saving documents because of this, I assume.

Francis
Title: Re: MYSQL password after installing epiware
Post by: christian on March 13, 2011, 03:46:55 PM
I could not get the correct password so did a google search & found how to reset the password, which is FINE!!!
Apparently not and in fact no. For more back ground see http://wiki.contribs.org/MySQL . This is also in the FAQ.

Don't forget to search first before posting. To find this reference I used the site's search tool with the phrase "mysql password". You will see other relevant posts of people who have made this mistake.

I can't speak to epiware but every other package I have used allows you to specify your own user/pass combo for the database it requires. The reference above also shows you how to do this. Usually all you need to do after setting your own user/pass is to change the application's config file to match.