Hello all, unfortunately my first post is appearing in my own thread. Sorry about that.
I am having some basic mySQL post installation problems. Basically, I cannot connect to to my local server as the root user. I can connect to the database, and run all the standard tests, but as far as modifying the databases and creating new ones, I don’t have permission. I really cannot tell you more then that, other then the fact that I am running on OS X 10.4.2, and I used the 4.1xxx standard mySQL pkg for OS X.
As far as my problem goes, it seems very common. I’ve been to the mySQL forums and a few other places, and I saw a decent amount of people complaining about the Accsess denied errors, but still could not really put a stop to my problem.
Here’s what the terminal is telling me:
[COLOR=Blue]:/usr/local/mysql nickdaniel$
:/usr/local/mysql nickdaniel$ /usr/local/mysql/bin/mysqladmin -u root password new_password_here
/usr/local/mysql/bin/mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘root’@‘localhost’ (using password: NO)’
:/usr/local/mysql nickdaniel$
:/usr/local/mysql nickdaniel$ /what de fook;
[/COLOR]
And if this helps, here’s the installation run-down I followed: