You can change the collation of a MySQL database by using phpMyAdmin:
*
Log into cPanel
[https://help.asmallorange.com/index.php?/Knowledgebase/Article/View/14/10/accessing-your-cpanel-account]
*
Click PHPMYADMIN from the Databases section
*
...
If you are having SQL connection errors, please make sure you have
followed the instructions in our Connect to Your Database Remotely
article
[https://help.asmallorange.com/index.php?/Knowledgebase/Article/View/513/11/connect-to-your-database-remotely].
...
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/.cpanel...
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://help.asmallorange.com/index.php?/Knowledgebase/Article/View/14/10/accessing-your-cpanel-account]
*
Click PHPMYADMIN from the Databases section
*
...
To import a mySQL database into your site:
*
Log into cPanel
[https://help.asmallorange.com/index.php?/Knowledgebase/Article/View/14/10/accessing-your-cpanel-account]
*
From the Databases section click PHPMYADMIN
*
Click IMPORT from the to...
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://help.asmallorange.com/index.php?/Knowledgebase/Article/View/231/19/softaculous-overview].
Softaculo...
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
[https://help.asmallorange.com/index.php?/Knowledgebase/Arti...
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