SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Wizard DoubleDee's Avatar
    Join Date
    Aug 2010
    Location
    Arizona
    Posts
    3,756
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Command-Line MySQL?

    I am trying to get a better understanding of how functions like HTMLEntities work, but the problem is that since phpMyAdmin is a browser-based app, it is distorting what is going in and out of my database table...

    So I want to try using the mysql client, but am pretty shaky on command line.

    Some questions...

    1.) When I opened up the mysql client - or whatever it is called - it goes directly to...

    mysql>
    Is that dangerous for a Dev Environment?


    2.) How would I delete the save password so no one could get it and make it so I have to type it in when I open the command line?


    3.) How can I put a shortcut on my Mac Application bar so I can access this with one click versus navigating in Finder to the alias link?


    Thanks,


    Debbie

    P.S. I am using MAMP v1.7.2

  2. #2
    SitePoint Wizard DoubleDee's Avatar
    Join Date
    Aug 2010
    Location
    Arizona
    Posts
    3,756
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Actually, maybe I have a more fundamental problem, because I am getting this...

    Code:
    mysql> use doubledee
    ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'doubledee'

  3. #3
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    357
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If you're on linux try "man mysql" for starters.
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon

  4. #4

  5. #5
    SitePoint Wizard DoubleDee's Avatar
    Join Date
    Aug 2010
    Location
    Arizona
    Posts
    3,756
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

  6. #6
    Non-Member
    Join Date
    Feb 2012
    Posts
    892
    Mentioned
    10 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by DoubleDee View Post
    Um, I said I have MAMP...


    Debbie
    Which means that any of the clients I mentioned above would be suitable for your purpose.

  7. #7
    SitePoint Wizard DoubleDee's Avatar
    Join Date
    Aug 2010
    Location
    Arizona
    Posts
    3,756
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by itmitică View Post
    Which means that any of the clients I mentioned above would be suitable for your purpose.
    Which means that MAMP comes with a built-in command-line mysql client...


    Debbie

  8. #8
    SitePoint Enthusiast
    Join Date
    Jul 2007
    Location
    San Sebastian, Spain
    Posts
    93
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Hi Debbie,

    the error 1044 you are getting is because you are logging in with a guest user account and this user account does not have access to the database 'doubledee'. Once you have created the database you have to grant access to a user to the objects in that database. At this point that user account has access to the database.

    Code:
    mysql> use doubledee
    ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'doubledee'
    Try using "mysql -u username doubledee"
    where the username is the one that has access to the doubledee database. You may have to indicate that a password is necessary to login with the -p parameter.


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
  •