Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2014-03-11
4
Medium Priority
?
575 Views
Last Modified: 2014-03-11
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
0
Comment
Question by:Trevor_C
  • 2
4 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 39920011
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
 

Author Comment

by:Trevor_C
ID: 39920024
When I connect to the instance using mysql administrator when I select the user root all the priviledges are grey out.
0
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 1000 total points
ID: 39920324
I suspect that's because root has all privileges.

HTH,
Dan
0
 
LVL 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 1000 total points
ID: 39921144
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month15 days, 11 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question