How Tos > Connecting to MySQL DB

Connecting to MySQL DB

Tags:  

Connecting to the MySQL database & Executing a Query


Steps to connect to Central's database:
  1. Open the command prompt
  2. Navigate to /program files/adventnet/me/central/mysql/bin
  3. Execute the following command
    mysql.exe -u root -P 23306 centraldb


  4. You will get a mysql> prompt.
  5. Now you can execute a query on the mysql database.
    Eg.: mysql> select * from befailover;

Steps to connect to Probe's database:
  1. Open the command prompt
  2. Navigate to /program files/adventnet/me/probe/mysql/bin
  3. Execute the following command
    mysql.exe -u root -P 33306 dmsdb
  4. You will get a mysql> prompt.
  5. Now you can execute a query on the mysql database.
    Eg.: mysql> select * from befailover;

Click here to know the steps to start the MySQL database on the Central or Probe






 RSS of this page

rtttrrb