Home Guides Glossary

Creating a Read-Only Database User

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.

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.

      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.

Domain Registration

Pay less for website domain names. Register your own .com, .net or .org for as low as $10.18 per year. We have everything you need to get online with your new domain.

Website Builder

Build an amazing website in just under an hour with Website Builder. Take advantage of designs created just for your industry and then customize them to reflect your one-of-a-kind idea.

Website Security

Protect your website and keep customers safe. Your comprehensive Website Security solution. Get peace of mind by securing your websites.

cPanel Hosting

Everything needed to give your website the high-performance home it deserves.  Protect transactions and secure your customer's data with a SSL Certificate
Copyright © 2005 - 2024.  All rights reserved.  Privacy Policy