bspacer1 bspacer2
webmail hosting forum clients about

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
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98
Home PagePortal HomeClient AreaAnnouncementsKnowledgebaseSupport TicketsDownloadsRegister

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: 1024
Can I create new databases in phpMyAdmin?
This can be done only through cPanel's Mysql management tool.
Views: 2132
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: 2387
Do you support ODBC for MySQL on Linux?
Unfortunately we do not support the ODBC driver for MySQl on our hosting plans.
Views: 970
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: 1048
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: 971
How can I empty a MySQL database?
The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin, select the...
Views: 2103
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: 2298
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: 11278
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: 3919
How to change the MySQL timezone
When you develop your website, you may have to compare a certain date/time with the current...
Views: 1181
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: 2916
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: 1444
How to optimize a MySQL database using phpMyAdmin?
It is always a good idea to keep your databases' tables optimized.Fortunately, making this...
Views: 2760
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: 3753
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 MySQL
Regular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE...
Views: 1638
I don't have enough privileges for creating/dropping databases in PhpMyAdmin
Your user does not have enough privileges for creating or dropping databases in PhpMyAdmin...
Views: 2705
I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database
In order to solve this issue follow these steps:Open the MySQL dump with a text editor on your...
Views: 10053
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: 1060
I have problems accessing my MySQL database remotely
If you have problems accessing your database at your web hosting account remotely please make...
Views: 5297
I have problems setting up the MySQL database for my application
If 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 application
There are two main reasons for this error message to show:1) The MySQL query you are trying to...
Views: 1252
I'm getting a 'Server shutdown in progress' MySQL error
There are two main reasons for this error message to show:1) The MySQL query you are trying to...
Views: 1187
Is SQLite supported?
SQLite is a software library which implements an SQL database engine. SQLite and PDO_SQLite are...
Views: 1952
My application cannot connect to my database.
If your application cannot connect to the database you should make sure that:Your application is...
Views: 5025
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: 3947
What is the information_schema database?
In MySQL version 5.02 and above there is an additional database called information_schema. This...
Views: 3821

Powered by WHMCompleteSolution


Copyright © 1994-2021 PJR Sales and Service All Rights Reserved