Download mysql version 5.0.44 setup from the mysql site and install the same in the machine where you want to build a MYSQL database.(or) alternatively you can copy the mysql folder under <Central-Home> to the remote machine. If you don't want to copy the 'central' server 'Mysql' folder, copy the 'my-large.ini' present under the installed mysql home directory and paste it in 'data' directory and rename the file as 'my.cnf'
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:

                     1. use database mysql;
                     2. Execute this query if the database has not been configured with a password
                         grant ALL ON *.* to 'root'@'<name of the machine in which OpMDE 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;

     6. From OpMDE 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 file

CentralHome\conf\database_params.conf
url jdbc:mysql://test1.adventnet.com:23306/centraldb?jdbcCompliantTruncation=false

Click here to know the procedures if you want to configure a password to the database.

RSS of this page