MySQL - Permissions

[Torey]

Hello, all.    I am terribly sorry ahead of time for the noob question and if it's been asked before.  I ask that you please be patient with me as it takes me a moment to understand things. 

 

I have installed on my Windows 98SE machine:

 

Apache 2.2.8

PHP 5.2.5

MySQL Server 5.0.51b

phpMyAdmin 2.11.7

 

(If this question has been asked/resolved before, please point me in the correct direction  )

 

I have successfully been able to start MySQL and then enter my root user password at the MySQL Command Line Console.  I get the 'Welcome to MySQL' message and the general options for help, etc..

 

However, when I want to shut MySQL down, I get the error message:

Shutdown failed; 'Access denied; you need the SHUTDOWN privilege for this operation'

 

I have read on other places and I can't seem to find an noob-friendly answer on how to create grant tables.  Can someone please please consider writing me a step-by-step process to get the correct permissions sorted out?  Do I need to make another user?  Do I just use 'root'?  Please help. 

 

[wildteen88]

What user have you login to the MYSQL client? If its the root user then you should not get this error. The root user has no limitations.

 

To grant all privileges for the root user run this command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

Followed by

FLUSH PRIVILEGES;