WebFaction
Community site: login faq

Is it possible to create a read-only capable MySQL user for our WebFaction hosted databases?

We would like to use this limited user within scripts for backing up. The aim to being to reduce the number of users with excessive rights.

asked 30 Sep '13, 06:38

Graham
8538
accept rate: 0%


At this time, our control panel does not provide a means to create a read-only MySQL user. If you need that capability at this time, then you'll need to use a private MySQL database instance to manage your databases. You would have total control over a private instance, so you could give your database users whatever privileges meet your needs.

permanent link

answered 30 Sep '13, 17:32

seanf
12.2k41836
accept rate: 37%

If you're comfortable doing it manually instead of through the control panel, you can set up a second MySQL user and give it read-only access as detailed here:

http://community.webfaction.com/questions/803/providing-phpmyadmin-access-to-other-users

permanent link

answered 30 Sep '13, 19:36

SethKinast
258211
accept rate: 54%

edited 30 Sep '13, 19:36

Thanks for this link. A later comment from @seanf suggests GRANT has now been removed by default from new MySQL users. That stops this approach working for recent accounts.

(01 Oct '13, 07:07) Graham
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×168
×69

question asked: 30 Sep '13, 06:38

question was seen: 4,147 times

last updated: 01 Oct '13, 07:07

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM