K am using servicedesk version 7
The database is running and the problem is the database is showing that its working though the problem is we are unable to view the database tables or the database itself

Quote:

---

Originally Posted by matiruv

k am using servicedesk version 7
the database is running and the problem is the database is showing that its working though the problem is we are unable to view the database tables or the database itself

---

To Connect to mysql server from a remote PC you have to grant administrator privileges to the remote machine. You need to execute the commands given below in the servicedeskmachine.
Execute the following commands from SD+ server console
1. Connect To mysql database.
Cmd> cd [ServiceDesk-Home]\mysql\bin
Cmd> mysql.exe -u root -P 33366 servicedesk

2. Grant Admin Privilege
Mysql> grant usage on servicedesk.* to root@'hostname-or-ipaddress';
Mysql> grant ALL on servicedesk.* to root@'hostname-or-ipaddress';
Mysql> flush privileges;
If you are typing the host name type the fully qualified domain name.

3.To access the database from another machine, use the commands

Cmd> mysql.exe -u root -P 33366 servicedesk -h [servername-or-ipaddress-of-Servicedesk-server]

[hostname-or-ipaddress is the machine from where you wish to connect to SD+ database]