How to Find Out Where Your SQL is Hosted

Last Updated on Saturday, 11 May 2013 06:14 Written by Andrew Cross Monday, 13 May 2013 12:00

Do you require a script to install a database for you?

Are you faced with a problem of knowing it location?

Here is a quick guide on how to find the location of your SQL Database.

This Guide is based around CPanel but the instruction are very much the same for other Control Panels.

How to Manage MySQL Databases Remotely

Last Updated on Thursday, 18 April 2013 02:34 Written by Anand Narayanaswamy Wednesday, 24 April 2013 12:00

It is possible to manage MySQL databases using PHPMyAdmin but it has limitations. You will not be able to execute huge databases since it will cause timeouts. Hence, it is advisable to make use of remote MySQL client software such as SQLyog.

With the help of SQLyog, you will be able to execute and manage MySQL databases from within your computer.

For Linux hosting, you should first add your IP address by following the steps below

How to Optimize a MySQL Database in cPanel

Last Updated on Sunday, 20 November 2011 12:43 Written by Arian Jahansouz Friday, 23 July 2010 01:03

Related documents:
1. How to Create a Database and User for MySQL in cPanel
2. How to Add Databases and Users Using MySQL Wizard in cPanel
3. How to Allow Remote Access to a MySQL Database in cPanel
4. How to Change the Password of a MySQL User in the cPanel

This article will give you a step by step guide on how to optimize a MySQL database’s tables in the cPanel.

Sign into your cPanel and follow these steps:

1) Scroll down to Databases and click phpMyAdmin

How to Change the Password of a MySQL User in the cPanel

Last Updated on Sunday, 20 November 2011 06:32 Written by Arian Jahansouz Wednesday, 7 July 2010 10:38

Related documents:
1. How to Create a Database and User for MySQL in cPanel
2. How to Add Databases and Users Using MySQL Wizard in cPanel
3. How to Allow Remote Access to a MySQL Database in cPanel
4. How to Optimize a MySQL Database in cPanel

This article will give you a step by step guide on how to change the password of a MySQL user in the cPanel.

Sign into your cPanel and follow these steps:

1) Scroll down to Databases and click MySQL Databases

How to Create a Database and User for MySQL in cPanel

Last Updated on Sunday, 27 November 2011 02:31 Written by Arian Jahansouz Friday, 25 June 2010 11:50

Related documents:
1. How to Add Databases and Users Using MySQL Wizard in cPanel
2. How to Allow Remote Access to a MySQL Database in cPanel
3. How to Change the Password of a MySQL User in the cPanel
4. How to Optimize a MySQL Database in cPanel

This article will give you a step by step guide on how to create a new database and a new user for MySQL.

Sign into your cPanel and follow these steps:

1) Scroll down to Databases and click MySQL Databases