• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

How to give a user administrative privileges

Hi experts,

I am using MySQL 4.1 on a Windows 2003 server.
i would like to grant administrative privileges to a database user. same as the 'root' user.

i have created that user manually in the user database

thanks,
0
cakirfatih
Asked:
cakirfatih
1 Solution
 
mpf1748Commented:
Take a look at the GRANT syntax: http://dev.mysql.com/doc/mysql/en/grant.html

For example:
GRANT ALL ON *.* TO 'user'@'host' IDENTIFIED BY 'password' WITH GRANT OPTION
0
 
cakirfatihAuthor Commented:
thanks for the help
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now