How do I switch users in mysql?



How do I switch users in mysql?..

Answer / Gautam Kishor

To switch users in MySQL, use the SQL command `USE <database_name>;` followed by `SET user = '<username>';`. Then, execute `SELECT user();` to verify the change.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is the difference between timestamp and datetime in mysql?

1 Answers  


Is there an object-oriented version of MySQL library functions?

1 Answers  


How do I rename a table in mysql workbench?

1 Answers  


What are the different types of triggers in mysql?

1 Answers  


What does blob mean in mysql?

1 Answers  


How to get a version of mysql?

1 Answers  


Explain Normalization concept?

2 Answers   Inuva,


Explain the difference between FLOAT, DOUBLE and REAL.

14 Answers   Yahoo,


Can you tell the difference between $message and $$message?

1 Answers  


How to enter numeric values as hex numbers?

1 Answers  


How to load data from a text file into a table?

7 Answers   Sasaa,


How to include character strings in sql statements?

1 Answers  


Categories