huamin — 2010-01-20T00:01:19-05:00 — #1
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'?
sjh — 2010-01-20T04:34:36-05:00 — #2
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
huamin — 2010-01-20T04:53:25-05:00 — #3
Many thanks. From command line, then how can we export/import the whole user?
huamin — 2010-01-20T21:38:35-05:00 — #4
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?