SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2009
    Location
    China
    Posts
    69
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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'?
    Many Thanks & Best Regards,
    HuaMin Chen

  2. #2
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  3. #3
    SitePoint Enthusiast
    Join Date
    Apr 2009
    Location
    China
    Posts
    69
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Many thanks. From command line, then how can we export/import the whole user?
    Many Thanks & Best Regards,
    HuaMin Chen

  4. #4
    SitePoint Enthusiast
    Join Date
    Apr 2009
    Location
    China
    Posts
    69
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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?
    Many Thanks & Best Regards,
    HuaMin Chen


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •