How to connect to the user

Hi,
After I’ve created one new user there on the DB, how can I connect to it in the prompt, that is called ‘Mysql command line client’?

Type in

mysql -u [username] -p

and press return/enter.

You will then be prompted for a password. Type it in, hit return again, and you’re in :slight_smile:

Many thanks. From command line, then how can we export/import the whole user?

Many thanks.
After having logged in as one user and then trying to create a table, it says this
ERROR 1046 (3D000): No database selected

Should I create one DB and then choose it first?