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

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'

If you’re on linux try “man mysql” for starters.

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/navicat_mysql/mysql_detail_mac.html

[QUOTE=itmitică;5147935]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/navicat_mysql/mysql_detail_mac.html[/QUOTE]

Um, I said I have MAMP…

Debbie

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

Which means that MAMP comes with a built-in command-line mysql client… :wink:

Debbie

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.