06-24-2007, 05:04 PM #1
Fresh install of MySQL denies access to root
- Member Since
- Jun 24, 2007
With a fresh install of MySQL v5 I cannot log in as root user. Since its a fresh install, there should be no password in existence for root. I try with mysql -u root so I can then assign a password for security, then hit enter. My bash profile is already set up correctly.
Stuff I've done to try to fix it:
I've tried both of the ways they suggest for Unix (by nixing the .pid file and starting up my skipping grant tables.
I've tried this:
mysqld_safe --user=mysql --skip-grant-tables &
Then Execute these statements.
mysql -u root mysql
mysql> UPDATE user SET Password = PASSWORD('your_new_password') where USER = 'root';
mysql> FLUSH PRIVILEGES;
Everytime I get permissions denied for any files in my 'data' directory. The data folder is owned by 'mysql' user with a group of 'wheel'. That is the default privileges on install.
While futzing around before I managed to execute the above suggestions by changing the owner to my User name, and the group to mysql. However, even with the UPDATE script setting a new password, I couldn't get in with the one I set.
I know its confusing, but if this looks familiar to anyone, please please help me. A friend of mine mentioned having the same problem and she just gave up, but I'm determined to get this to work.
And I have tried uninstalling with the sudo rm commands and reinstalling several times with the exact same results.
bound and determined
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Krazypoloc in forum OS X - Operating SystemReplies: 6Last Post: 03-11-2012, 04:41 AM
By grom in forum OS X - Operating SystemReplies: 2Last Post: 12-25-2011, 09:31 AM
By kratos-2012 in forum OS X - Operating SystemReplies: 0Last Post: 08-09-2011, 03:27 PM
By kris182 in forum iPhone Hardware and AccessoriesReplies: 0Last Post: 10-13-2007, 01:16 PM
By liberal123 in forum OS X - Operating SystemReplies: 6Last Post: 03-28-2006, 02:14 PM