RSS Feed
Knowledgebase : MySQL
     
You can change the collation of a MySQL database by using phpMyAdmin: * Log into cPanel [https://kb.asmallorange.com/customer/portal/articles/1603418] * Click PHPMyAdmin, from the Databases section * In the Recent Tables menu in the left sid...
If you are having SQL connection errors, please make sure you have followed the instructions in our C [http://support.hostgator.com/articles/cpanel/how-to-connect-to-the-mysql-database-remotely]onnect to Your Database Remotely article [https://kb.asmallor...
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 SETTIN...
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: ...
If CPANEL IS DISPLAYING THE WRONG VERSION OF MYSQL you'll need to access the filesystem for that particular user and remove/rename a file or two... * If cPanel is displaying the wrong version of MySQL, you'll need to: cd /home/cpanelusername/.cpane...
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: i...
EXPORT A DATABASE VIA CPANEL To export a MySQL database via cPanel: * Log into cPanel [https://kb.asmallorange.com/customer/portal/articles/1603418] * Click phpMyAdmin from the Databases section * From the left-hand sidebar click the name o...
To import a mySQL database into your site: * Log into cPanel [https://kb.asmallorange.com/customer/portal/articles/1603418] * From the Databases section click phpMyAdmin * Click Import, from the top navigation menu * In the File to Imp...
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.asmallorange.com/customer/portal/articles/1603142]. Softaculous is an auto-installer for cPanel ...
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, relations,...
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 over t...
MySQL [http://en.wikipedia.org/wiki/MySQL] is the world's most widely used open-source relational database management system that runs as a server providing multi-user access to a number of databases. It is named after co-founder Michael Widenius's daught...
MYSQL QUERY BROWSER is an alternative to phpMyAdmin when it comes to managing your MySQL databases. You can use it to create, drop, and edit tables and perform queries. Setting up MySQL Query Browser to work with your account is relatively simple. PREPA...
You've got a working forum with users, but you want to set up a test forum to try out some changes without messing it up for everyone. Here's a quick step-by-step guide: * Log into cPanel * ​Navigate to and click into MySQL Databases and create...
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 assume you have the domain name EXAMPL...
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 assume you have the domain name EXAMPL...
SQL injection is an attack where malicious code is passed to an SQL Server for execution. The attack can result in unauthorized access to confidential data, or destruction of critical data. SQL injection attacks should only be a concern for PHP develope...
Help Desk Software by Kayako fusion