Solved

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

Posted on 2014-03-11
4
527 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 83

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 250 total points
ID: 39920324
I suspect that's because root has all privileges.

HTH,
Dan
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 250 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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Showing random records from database 10 54
mysql date time 14 52
Uploading a CSV Data Import via PHP & MySql 3 72
Duplicated data in GROUP_CONCAT 2 52
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Creating and Managing Databases with phpMyAdmin in cPanel.

710 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