MySQL Bugs: #68704: Post installation issues with non root user

Bug #68704	Post installation issues with non root user
Submitted:	18 Mar 2013 15:15	Modified:	18 Mar 2013 17:07
Reporter:	Dharam bhat	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.6	OS:	Solaris
Assigned to:		CPU Architecture:	Any

Description:
Hi,

I am able to do below and can see i am logged on to mysql with the default user that i used for installation.Also i am able to run sysdate etc queries,so that part is working.

mysql> select user();
+-------------------+
| user()            |
+-------------------+
| abcadm@localhost |
+-------------------+

But when i try to set up this user or any other ,i am getting access denied error.

mysql> select * from mysql.db;
ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'db'
mysql> select * from mysql.user;
ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'user'
So this is becoming chichkena nd egg issue for me.I know i need to set up users/passwords but not sure how to get access in first place to my default user.

How to repeat:
Trying installing My sql 5.6 with non root user and then try accssing user tables/setting up user id etc

You're logged in using the "anonymous" user which has privileges on the "test" database only ...

See http://dev.mysql.com/doc/refman/5.6/en/default-privileges.html for more details on this ...

Thanks!

Works now after using root user .