I just recently installed mySQL on my Mac running 10.10.3, but I can't create any tables or modify anything associated with my databases. When I start mysql I logs me in as '@localhost'
mysql> select user();
+-----------------------+
| user() |
+-----------------------+
| username@localhost |
+-----------------------+
1 row in set (0.00 sec)
mysql> select current_user();
+----------------+
| current_user() |
+----------------+
| @localhost |
+----------------+
1 row in set (0.00 sec)
mysql> CREATE DATABASE ign;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'ign'
I even try running this to log into my sql.
mysql -u username -p
Enter password:
ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)
I am so lost and any help would be greatly appreciated.