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?
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.