Database connectivity using unix


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Database connectivity using unix
# 1  
Old 08-30-2011
Database connectivity using unix

Hi,

I am trying to connect to the database through Unix serer using following command-
Code:
mysql  -u root -Jepadt -D dtdatabase

But it giving me error -
Code:
mysql: unknown option '-J'

Can anybody help me to solve this problm


Thanks in advance

Moderator's Comments:
Mod Comment Please use code tags, thanks.

Last edited by zaxxon; 08-30-2011 at 04:10 AM.. Reason: code tags
# 2  
Old 08-30-2011
The error looks correct to me, what do you expect the -Jepadt options to do?

Take a look through the options reference guide for the mysql command line client and select the options you mean to use.
# 3  
Old 08-30-2011
there are two ways to use this command

1)mysql -u root -Jepadt -D dtdatabase

2)mysql -u root -p Jepadt -D dtdatabase


here -u-username -p -password -D-database name. Jepadt-is password here

---------- Post updated at 04:02 PM ---------- Previous update was at 01:36 PM ----------

Got the solution Smilie

write command is-

mysql -u root -pJepadt -D dtdatabase
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Help with Windows to Unix connectivity

Hi Can we pass the parameter from the excel in windows and invoke the unix shell script from excel VBA by passing this parameter and get the results of shell script to the excel sheet? We tried to get the things in unix independently but we still strucked in connecting the excel to... (5 Replies)
Discussion started by: bikky6
5 Replies

2. Shell Programming and Scripting

Teradata connectivity through UNIX by use bteq

Hi, I want a script for connecting teradata to load the file to teradata table. Can you please help me out. Thanks in advance. (1 Reply)
Discussion started by: victory
1 Replies

3. Shell Programming and Scripting

Database connectivity

Hi All, How can we access oracle database which is in another server using shell scripts? Please share your ideas. Regards, Raja (1 Reply)
Discussion started by: Rajakct84
1 Replies

4. Shell Programming and Scripting

checking sql connectivity in unix

hi, i am using a sqlplus connection in one of my shell scripts. i want to check if the connection is set properly or not.. can i use '$?' to check the status of the sql connectivity..? or is there any other option to do that..? thanks, (1 Reply)
Discussion started by: kripssmart
1 Replies

5. Shell Programming and Scripting

Dos-Unix Connectivity

Hi, Is there any method to connect unix box(Excecuting unix commands through Batch Files) through DOS prompt. (1 Reply)
Discussion started by: shekhar_ssm
1 Replies

6. Shell Programming and Scripting

Database connectivity

Dear all, can any body help me about database connectivity? i want to data by extracting from oracle... so please give me some idea... Thanks, Regards, Pankaj (1 Reply)
Discussion started by: panknil
1 Replies
Login or Register to Ask a Question