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: 941
Can I create new databases in phpMyAdmin?
This can be done only through cPanel's Mysql management tool.
Views: 2043
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: 2303
Do you support ODBC for MySQL on Linux?
Unfortunately we do not support the ODBC driver for MySQl on our hosting plans.
Views: 898
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: 974
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: 889
How can I empty a MySQL database?
The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin, select the...
Views: 2025
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: 2202
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: 11191
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: 3857
How to change the MySQL timezone
When you develop your website, you may have to compare a certain date/time with the current...
Views: 1099
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: 2808
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: 1364
How to optimize a MySQL database using phpMyAdmin?
It is always a good idea to keep your databases' tables optimized.Fortunately, making this...
Views: 2651
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: 3671
How to use MySQL stored procedures and routines?
MySQL stored procedures and stored routines are supported after MySQL 5.All CornerNET clients can...
Views: 1083
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: 1558
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: 2628
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: 9967
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: 1000
I have problems accessing my MySQL database remotely
If you have problems accessing your database at your web hosting account remotely please make...
Views: 5214
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: 946
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: 1169
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: 1150
Is SQLite supported?
SQLite is a software library which implements an SQL database engine. SQLite and PDO_SQLite are...
Views: 1881
My application cannot connect to my database.
If your application cannot connect to the database you should make sure that:Your application is...
Views: 4948
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: 3866
What is the information_schema database?
In MySQL version 5.02 and above there is an additional database called information_schema. This...
Views: 3754

Powered by WHMCompleteSolution


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