Ask Experts Questions for FREE Help !
Ask
    matiruv's Avatar
    matiruv Posts: 1, Reputation: 1
    New Member
     
    #1

    Sep 15, 2008, 06:26 AM
    How mysql connects to servicedesk
    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
    pacotorrent's Avatar
    pacotorrent Posts: 1, Reputation: 1
    New Member
     
    #2

    Jan 24, 2009, 12:08 AM
    Quote Originally Posted by matiruv View Post
    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]

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Connects to Network, but can't get on Internet [ 8 Answers ]

Hello! Just purchased an HP dv5-1017nr at Best Buy today. I can't get the internet to work. It sees networks, excellent strengths, and even connects to them, but will not go to the internet. I tried two different houses. It shows that it connects to the network but stays stuck on "Identifying."...

Pppoe connects automatically and I don't want it to [ 2 Answers ]

Pppoe connects automatically and I don't want it to. I have tried all the simple and obvious fixes and none work. Any ideas?

DSL pppoe connects automatically, without prompting [ 2 Answers ]

DSL pppoe connects automatically, without prompting. This is a problem that has happened before and I resolved it, but I do not recall how. I have tried many things, including SpyBot, etc. but nothing seems to work. I have deleted the connection. Any ideas?


View more questions Search