Help Center

Version 2.0

• Email Support: Submit a Ticket

• Web Hosting
• Databases

Related Articles

• Why connect remotely to hosting databases?
• Connecting to MySQL Using PHP
• Can I use the Berkeley Database Engine with my MySQL database?
• What are the Database Publishing Service and Database Publishing Wizard?
• Do you restrict any features in MySQL 4.1/5.0?
• Importing MS SQL 2005 Databases into MS SQL 2008 Databases
• What version of SQL Server is supported by the Database Publishing Service and Database...

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.

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 Creating MySQL or SQL Server Databases for Your Hosting Account 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 Why connect remotely to hosting 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 Connecting Remotely to Shared Hosting Databases.

• Not helpful
• Somewhat helpful
• Helpful
• Very Helpful
• Solved my problem