how do you login to mysql using unix shell? : Sql dba



how do you login to mysql using unix shell? : Sql dba..

Answer / Vikas Gautam

"To log into MySQL from a Unix/Linux shell, use the `mysql` command followed by your database user name and password. If you have not set a password for your user account, you can omit it:
```
mysql -u username [password]
```
If you want to connect to a specific database, add the database name as well:
```
mysql -u username -p [database_name]
```
MySQL will then prompt you for your password."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is meant by <> in sql?

1 Answers  


What are triggers, and when would you use them?

3 Answers  


when a procedure /package is getting invalidated?

4 Answers   TCS,


What is pl sql package?

1 Answers  


What is relationship? How many types of relationship are there?

1 Answers  


What are the types of join and explain each?

1 Answers  


Which is better join or inner query?

1 Answers  


How to use boolean type in select statement?

1 Answers  


What is the use of triggers?

1 Answers  


What is trigger in sql?

1 Answers  


Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  


Can we insert data into materialized view?

1 Answers  


Categories