LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-28-2003, 10:12 PM   #1
badrul
LQ Newbie
 
Registered: Oct 2003
Location: Malaysia
Posts: 1

Rep: Reputation: 0
Talking 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
 
Old 10-29-2003, 02:48 AM   #2
daveo
Member
 
Registered: Sep 2003
Location: Holland
Distribution: Gentoo 1.4, Slackware
Posts: 196

Rep: Reputation: 30
Re: Connecting MySQL in RH9

Quote:
Originally posted by badrul
i edit my odbcinst.ini using text editor to the following:

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

[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!

[/B]
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 ....
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting to Mysql blood_omen Debian 6 07-23-2004 02:20 AM
Connecting to MySQL ksalopek Linux - Software 5 06-11-2004 10:07 AM
connecting to mysql dkc_ace Linux - General 2 03-22-2003 08:18 PM
Connecting to mysql webee Linux - Software 2 01-30-2003 03:47 PM
Mysql is not connecting from servlet.But connecting from java, help pls Harish_f Linux - General 0 05-08-2002 04:21 AM


All times are GMT -5. The time now is 01:13 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration