Setting up a User account and privileges

The root account has all privileges and should be used for administration purposes only. For security reasons, we are going to create a different user account with restricted access. On the home page click Privileges and then click Add a new User.

The password field is optional. You can chose a password yourself or have one generated for you. We are giving the user basic access, therefore we're only ticking the checkboxes that will give them basic rights. For instance, they will not be able to delete a database. Click Go to set the privileges. You can apply privileges to databases and tables and columns within a database.

Do you need help with MySQL? Gain advice from Builder AU forums

Leave a comment

You must read and type the 6 chars within 0..9 and A..F

* indicates mandatory fields.

Log in


Sign up | Forgot your password?

  • Staff XP stays on life support for longer

    This week's Roundup looks at Microsoft's decision to extend the life of Windows XP, the release of Microsoft Surface SDK, Firefox's new Geode plug-in, Yahoo's new tool -- Smush It and more. Read more »

    -- posted by Staff

  • Chris Duckett The good and truly awful celluloid depictions of computers

    Ever wonder why your lawyer uncle leaves the room whenever you turn over to Boston Legal? Or why your forensic science cousin can't stand crime drama? You know the answer: it’s the horrid trivialisation and dumbing down of an occupation to make it appear entertaining. Sometimes it is so unbelievable that it actually hurts and yelling at the screen is the only outlet. Read more »

    -- posted by Chris Duckett

  • Brendon Chase Apple's iPhone engineers to tour Sydney, Melbourne

    Aussie developers will be able to get up close and personal with some of the iPhone engineers in November to learn how to build applications for the platform. Read more »

    -- posted by Brendon Chase

What's on?