Hello,
How To change user password in the MySQL database ?

To change user password in the MySQL database, do the following:

1. Click the MySQL Database
2. In the form that appears (see above), click the Change password icon next to the DB user.

I want to Add MySQL users and grant them privileges.

Plz. help me for this.

Here you will learn how to add new users to an existing MySQL database.

1. Click MySQL Server on your control panel home page.
2. Click the MySQL Database or the Edit icon on its right:
3. On the form that shows, click the Add icon against the Database users field.
4. Fill the form:
Each user role involves a fixed set of privileges on this specific database:
5. Click the Add or Grant button and agree to additional charges.
6. To edit privileges, click the Edit icon next to the user. You will be brought to the Privilege Maintenance page.
7.Check or uncheck the desired privileges and press the Submit button.

I have created a reseller account, logged in, but can’t enter admin cp.

Make sure:
– you have configured DNS for resellers
– you are using a registered domain.
If you need to use an unregistered domain for your own use only, add this domain to your hosts file (/etc/hosts on *nix systems).

I have purchase a Reseller web hosting account from cpwebhosting.net and start my own web hosting company. Is there a way to remove “H-Sphere” name from the title bar and replace it with my own company name?

To remove “H-Sphere” name from the title bar do the following:-

1) Under root, login as cpanel superuser:
# su – cpanel
To implement customization correctly, all template files and directories should have cpanel:cpanel ownership, and the make directive (see no. 7 below) should be run ONLY under the cpanel user.
2) Copy the top.html.in template from ~cpanel/shiva/shiva-templates/common/design/ directory to the custom template location (e.g.: ~cpanel/shiva/custom/templates/common/design/).
3) In the <title> tag, replace “H-Sphere” with the name you need. You can also replace it with the company name variable used in the system: ${settings.name}
4) If necessary, repeat steps 1 and 2 for other design locations (e.g. nomenu and textbased).
5) Open file ~cpanel/shiva/psoft_config/hsphere.properties and check the USER_TEMPLATE_PATH variable. It must be uncommented and contain the correct location for your custom templates.
6) Change directory to shiva-templates/ and run ./configure
7) Run make
If the changes haven’t taken effect, restart H-Sphere.
More on Template Customization.

In H-Sphere Where can I set up address for users to send checks?

This is available from the Look And Feel -> Misc. Texts menu.

I m a Reseller web host and I want to give good services to my clients. How can I make sure that I am notified when a user gets a system error?

Set up Critical Error mailing list in Settings->Mail Settings menu

I m a Reseller web host.How do I know that a new user has signed up?

You can set to receive copies of notification e-mails by setting up SIGNUP mailing list in Settings->Mail Settings menu.

I m a Reseller web host.How do I obtain my customers’ credit card numbers?

You need to run the following query against the H-Sphere database:

select cc_number, name, exp_year, exp_month, type from credit_card where id=(select bi_id from accounts where id=account_id)
Don’t forget to replace user_id with the ID of a real account.

Is there a way to disable billing for H-Sphere?

In the admin control panel, click settings for the plan to disable billing for. There, switch billing OFF.

What happens if I switch Billing off?

H-Sphere will not ask for any billing information such as credit card for this plan. It will also stop charging any money for the plan. Billing should be switched off only for administrative plans.

Hi,
I m a Reseller web host. I want to accept only checks from my clients so How do I disable credit card payments?

Don’t create any merchant gateways for any credit card brands. This will disable credit card option at signup.