I am having issues connecting to the DB from a remote system. If I am on the system that runs the database, I was able to use the IP address, hostname just fine, shown below, but if I use a different computer remotely accessing the database, the IP address or the host will not work. The server and the remote computer is in a corp network. I do have the admin access to the DB. Any tips on why it will not work?
- I do have the mysql.AHK in the local directory.
- OS Windows 7
- AHK Version 1.1.09.04
db := mysql.connect("hostname","root","password","test")
db := mysql.connect("IP_Address","root","password","test")
******
#include mysql.ahk
F9::
{
ReadRequest()
}
return
;**********************************************************************************************************
ReadRequest(){
Msgbox, triggered Database
mysql := new mysql ; instantiates mysql object
db := mysql.connect("hostname","root","password","test") ; host,user,password,database
if db
msgbox, mySQL worked
if mysql.error
msgbox, no mySQL
sql =
(
SELECT Name
FROM test
WHERE Name = "Hans"
)
firstname := mysql.query(db, sql)
Msgbox, First Name: %firstname%
}
return