MySQL Forums
Forum List  »  Connector/ODBC

Another Linux User than root Cannot use Mysql ODBC
Posted by: Fuat Sungur
Date: January 28, 2014 11:10AM

Hi everyone,

I installed mysql 5.5 to Lubuntu and I installed also related Mysql ODBC drivers. By the way I installed the mysql with this command:

> sudo apt-get install mysql-server mysql-client

This command installed the mysql and then I can connect to the mysql server via mysql command line utility with all the linux users.

Also I installed the related ODBC driver for linux and then I can easily use "isql" command with root linux user:

root@xyz-VirtualBox:~# isql -v mysqldb
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>


But when I try same command with another linux user I got an exception:

dbadmin@xyz-VirtualBox:/$ isql -v mysqldb
[08S01][unixODBC][MySQL][ODBC 5.2(w) Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
[ISQL]ERROR: Could not SQLConnect

Contents of the related files have been specified in below. Thanks.

odbc.ini content:

[ODBC Data Sources]
mysqldb="Mysql DB"

[mysqldb]
Driver=/opt/mysql-odbc/libmyodbc5w.so
Description=Mysql Connector
SERVER=127.0.0.1
Database=testdb
PORT=
USER=FUAT
Password=
OPTION=0
socket=/var/run/mysqld/mysqld.sock

odbcinst.ini:
[Mysql Server]
Description = Mysql Server ODBC Driver
Driver = /opt/mysql_odbc/libmyodbc5w.so
Driver64 = /opt/mysql_odbc/libmyodbc5w.so
Setup = /opt/mysql_odbc/libmyodbc5w.so
Setup64 = /opt/mysql_odbc/libmyodbc5w.so
Threading = 0

/etc/mysql/my.cnf:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
bind-address = 127.0.0.1
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

!includedir /etc/mysql/conf.d/

Options: ReplyQuote


Subject
Written By
Posted
Another Linux User than root Cannot use Mysql ODBC
January 28, 2014 11:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.