Knowledgebase
Portal Home > Knowledgebase > PHP/MySQL
The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.
Search
Articles
How can I access mysql database remotely?
Under the mysql header in Cpanel, select 'manage mysql'Then scroll down to the 'access...
Views: 1175
How can I change my MySQL database collation ?
In order to solve problems with foreign character encodings, you will need to change your MySQL...
Views: 1252
How can I create a database from an sql backup file ?
First, create the database../path/to/bin/mysqladmin -u $mysqlusername -p$mysqlpassword create...
Views: 1149
How can I empty MySQL database?
Login to cPanel, got to phpMyAdmin and select the database you wish to empty. It will list all...
Views: 1122
How do I delete a MYSQL database?
Removing a database will delete that database ENTIRELY from the server. Please make sure you have...
Views: 1125
How do I restore a database using PHPMyadmin?
You can restore a database backup in PHPMyadmin by doing the following:1) After entering...
Views: 1129
How to create a new MySQL database ?
1. Go to your Cpanel >> Databases >> MySql Databases.2. Enter the database name under...
Views: 1138
How to find MySQL details of an application installed through Fantastico?
MySQL details of an application can be found in its configuration file and it is the same for all...
Views: 1127
What is the default mysql port?
3306 is the default mysql port.
Views: 1108
What is the default path to the MySQL binary?
The default path to the MySQL binary at all SiteGround servers is :/usr/bin/mysql
Views: 1297
What is the information_schema database?
MySQL versions 5.02 and above consist of an additional database called information_schema. It...
Views: 1250
Powered by WHMCompleteSolution