Client is using MS Access 2003 as a front-end to a mysql server database. He is able to connect to mysql databases on my local server using ODBC wizard and selecting the MySQL ODBC 3.5.1 driver, but is not sure of the correct syntax to use to connect remotely to the server. What is the syntax to complete the fields in the MS Access ODBC connection wizard? Port 3306 is open via the firewall as well. The fields to be completed to make the connection are: Server: User: Password: I've tried the below (replaced my password and database names with example info) Server: http://username:mycPanelPwd@ipaddress I tried installing ODBC connector without success http://dev.mysql.com/downloads/connector/odbc/3.51.html#linux-x86-32bit-rpms Code: root@server [~]# rpm -Uvh mysql-connector-odbc-setup-3.51.24-0.x86_64.rpm warning: mysql-connector-odbc-setup-3.51.24-0.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libX11.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libXcursor.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libXext.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libc.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libc.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libc.so.6(GLIBC_2.3)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libdl.so.2()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libdl.so.2(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libgcc_s.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libgcc_s.so.1(GCC_3.0)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libm.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libm.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libodbcinst.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libpthread.so.0()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libpthread.so.0(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libpthread.so.0(GLIBC_2.3.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libstdc++.so.5()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libstdc++.so.5(CXXABI_1.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libstdc++.so.5(GLIBCPP_3.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 libz.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 mysqlodbcrpmpack is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64 Code: root@server [~]# rpm -Uvh mysql-connector-odbc-3.51.24-0.x86_64.rpm warning: mysql-connector-odbc-3.51.24-0.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libc.so.6()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libc.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libc.so.6(GLIBC_2.3)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libcrypt.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libdl.so.2()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libltdl.so.3()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libm.so.6()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libm.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libnsl.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libodbc.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libodbcinst.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libpthread.so.0()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libpthread.so.0(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libpthread.so.0(GLIBC_2.3.2)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 libz.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64 Server is using Cpanel, MYSQL 5
