
Hello, I've installed OTRS local on my pc and on a server (Windows 2003 server). How can I connect to the MYSQL database on the server with MySqlmanager? Connecting to the locally MySQL database (on the pc) is no problem, but I cann't connect to the server... Hopefully anybody can help me, Tnanx, Rene ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.

Hello, although this is a question which would be better placed in a mySQL beginners list: are you familiar with, and have you checked the user rights for your database ? Seems to me that the the user you're connecting with is allowed to connect locally but not from remote. Some GRANT's will help. hth FranzF Koning, Rene wrote:
Hello,
I've installed OTRS local on my pc and on a server (Windows 2003 server). How can I connect to the MYSQL database on the server with MySqlmanager? Connecting to the locally MySQL database (on the pc) is no problem, but I cann't connect to the server...
Hopefully anybody can help me,
Tnanx, Rene
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
------------------------------------------------------------------------
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

Koning, Rene wrote:
I've installed OTRS local on my pc and on a server (Windows 2003 server). How can I connect to the MYSQL database on the server with MySqlmanager? Connecting to the locally MySQL database (on the pc) is no problem, but I cann't connect to the server...
This sounds like how I backed into MySQL, as well. It took a while, but eventually figured out that (in the mysql database) there must be entries in the db, host and user tables, all of which allow access. If any one of them is wrong, or missing, no remote connection. Also, as someone else has written, proper permissions must be GRANTed. Steve
participants (3)
-
Franz Ferdinand Esberger
-
Koning, Rene
-
Steve Hill