20 Jul 10 Creating a Read-only Database User
If the hosting package that you purchased from Gossimer contains a MySQL database, you can up to 100 Users to access the Database. Not only that, you can also set specific action rights for the Users you create.
Creating a Read-only User
To set specific action rights for Users, you need to specify what privileges you wish to allow to a particular User. The article on Defining Action rights for a MySQL Database User provides detailed directions for the process of doing so. In order to create a Read-only User, you need to ensure that all privileges except the Select privilege are revoked for the User.
If you have installed a Power Tool in your Web Hosting Package, then you need to ensure that you do not perform any of the following actions:
- Modification/Deletion of the Database, that you selected during installation of the Power Tool
- Modification/Deletion of the Database User, that you selected during installation of the Power Tool
Tags: Database User, Hosting Package, Mysql Database, Power Tool, Privilege, Privileges, Web Hosting, Web Hosting package
04 Jul 10 Suspending/Unsuspending a MySQL Database user
You can temporarily disable a particular User’s access to your Database, by Suspending that particular User. Follow the process mentioned below to do so:
1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package.
2. In the search results view, click on the domain name. This will take you to the order details view.
3. Click on Manage Web Hosting Service in the lower toolbar.
4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> List Databases.
5. The following page would contain a list of Databases associated with your website, with complete details for each Database such as the Database name, space utilization and the Users associated with it. Here, click on the User whom you wish to Suspend.
6. In the User details view that follows, click on Suspend. This would disable the User’s access to the Database.
Unsuspending a User: To revoke a User’s Suspension, simply click on Unsuspend in this view.
If you have installed a Power Tool in your Web Hosting Package, then you need to ensure that you do not perform any of the following actions:
- Modification/Deletion of the Database, that you selected during installation of the Power Tool
- Modification/Deletion of the Database User, that you selected during installation of the Power Tool
Tags: 3 Web, Access Database, Control Panel, Database Manager, Database Name, Database User, Databases, Details View, Domain Name, Manage Web Hosting Service, Management Interface, Mysql Database, Power Tool, Space Utilization, View 3, Web Hosting package, Web Hosting Service, Web Service, Website Management
04 Jul 10 Adding MySQL Database Users
If the hosting package that you have purchased from Gossimer contains MySQL Database(s), you can add as many as 100 Database Users cumulatively for all your Databases. Moreover, the distribution of number of Users for each Database is not pre-defined – you can specify how many Users you wish to allow access to a particular Database, as long as the total number of Users is limited to 100.
Follow the process mentioned below to add additional Database Users for your MySQL Database:
1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to read how >>
2. In the search results view, click on the domain name. This will take you to the order details view.
3. Click on Manage Web Hosting Service in the lower toolbar.
4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> Add Database User.
5. On this page, specify the following details
- Database: The name of the Database for which you wish to add this User.
- Database Username: The Username for the User you are creating.
- Password: A password for the User you are creating.
6. There are also some additional details that you can specify; however, they are not essential and can be specified at a later time as well. These are:
I. Hostname details: Specify the hosts from which you wish the User to access this Database. You have 3 options
- Allow connection from any host
- Allow connection only from the same server
- Allow connection only from specific hosts (enter specific hosts here – hosts can be in the form of a hostname, or IP Address).
Reference: Restricting access of a MySQL Database User to allow connection from Specific Hosts only >>
II. Security privileges: Click on the Security Privileges button to specify access rights for that particular Database User. Click on Save Changes to submit the settings.
Reference: Defining Access rights for a MySQL Database User >>
7. Once you have specified all details, click on Submit.
If you have installed a Power Tool in your Web Hosting Package, then you need to ensure that you do not perform any of the following actions:
- Modification/Deletion of the Database, that you selected during installation of the Power Tool
- Modification/Deletion of the Database User, that you selected during installation of the Power Tool
Tags: 3 Web, Access Database, Additional Details, Control Panel, Database Manager, Database User, Database Users, Databases, Details View, Domain Name, Gossimer, Gt 2, Hosts, Manage Web Hosting Service, Management Interface, Mysql Database, Security Privileges, View 3, Web Hosting package, Web Hosting Service, Web Service, Website Management
01 Jul 10 Deleting a MySQL Database User
Follow the process mentioned below to delete an existing Database User:
1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package.
2. In the search results view, click on the domain name. This will take you to the order details view.
3. Click on Manage Web Hosting Service in the lower toolbar.
4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> List Databases.
5. The following page would contain a list of Databases associated with your website, with complete details for each Database such as the Database name, space utilization and the Users associated with it. Here, click on the User whom you wish to delete.
6. In the User details view that follows, click on Delete.
If you have installed a Power Tool in your Web Hosting Package, then you need to ensure that you do not perform any of the following actions:
- Modification/Deletion of the Database, that you selected during installation of the Power Tool
- Modification/Deletion of the Database User, that you selected during installation of the Power Tool
Tags: Control Panel, Database Manager, Database Name, Database User, Databases, Delete, Details View, Domain Name, Manage Web Hosting Service, Management Interface, Mysql Database, Power Tool, Space Utilization, View 3, Web Hosting package, Web Hosting Service, Website Management
Gossimer in the News
- Gossimer Puts Indian Domain Extensions Up for Sale February 21, 2010Gossimer, the fastest growing domain name registration and web hosting company has announced a sale on Indian domain extensions. During the promotion period, domains ending with .in will be offered at discounted price. [PR.com] […]
- Gossimer Unveils a New & Improved Payment System February 14, 2010The Melbourne-based (Florida) web hosting and domain name registration company Gossimer has announced the inclusion of three more payment options in its system. From today the customers and the web hosting resellers can use AlertPay, WebMoney, and Liberty Reserve to pay for the domain registration as well as web hosting services. Gossimer already offered Pay […]
- Gossimer Has Opened Its Treasure Chest for Webhost Resellers January 16, 2010Gossimer, the fast growing domain name registration and web hosting company has yet again opened its door of their reseller program. This program offers a comprehensive web hosting product portfolio for resellers and resellers of Gossimer’s resellers. [PR.com] […]
- Gossimer Invites Customers to Try Digital Certificates for Free January 2, 2010Gossimer, the fastest growing domain name registration and web hosting company is offering 21 days free trial on digital certificates. This trail will allow webmasters to understand the role Https plays in building visitors’ confidence in their website. [PR.com] […]
- Gossimer Announces Special Domain Name Registration Deals December 25, 2009Gossimer, the fastest growing domain name registration and web hosting company has announced a special deal on 12 top domain extensions and that includes some CTLDs as well. This promotion is available on the registration of new domain names, and you can register as many domains as you want. [PR.com] […]
- Gossimer Announced a Transfer-in Domain Promotion to Allow Customers to Consolidate Their Domains Into One Account November 7, 2009Save money on domain name transfer to Gossimer. Gossimer is currently running an attractive promotion on domain transfer-in that will save a lot of money for the domain portfolio builder. You can transfer as many domains as you wish under this promotion. [PR.com] […]
- Gossimer Became Reseller of the Month for October October 17, 2009October brings another piece of good news for Gossimer. The fastest growing web hosting and domain name registration company has been chosen as the Reseller of the month for October by ResellerClub. [PR.com] […]
- Gossimer Offers One Year Free Extension on Domain Transfer October 3, 2009Gossimer, the fastest growing domain name registration company, is offering one year free extension with every domain name transferred to its system. This service when coupled with other services puts Gossimer in the position of price leadership. The company offers the most economic rate for domain name registration and webhosting services. [PR.com] […]
- New Deals Make Gossimer Bigger, Better and Smarter October 2, 2009October is going to be hot with offers, extended support, and enhanced serviceability, as Gossimer has acquired HiTek Networks, and launched new and improved Support desk. The web hosting world is abuzz by the two important developments in Gossimer. [PR.com] […]
- Gossimer Offers Unlimited E-mails for $1 September 28, 2009Gossimer, the fastest growing domain name and webhosting company, has announced a no-upgrade “The Ultimate Email Plan” that will give the buyer an access to unlimited email accounts for just $1/month. [PR.com] […]
Gossimer Promotions and Announcements
- TechSupport Notifications February 28, 2010Technical support information and notifications […]
- PHP4 Discontinuation - 18th September September 7, 2009As announced earlier, PHP4 will not be supported on our Linux Hosting Servers from the 18th of September, 2009. Please pass on this information to your Customers and Resellers to ensure that they can update their websites to work with PHP5. […]
- .CN Launch - Coming Soon August 16, 2009We are glad to announce the launch of .CN - the most popular and fastest growing ccTLD worldwide. The .CN domain extension has seen an exemplary growth since its launch throughout the world. Earlier this year, .CN crossed over 13 million registrations to become the second most registered domain extension after .COM. Moreover, with China now representing the […]
- Live Chat Product Discontinuation - Moved to 18th August August 16, 2009Based on feedback that we received from several Resellers, we have decided to postpone the Live Chat discontinuation to the August of 18th, 2009 at 12:30 UTC. From the 18th of August, it will not be possible to purchase new Live Chat packages but exisiting packages will continue to function normally. […]