Tim Hilliard

So how do I create another user for MySQL that has administrator privileges using the MySQL AB GUI Administration Tool?

I had wondered how we were supposed to do this with the GUI tool until recently. Of course you can create another user using the command line and then apply the following query to the user.

GRANT ALL PRIVILEGES ON *.* TO ‘user’@'host’ IDENTIFIED BY PASSWORD ‘[password]‘ WITH GRANT OPTION”

But not everyone likes to use the command line. To do this with the GUI tool all we need to do is go to Tools->Options and then make sure that “Show Global Privileges” option is checked.

MySQL GUI Global Rights

Now when you select a user there should be another tab appear called “Global Privileges” that will allow you to apply global rights to a user thus allowing you to create another administrator.

This entry was posted on Friday, December 5th, 2008 at 5:05 pm and is filed under Website Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.