Hello,
I have been trying your product and it seems that I keep getting errors when connecting to mysql.
I am doing this on a GNU/Linux box with CentOS 6.4 and MySQL 5.1.69
I can connect to mysql, create databases and change anything I would like with multiple users.
It seems java is trying to run the following command:
/home/<USERNAME>/ManageEngine/ServiceDesk/mysql//bin/mysqladmin --no-defaults -u <USERNAME> --password=<PASSWORD> -S /var/tmp/mysql.sock --port=3306 -h localhost create servicedesk
which works fine for me when run from a terminal, but when i run "./run.sh" and then look in the logs I get the following error.
Problem while creating database servicedesk.|
/home/<
USERNAME
>/manageengine/servicedesk/mysql//bin/mysqladmin: connect to server at 'localhost' failed
I have a feeling this has nothing to do with accessing mysql, as I can issue commands in the same way java is and get positive results.
Does this by chance have to do with anonymous users in mysql?
I ask this because after re-reading this install guide:
There is a section that states to test mysql, I should run:
# mysql -u root -S ../tmp/mysql.sock servicedesk -A
Which is using an anonymous user [no -p argument defined].
So my question is, does service desk plus use the anonymous user for mysql?
If so this may be my problem, as I always remove any ''@'localhost' user from mysql {and any related anonymous user(s)}
Any ideas or comments will be helpful.
Thank you