RSS Feed
Knowledgebase : MySQL
     
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...
To import a mySQL database into your site: * Log into cPanel [https://support.seohosting.com/index.php?/Knowledgebase/Article/View/76/0/accessing-your-cpanel-account] * From the Databases section click phpMyAdmin * Click Import, from the top navig...
Improving Magento performance is at the top of the list for most professional Magento developers. There's no doubt that enhancing the speed at which Magento performs can only be good for business. One of the most important enhancements you can make ...
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, rela...
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...
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 EXA...
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 deve...
Help Desk Software by Kayako fusion