Problem creating MySQL dbs in Multi-Server Configuration

[AmpSys]

Originally Posted by till

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:

mysql -h {fqdn} -u root -p

Then ran:

mysql > GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY {rootpwd};
quit

Then created another database , logged in this time as localhost and:

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.