RSS Feed
Knowledgebase : MySQL
     
INTRO TO CPANEL MYSQL DATABASES Each database you use on your account needs to have a distinct name. Each database you connect to needs a database username assigned to the database so your scripts/website can connect to it. For this document, we'll a...
You can change the collation of a MySQL database by using phpMyAdmin: * Log into cPanel [1] * Click PHPMyAdmin, from the Databases section ​ * In the Recent Tables menu in the left sidebar, click the name of the database you want to man...
By FAR the most common problem in connecting to your database [1] is because you are using an incorrect username and/or password. Make sure the username you use matches the username created in the MySQL Database section of your cPanel. MYSQL ERROR EX...
In order for your MySQL database to work as intended, it will need a script calling or querying the database for the information it stores. In order to do this, you must connect your script to the database with a configuration file. CONFIGURATION SET...
Let's say you're developing a script on your PC at home, and you need to connect to your database remotely using a MySQL admin program. No problem. This procedure is a little quirky, but here are the steps to grant remote access to your database. _NOTE...
EXPORT A DATABASE VIA CPANEL To export a MySQL database via cPanel: * Log into cPanel [1] * Click phpMyAdmin from the Databases section ​ * From the left-hand sidebar click the name of the database you want to export * Click t...
This can be used to back up a database. 1. Export A MySQL Database This example shows you how to export a database. It is a good idea to export your data often as a backup. # mysqldump -u username -ppassword database_name > FILE.sql Replace...
Using MySQL A full guide can be found at http://www.cpanel.net/docs/cp/MySQL.htm SQL stands for Structured Query Language. SQL is a international standard in querying and retrieving information from databases. mySQL is essentially an SQL server - it ...
mysql -u DBUSER -pDBPASS DBNAME < dump.sql Replace text in uppercase with the appropriate information: * DBUSER - Database user with privileges to the database * DBPASS - Password for the database user * DBNAME - Database name ...
INSTALL GHOST WITH SOFTACULOUS If you want to install a fresh instance of Ghost on your cPanel account you can do so very easily with Softaculous [https://kb.hostnine.com/customer/portal/articles/2022411]. Softaculous is an auto-installer for cPanel that...
phpMyAdmin is a software tool, written in PHP, intended to handle the administration of MySQL via web browser. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations (managing databases, tables, fields, relati...
The easiest way to achieve merging two MySQL databases is to essentially copy data from a table to another table and back again. Both databases need to exist on the same account. If they do not, you will need to create a backup of one and move it ov...
Help Desk Software by Kayako fusion