I'm trying to get to know Django (my first attempts at a framework, or any backend work for that matter), and I'm seriously stumped by MySQL, and SQL in general.
I'm trying to create a new database and I get:
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'dbname'
So I've tried the advice here: Access denied for user localhost
Which might work, but using:
mysql -uroot -p I can't seem to remember my password. I don't recall setting one, but leaving it blank doesn't work either.
Also, I have to run mysql using:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I'm guessing that's related to the error above, right?
I'm in a right mess here, SQL and the command line intimidate the heck out of me and it seems so easy to break stuff. If anyone could offer some pointers that would be great.