View Single Post
  #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