Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 26th January 2011, 16:37
AmpSys AmpSys is offline
Junior Member
 
Join Date: Dec 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
Ok. So the problem is what I suggested in post #2 of this thread. It is not possible to login to the mysql database with the mysql login details that are in the mysql_clientdb.conf file.

Please ensure that a login with the details in that file as root user to localhost is possible. You can test that with the command:

mysql -h localhost -u root -p

and then enter the password that you find in the mysql_clientdb.conf file on the db server.



Thats not strange, as the transacrtion has been closed and no other transactions are waiting. Also the jobs that are processed at a given time vary as not every monitoriyng process gets called every time you execute the script to ensure that the system does not get overloaded.
I can't login as localhost but I can login with the FQDN of the server... But I'm using the same password as in the conf file. Why would that be?

*Edit AGAIN - it's working now!

I could login to mysql using the FQDN of the server, but not localhost. So I logged in with:

Code:
mysql -h {fqdn} -u root -p
Then ran:

Code:
mysql > GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY {rootpwd};
quit
Then created another database , logged in this time as localhost and:

Code:
mysql>show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| c1ampmwp           |
| c1temptemp         |
| c2ampcrm           |
| dbispconfig        |
| mysql              |
+--------------------+
6 rows in set (0.00 sec)
There it is!

You're the man, Till! Thanks so much.

Last edited by AmpSys; 26th January 2011 at 16:53.
Reply With Quote
Sponsored Links
 

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
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
SSL don't work please help me walner8080 Installation/Configuration 8 26th September 2010 12:07
Need some Hints to "The Perfect Server - Debian Lenny (Debian 5.0) [ISPConfig 3]" wahid HOWTO-Related Questions 10 25th August 2010 15:18
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
subdomain and mail relay configuration aranthorn Installation/Configuration 24 3rd September 2007 22:53


All times are GMT +2. The time now is 16:52.


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