Connecting MySQL in RH9
 

Hello

i m a newbie in linux after 8yrs in Windows.

I m successfully installed MyODBC libraries and creating odbcinst.ini and odbc.ini files.

i edit my odbcinst.ini using text editor to the following:

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmuodbc.so
Fileusage=1

note:i deleted the postgreSQL section in that file (i.e odbcinst.ini)

i also edited my odbc.ini to the following:

[MySQL]
Description=MySQL database test
Driver=MySQL
Server=localhost
Database=test
Port=3306

But, when i test the connection using ...isql MySQL-test test or isql MySQL-test -v.......the following error appeared;

"Data source name is not found and no default driver specified.Could not connect to SQLConnect"

So...anybody out there can help me to connect to MySQL.
FYI, i m advanced user in SQL Server but when comes to MySQL@RedHat...i m nothing!

cheers....brembo

Re: Connecting MySQL in RH9
 

Why are you using a ODBC connection to your localhost? If you have started MySQL properly then you are able to connect to the localhost (mysql db) by typing:

mysql -p (type the passwd from the currently logged-in user)

Please let me know what you are exactly planning to do ....