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'?
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
Many thanks. From command line, then how can we export/import the whole user?
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?