LuckyRegister – How To Create a Read-Only Database User

This article only applies to LuckyRegister Web & Classic Hosting

You can create databases on your hosting account for your websites to use. The types of databases depend on which type of hosting you have

You can create a read-only database user to allow a third party to browse the data in a database, to use for your reporting tools, or to ensure that your scripts are not writing to the database.

NOTE: You cannot add a read-only database user to an already-created database. This feature is only for new databases.

To Create a Read-Only Database User

  1. Follow the instructions in Create MySQL or MS SQL databases and make sure to do the following:
    • In the Read-Only User Name field, enter a user name.
    • Create a password for the read-only user and confirm it.
    • (Optional) Specify to Allow Direct Database Access. Specifying this option allows the read-only user to use tools such as MySQL Query Browser or Microsoft SQL Server Management Studio Express to browse the database.

      NOTE: If you don’t see the Allow Direct Database Access option, contact customer support. If you are not sure what Direct Database Access is, see Connect remotely to databases

  2. Click OK.

To browse the data on the database, a read-only user has to connect using third-party tools such as MySQL Query Browser or Microsoft SQL Server Management Studio Express.

For more information on connecting remotely with tools such as these, see Connect remotely to databases.