Knowledgebase
Pre-sales Questions (22)
Getting Started (18)
Upgrade or Downgrade (4)
Billing Info (20)
Our Policies (11)
Domains & DNS (38)
Site Functions (21)
Domain Resellers (17)
Dedicated & Virtual Private Servers (13)
Email (34)
Third-Party Software (26)
Security (6)
Hosting (9)
Abuse (7)
cPanel (9)
Ruby on Rails (9)
FTP Access (7)
MySQL (12)
PHP and Apache (10)
SSL Certs and IP Addresses (11)
Magento (8)
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...
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...
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/...
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...
First, create the database..
/path/to/bin/mysqladmin -u $mysqlusername -p$mysqlpassword create
$mysqldatabasename
Then, add user permission to it..
/path/to/bin/mysqladmin -u usernamehere -ppasshere create
databasename
Finally, add the tables back...
mysqldump -u DBUSER -pDBPASS DBNAME > dump.sql
Replace the text in the uppercase letters with the appropriate
information:
* DBUSER - Database user with privileges to the database
* DBPASS - Password for the database user
* DBNAME - Database ...
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
...
It's easy to learn how to manage MySQL databases with phpMyAdmin.
Let's get started:
* Log in to your cPanel account [1]
* Click PHPMyAdmin in the Databases section
* Click Test in the left-hand side of your screen in the gray shaded
area
...
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...
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
daughter, My. The SQL phrase stands for ...
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.
PR...
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