Consider the following steps given below to setup MySQL database in a separate machine.
Copy the mysql folder under <Central-home> to the remote machine. Note: The dmsdb folder [<Probe-home>\mysql\data] must exist in probe installation in case if you cut and paste the mysql folder instead of copying the same.
Create a folder with the name tmp under the mysql home
directory if it does not exists.
Start the installed mysql by executing the following command in
<install-dir>/mysql/bin directory
>mysqld-nt.exe
-u root -P 23306"
Connect to the mysql by executing the following command in
<install-dir>/mysql/bin directory
>"mysql.exe -u
root -P 23306"
Execute the following queries:
create database supportcenter;
create database desktopcentral;
use mysql;
Execute this query if the database has not been configured with a password grant ALL ON *.* to 'root'@'<name of the machine in which MSP
server is
running>' WITH GRANT OPTION;
eg.:grant ALL ON *.* to 'root'@'test.adventnet.com' WITH GRANT OPTION;
or
Execute this query if the database has configured with a password grant all on *.* to root@'%' identified by '<password you have configured>' WITH GRANT OPTION;
eg.:grant all on *.* to root@'%' identified by 'efgh123' WITH GRANT OPTION;
From MSP Central Side: Replace "localhost:23306" with [machine name in which mysql is
installed : mysql port] the new machine name:mysql port [eg.: test1.adventnet.com:3306] in the
following files.
