Forums

I'm using a reporting tool, SQL Explorer, and was wondering if there was a way to create a MySQL user that was read-only?

Read-only users wouldn't be possible on our setup, no.

As I'm thinking about it, one thing you could do is create a copy of your real database, and then use a scheduled task to sync the copy once a day (or once an hour if you upgrade). Then you let sql-explorer connect up to the copy of the db, and even if it does make any changes, they get blown away next time the db syncs. mysqldump would be the tool for this...

Thanks Harry, that will work for us...actually better because it will maintain a backup of the database just in case.

cheers

ps. I just got approval for a paid account, so this will shortly be one. woohoo :)

I can upgrade without issue...correct?

Correct, upgrading will not cause any issues.