RSS Feed
Knowledgebase : Database > MySQL
This article describes how to use phpMyAdmin to change the collation settings for MySQL databases and tables. ABOUT CHARACTER SETS AND COLLATION MySQL enables you to store and process data in a wide variety of languages using various character sets. Fo...
There are several ways to check the version of the MySQL service on your account. The first one is via a PHP script. You have to create a new file on your account, for example mysql.php, and inside it place the following: 1 2 3 4 5 6 7 8 9 10...
- First, log into your Control Panel. - Then click on Databases. - Enter a database name and press Add. - Then enter a username and password for the database and press Update. Your connection is localhost and the username and passwords are what yo...
This tutorial assumes that you have already created a database. If you have not, you will need to do so first. To import a database into an existing database (.sql file) in cPanel using phpmyadmin follow the steps below. * Log into your cPanel account...
You can log into your CONTROL PANEL --> click on your DOMAIN NAME --> click on DATABASES --> click on the DATABASE YOU WANT TO MANAGE ---> click on the PHPMYADMIN button (this is your online administration tool).
MySQL database size limitations are applied for all shared hosting plans, in order to ensure fair resource usage. The limitation is 1GB. If a database on your account has exceeded the database size limitation (or it is getting close to reaching the limi...
It's very easy to rename a table in phpMyAdmin. To do so, simply follow these steps: * Log in to cPanel. * From the DATABASES section, click on the PHPMYADMIN icon. * In the narrow left column, select the database containing the table you wis...
STEP 1: BACKING UP THE DATABASES Before you attempt to repair any database, you should back it up first. To back up all of the files from all of your databases, follow these steps: * Log in to your server using SSH. * Stop the MySQL server using th...
Using SSH can be a superior way to manage the files and databases on your account. Using a simple command you can import or export a MySQL database into an existing database on your account. Please note that in the examples below the -P will prompt for ...
This article describes a problem that occurs after a server is upgraded to MySQL 5.6.5 or later, and how to resolve it. PROBLEM When you try to access a database on a server running MySQL 5.6.5 or later the login fails, even though you are using the co...
ATTENTION: All Shared Hosting servers Due to security reasons, we have disabled the remote access to our MySQL database servers in all our Shared Servers. ALTERNATIVE SOLUTIONS: a) Manage via PHPMYADMIN within your hosting Control Panel. Log into yo...
Since our shared hosting servers do not allow remote mySQL via port 3306 due to security reasons, you can use a different method in order to achieve the same result. The said method can be reached by using the http tunneling. In order to do this, you wil...
MySQL is the database engine we use for our Linux hosting accounts. It allows you to store records, files, pictures in an ordered fashion so they may be called up within your website.
Please contact Support team as soon as possible, as there is a badly written script and it is over-utilizing open connections to the database servers. Make sure you are supplying a username and password to the database server, otherwise it will connect ...
Copyright © 1998 - 2018 Shinjiru International Inc. All Rights Reserved.