MySQL Forums
Forum List  »  Install & Repo

I do not have privilege - mac Lion
Posted by: Jone Hui
Date: October 13, 2011 10:38PM

Hi,

After installed Mysql on my macbookpro, I can 'login' to mysql and see 'mysql>'. When I try to CREATE USER from mysql> the error msg:

ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation

From my understanding mysql accepts any user without password but they all do not have ALL PRIVILEGES.

I can login with any name except root, see error msg:
/usr/local/mysql/bin/mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I tried sudo
sudo /usr/local/mysql/bin/mysqladmin CREATE USER 'dbbuser'@'localhost' IDENTIFIED BY 'password'
Password:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I couldn't find a way to assign a user and password with ALL PRIVILEGE.

Would someone help me on this? I did read a lot of articles regarding reset/assign user/password but the are my case. I think this could be because the Mac OS??

tks Jone

Options: ReplyQuote


Subject
Written By
Posted
I do not have privilege - mac Lion
October 13, 2011 10:38PM


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.