#1  
Old 19th October 2011, 12:28
maxeaves maxeaves is offline
Junior Member
 
Join Date: Feb 2011
Location: London, United Kingdom
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL root password

I need some help please with an ISPConfig that Till set-up - and it is mainly to do with the MySQL database that it is using.

I know that an ISPConfig was setup on the database concerned, but this user only has admin rights on the ISPconfig database setup. The problem seems to be more to do with the root password on the MySQL database - which I have now lost - and the instructions are not working for me.

Which makes me think - that there is either no root user for my ISPConfig build or that my MySQL database is seriously screwed.

This whole thing has come about, because I had to upgrade MySQL to work with a later version of PHP that I needed for MediaWiki [dependancy hell on RHEL - sorry] - and the MySQL database says that it needs to have mysql_upgrade run on it....which doesn't work - because I don't have the root password for the MySQL server....

sighs....

Max
Reply With Quote
Sponsored Links
  #2  
Old 19th October 2011, 12:49
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,384 Times in 4,231 Posts
Default

Your mysql server has a normal root user as any mysql server, ispconfig does not change anything in this regard. If I installed the server for you, then you either received the mysql root password from me by email (please see my mail with the login detail that you received after the installation) or if mysql was already installed, then the mysql root password is the one that you sent me to install ispconfig.

You can also find the mysql root password that was working at the time ispconfig was installed in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf. If the password in that file does not work anymore, then either mysql is broken or you changed the password in the meantime.

The ISPConfig FAQ also contains instructions on how to reset a mysql root password:

http://www.faqforge.com/linux/contro...root-password/

If this wont work, then your mysql database is most likely broken by the mysql update. Do you have any server backups that you can restore?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.

Last edited by till; 19th October 2011 at 12:57. Reason: typos
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
m4l41k4t (27th November 2012)
  #3  
Old 19th October 2011, 12:55
maxeaves maxeaves is offline
Junior Member
 
Join Date: Feb 2011
Location: London, United Kingdom
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Till - thank you very much for that; that is much appreciated.

Best Wishes


Max
Reply With Quote
  #4  
Old 19th October 2011, 14:20
maxeaves maxeaves is offline
Junior Member
 
Join Date: Feb 2011
Location: London, United Kingdom
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

All fixed - that is lovely - and even better, I've managed to fix my database issues using myisamchk command - so I am now a totally happy bunny!

Thanks Till.

Max
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail and DNS troubles with ISPconfig 3 in Ubuntu 10.04 hakimus HOWTO-Related Questions 11 16th June 2010 14:56
Apache domain to directory? badgerbox76 Server Operation 27 29th January 2008 20:07
Apache2 Freezes celtic Server Operation 31 28th May 2007 17:18
Server Side Includes don't work PermaNoob General 7 1st May 2007 20:38
Apache - Virtual hosts - ISPConfig Hans Server Operation 8 23rd April 2006 16:29


All times are GMT +2. The time now is 18:35.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.