MySQL Forums
Forum List  »  General

Re: Add privileges problem...pls help..
Posted by: jeff hill
Date: May 09, 2005 12:30PM

Edmund,

You may have some permissions issues...make sure the user you're running mysqld as has rights to your data directory.

Check out the grant command that Felix gave you a link to.. If that doesn't work, you can always modify the user table directly.

e.g. --> insert into user (User, Host, Password) values ('Jeff', '%', '');
update user set Select_priv = "Y" where User = 'Jeff';

repeat the last statement for each privilege the new user needs.

Options: ReplyQuote


Subject
Written By
Posted
Re: Add privileges problem...pls help..
May 09, 2005 12:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.