Mysql 5.5, how do I grant privileges to the user "root" after installation

Hi
I need help I just did an install of mysql 5.5 but the "root" user has no privileges how do I grant privileges to the user "root" after installation.

Thanks
Trevor_CAsked:
Who is Participating?
 
Dan CraciunConnect With a Mentor IT ConsultantCommented:
I suspect that's because root has all privileges.

HTH,
Dan
0
 
Dave BaldwinFixer of ProblemsCommented:
Never seen that.  'root' is installed with ALL privileges and must be used to grant privileges to other users.  What makes you say it has none?
0
 
Trevor_CAuthor Commented:
When I connect to the instance using mysql administrator when I select the user root all the priviledges are grey out.
0
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
And because you can't change them?  At least not thru mysql administrator because that would probably crash the program.  Since it is using 'root' for it's permissions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.