New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Web Design and Hosting Creating sites, scripting, and hosting discussions.

Fresh install of MySQL denies access to root


Post Reply New Thread Subscribe

 
Thread Tools
IceLatte

 
Member Since: Jun 24, 2007
Posts: 1
IceLatte is on a distinguished road

IceLatte is offline
Problem:
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:

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

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.

thanks,
bound and determined
QUOTE Thanks

Post Reply New Thread Subscribe


« youtube in iweb?!? | Need Feedback & Advice for Website made with iWeb »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Powerbook 520 - OS Install Help S1lver Running Windows (or anything else) on your Mac 6 06-25-2006 01:18 PM
Reformatting HD / fresh install question Sproles OS X - Operating System 2 09-20-2005 07:24 PM
fresh Panther install but Mail & Safari don't respond kinohaitsma OS X - Operating System 2 05-04-2005 04:27 PM
upgrade or fresh install? Tiger's coming! zanoncello OS X - Operating System 9 04-14-2005 04:55 PM
Fresh install of Os X? Kananigirl Switcher Hangout 2 05-29-2004 09:09 PM

All times are GMT -4. The time now is 12:50 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?