SpeedHost.in Blog Hosted on WordPress

SpeedHost.in allows a maximum of 20 simultaneous MySQL connections. This limit is per cPanel account.

The 20 simultaneous database connections should be sufficient. Most database connections open and close within a fraction of a second. Example: A forum with 400 active members will rarely hit this 20 simultaneous connections.

If a website does cross the limit, they will see a Service Temporarily Unavailable page. The SQL server will timeout after 15 to 30 seconds of inactivity.

This article will help you connect to your MySql database remotely.

Configuration Settings:
Host = (use the server IP address) (For server IP, please check your New Account Information email)
Database name = (cpanelusername_databasename)
Database username = (cpanelusername_databaseuser)
Database password = (******)
MySQL Connection Port = 3306
TCP or UDP, either is fine.

Before you can connect to MySQL from another computer, you must enable your computer as an Access Host. It may sound confusing, but cPanel makes this very simple.

1. Login to cPanel and click the Remote MySQL icon, under Databases.
2. Type in the connecting IP address, and click the Add Host button.
3. All done, try connecting remotely.

How can I find out my computers IP address?
Simple, just go to http://whatismyipaddress.com/

But, What if my IP constantly changes?

Okay, you have a dynamic IP address. Therefore, every time you go online, or every once in awhile, your IP changes. You have a few options here. The most secure, would be to update your IP in Remote MySQL every time your IP changes. However, you do have other options available. You could simply enter % (a percentage sign) in the Add Access Hosts text field. This will allow any IP to remotely connect to your databases. Another option: Lets say the first two parts of your IP never change. Then, you could enter 93.138.%.% , where the first two parts are your actual IP address numbers.

Related Article:
1. What is my Database Name and Host Name?
2. How do i create a MySQL database?

Yes, pdo or pdo_mysql is compatible with our servers. We also allow stored procedures, but you will not be able to write them yourself.

Please email us with your request, and our server administrators will help you add these procedures.

If you are using a PHP or Perl script that connects to a MySQL database, you may need to specify your database name and database host name.

Configuration Settings:

Host = localhost
Database name = (cpanelusername_databasename)
Database username = (cpanelusername_databaseusername)
Database password = (******)

Note:
It is possible for someone to use their cPanel username and password to connect to the database. However, we NEVER recommend doing this because the first time you change or reset your cPanel password, then your databases will stop working.

Create: If you are using any type of PHP software or keeping a collection of records which need to be accessed in some way, you will need to create a database. Below will show you how to create a MySQL database in cpanel.

1. Click MySQL Databases
2. In the box to the right of New Database, please provide a name for the database. Please note cPanel will create the full name of the database as cpaneluser_databasename
3. Click Create Database Button
You have now successfully add the database, You will now need to create a user to access the database.

Create User: Whenever you have any type of MySQL database, you will need to assign a user to be able to access the database. If you would like to create a user and give them access to the database, please do the following:

1. Click MySQL Databases
2. Scroll down until you see the Current Users section
3. Under this section and to the right of User name, please provide a user name for a database
4. Please note that that full database user will be cpaneluser_databaseuser
5. To the right of Password, please type the password for which you would like to create for this database user.
6. Click Create User

You have now created a database user. You can manage it from PhpMyAdmin, found in the Databases section in cPanel.

You now need to give the user privileges for your specified database.

1. In the drop down menu to the right of User, please sect the user for which you would like give privileges to.
2. To the right of Database, please select a database for which you would like the user to have privileges to.
3. Under privileges please choose what type of privileges you would like the user to have.
4. Click Add User To Database button You have now created a new database with a privileged user. You can now input the information into a php script or another script to access it locally
You have now just gave a user permissions to a database.

Delete: If you are deleting a script or would like to restart a new database, the first step is to delete the old MySQL database. To do so, please do the following:

1. Click MySQL Databases
2. Under Current Databases, you will find the names of all your current databases.
3. Click Delete next to the name of the database you would like to delete.
4. You have now deleted a MySQL Database.

Note: You may also need to delete the user who is accessing the database as well, if you would like not to have any further traces of the that database lingering.