 |
|
||||||||
 |
 |
 |
|
||||||
|
Computer Co-op, CornerNET Internet Gateway, and PJR Solutions
is owned by PJR Sales & Service.
Quality products and
online services since 1991. We can be your |
|||||||||
 |
Hosting @ $5.95 Domains @ $16.98 |
||||||||
| Home Page | Portal Home | Client Area | Announcements | Knowledgebase | Support Tickets | Downloads | Register |
Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues
The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.
Articles
Can I change the name of a MySQL database?The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...
Views: 1025
Can I create new databases in phpMyAdmin?This can be done only through cPanel's Mysql management tool.
Views: 2133
Can I use phpMyAdmin outside cPanel?The phpMyAdmin tool available in cPanel is bundled with it and can be used only if you are...
Views: 2388
Do you support ODBC for MySQL on Linux?Unfortunately we do not support the ODBC driver for MySQl on our hosting plans.
Views: 971
How can I change my MySQL database collation?Usually you will be interested in changing your MySQL collation in order to solve problems with...
Views: 1049
How can I configure DreamWeaver to connect to MySQL database?Select Window -> Database to open up Database property window:Click on "+" sign and choose...
Views: 972
How can I empty a MySQL database?The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin, select the...
Views: 2104
How can I find the MySQL details of an application (Joomla for example) installed through QuickInstall?You can find all the mysql details of an application in its configuration files. The same is...
Views: 2299
How can I import a large database to my account? PhpMyAdmin times out.For importing large databases we recommend using tools such as MySQL Query Browser or...
Views: 11279
How do I use a PHP script for MySQL database import?You should start by creating a file called for example import.php and placing it in your...
Views: 3921
How to change the MySQL timezoneWhen you develop your website, you may have to compare a certain date/time with the current...
Views: 1182
How to change the database engine of a MySQL database table?In this article we will show you how to change the database engine of a MySQL table.Let's assume...
Views: 2917
How to export a large database using phpMyAdmin?If you have a large database, it may be difficult to export all of its tables at once through...
Views: 1445
How to optimize a MySQL database using phpMyAdmin?It is always a good idea to keep your databases' tables optimized.Fortunately, making this...
Views: 2762
How to repair a MySQL database?In this article we will show you two ways to repair a MySQL database. 1) Through cPanel: Log...
Views: 3754
How to use MySQL stored procedures and routines?MySQL stored procedures and stored routines are supported after MySQL 5.All CornerNET clients can...
Views: 1153
I cannot create views in MySQLRegular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE...
Views: 1639
I don't have enough privileges for creating/dropping databases in PhpMyAdminYour user does not have enough privileges for creating or dropping databases in PhpMyAdmin...
Views: 2706
I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a databaseIn order to solve this issue follow these steps:Open the MySQL dump with a text editor on your...
Views: 10054
I get syntax error when trying to run a MySQL query.This error indicates that the syntax of your query is not correct. Reasons for incorrect mysql...
Views: 1061
I have problems accessing my MySQL database remotelyIf you have problems accessing your database at your web hosting account remotely please make...
Views: 5298
I have problems setting up the MySQL database for my applicationIf you have problems setting up the mysql database for your application please make sure...
Views: 1016
I'm getting a 'MySQL server has gone away' error in my applicationThere are two main reasons for this error message to show:1) The MySQL query you are trying to...
Views: 1254
I'm getting a 'Server shutdown in progress' MySQL errorThere are two main reasons for this error message to show:1) The MySQL query you are trying to...
Views: 1188
Is SQLite supported?SQLite is a software library which implements an SQL database engine. SQLite and PDO_SQLite are...
Views: 1953
My application cannot connect to my database.If your application cannot connect to the database you should make sure that:Your application is...
Views: 5027
What is the default path to the MySQL binary?The correct path to the MySQL binary at all CornerNET's servers is:/usr/bin/mysql
Views: 3948
What is the information_schema database?In MySQL version 5.02 and above there is an additional database called information_schema. This...
Views: 3823
Powered by WHMCompleteSolution