Command-Line MySQL?

[DoubleDee]

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

[DoubleDee]

Actually, maybe I have a more fundamental problem, because I am getting this...

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

[Doug G]

If you're on linux try "man mysql" for starters.

[itmitică]

If you're looking for Mac SQL clients for MySQL:

http://macsqlstudio.com/

http://dev.mysql.com/downloads/workbench/

http://www.sequelpro.com/

http://www.malcolmhardie.com/sqleditor/

http://www.araelium.com/querious/

http://www.navicat.com/en/products/n...etail_mac.html

[DoubleDee]

If you're looking for Mac SQL clients for MySQL:

http://macsqlstudio.com/

http://dev.mysql.com/downloads/workbench/

http://www.sequelpro.com/

http://www.malcolmhardie.com/sqleditor/

http://www.araelium.com/querious/

http://www.navicat.com/en/products/n...etail_mac.html

Um, I said I have MAMP...


Debbie

[itmitică]

Um, I said I have MAMP...


Debbie

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

[DoubleDee]

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

[rcashell]

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.

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.