I am a little green and I hope that the problem I am facing is simple ... edit: new information below
I need to establish a connection to a remote mysql database (Amazon RDS).
After several tutorials, I have unixodbc and libmyodbc installed and configured on the client, but when I try to connect via isql, I get an error
[08S01][unixODBC][MySQL][ODBC 5.1 Driver]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[ISQL]ERROR: Could not SQLConnect
The most confusing part about this error is that I am not trying to connect to a local database, but rather to a remote one. I don't have a mysql.sock file on the client ... this is not a problem, is it?
I feel a configuration error, but I'm just not sure what it might be.
If I run odbcinst -j, the output will be as follows:
DRIVERS............: /etc/unixODBC/odbcinst.ini
SYSTEM DATA SOURCES: /etc/unixODBC/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini
The contents of / etc / unixODBC / odbcinst.ini:
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib64/libmyodbc5.so
Setup = /usr/lib64/unixODBC/libodbcmyS.so
UsageCount = 5
[MySQL ODBC 515 Driver]
Description = ODBC 5.515 for MySQL
DRIVER = /usr/lib64/libmyodbc5-5.1.5.so
SETUP = /usr/lib64/unixODBC/libodbcmyS.so
UsageCount = 3
, , find libmyodbc * .so, . libodbcmyS * :
/usr/lib64/unixODBC/libodbcmyS.so.1
/usr/lib64/unixODBC/libodbcmyS.so
/usr/lib64/unixODBC/libodbcmyS.so.1.0.0
, , .
/etc/unixODBC/odbc.ini:
[target_db]
Driver = MySQL
Server = [servername.com]
Port = 3306
Database = [databasename]
Option = 2
User = [username]
Password = [password]
"", MySQL MySQL ODBC 515 Driver, .so(:/usr/lib64/libmyodbc5.so), .
:
odbcinst -i -d -f /etc/unixODBC/odbcinst.ini
:
odbcinst -i -s -l -f /etc/unixODBC/odbc.ini
:
odbcinst -s -q
, .. [target_db]
:
isql -v target_db user password
isql -v target_db
, .
- , ? , -
EDIT:
, mysql.
mysql, isql. , odbc.ini, , isql -v test-database, - , .
, , , .