Why neither dbs nor users are created under my end-user accounts?

If you have two *SQL logical servers available for signup, then the servers for dbs/logins/users creation are chosen by randomize. Imagine wwwuser creates database A and A1 and A2 users and they all go to sql1.mydomain.com. Then even if you prohibit it for signup, the system will still try to create new dbs and db users of wwwuser on sql1.mydomain.com. And as the signup is turned off on it, neither dbs nor users for this db will be created.

I have suspended my master admin account. How do I resume it?

Log into your H-Sphere database and run the command:
update accounts set suspended=null where id=1;
Then restart H-Sphere.

Hi,

How can I Create MySQL Database and Its Users ?

MySQL users cannot exist separately from MySQL databases. You must stick to the following sequence:

1. Create a database
2. Add MySQL users to each created database.

However, MySQL users can be shared by different databases.

To create a MySQL database, do the following:

1. Click MySQL Server on your control panel home page.
2. Click Add database at the bottom of the form:
3. On the form that shows enter the name of the database and database description if needed
4. agree with additional charges if any.
5. In the form that appears, create a new user or grant privileges to users of other databases:

* Add a new user to the database you have just created.
* Choose roles for users of other databases so they can use your new database.

6. Click Finish to complete creating your MySQL database.

Editing MySQL databases (phpMyAdmin)

You can edit the content of your databases using the phpMyAdmin utility that comes with your control panel. To run phpMyAdmin, do the following:

1. Click MySQL Server on your control panel home page.
2. In the form that appears, click the name of the existing MySQL Database you want to edit or the Edit icon on its right:
3. In the form that appears, click Built in phpMyAdmin control panel to start editing your database
4. Follow the instructions of the phpMyAdmin control panel to edit your MySQL DB.

Hi

I want to change my MySQL disk quota. How can i do it?

To change MySQL disk quota, do the following:

1. Click MySQL Server on your control panel home page.
2. Click the MySQL Database or the Edit icon on its right:
3. Click the Change button against the Quota field:
4. Enter the new quota.
5. Click Submit.
6. Agree to additional charges.

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.