Knowledgebase
Knowledgebase : Website Hosting > MySQL Databases
Yes, you can access phpMyAdmin directly without accessing control
panel easily, by using your Cpanel Logins. The format is:
https://xx.xxx.xxx.xx:2083/3rdparty/phpMyAdmin/index.php
[https://xx.xxx.xxx.xx:2083/3rdparty/phpMyAdmin/index.php]
Where: xx.xxx.xxx.xx is the server IP address.
No, users are not allowed to install their own versions of phpMyAdmin.
Instead, we offer this program through the CPanel for you to use.
PhpMyAdmin is at the bottom of the MYSQL DATABASES section in the
CPanel.
Login to your Cpanel, then goto --> MYSQL DATABASES --> ADD A NEW
DATABASE, then create a user. Then all you need to do is add the user
into the database. See our CPanel Tutorial
[http://www.fastwebhost.com/tutorials/cpanel_xskin_mysql.htm] for a
visual demo of how to add a database.
We do not allow database connections to mysql server from remote
computers. OUR DATABASE SERVER REMOTE ACCESS PORT IS CLOSED DUE TO
SECURITY REASONS.
So you can't connect from ODBC/JDBC/Macromedia DreamWeaver
applications.
You have to connect your databases from your website through scripts
or cpanel >> phpmyadmin tool for managing your databases.
That's the reason our mysql server name is a...
Your Mysql Hostname is: localhost
MySQL is the most popular Open Source SQL Database system. A database
is a structured collection of data. MySQL allows you to quickly
access, edit and add to the database.
1. Login to your control panel http://yourdomain.com/cpanel
[http://yourdomain.com/cpanel]
2. Click on MySQL databases
3. Scroll to the bottom and click on phpMyAdmin hyperlink
4. Click on the Database you want to restore then click on SQL
5. Click the Browse button and select your .sql file
6. Click 'Go'
It may take long to upload your .sql and populate the DB so a
broadband connection would he...
1) Once you have your sql file you will need to log into your cPanel
2) In the cPanel you will find an Icon labeled MySQL Databases. **If
you have not created the database you will need to do this **
3) At the bottom of the screen in MySQL Databases you will see an
option for PhpMyAdmin, click on this
4) Once in PhpMyAdmin you will see a drop down of your databases on
the left side, select t...
This error means that the script you are running is unable to connect
to the mysql database. This could be for one of several reasons:
1. You did not specify the mysql database OR mysql user within your
script.
2. You did not give the specified mysql user permission to access the
specified database.
3. You did not create the mysql user within cpanel.
4. You did not create the mysql databas...
Removing a database will delete that database ENTIRELY from the
server. Please make sure you have saved a copy of the database if you
want to keep any of the data contained in it.
To remove a database:
Click on the 'Manage Mysql' under the 'database' header in Cpanel.
Click on the DELETE button next to the specific database
All administration of your MySQL databases can be done through our
convenient web based phpMyAdmin interface. This program is provided to
all of our MySQL enabled web hosting customers with. It is available
in your Control Panel.
A user will no longer be able to access a particular database when you
remove their permissions to that database.
To remove a user's permissions:
1. Click on the MySQL database button on the cPanel home page.
2. Click on the Delete button next to the specific user underneath
the name of the database in the Databases area.
Once you have created a user to use a database you need to grant that
user permission to use the database. If you have not yet created a
user, refer to info mentioned below for more information.
To grant user permissions to a MySQL database:
1. Click on the MySQL databases button on the cPanel home page.
2. Choose the specific user from the User drop-down list and the
specific database to gr...
Removing a user deletes that user - it removes all database
permissions that the user has and does not allow that user, access to
any MySQL databases.
To remove a user:
1. Click on the MySQL databases button on the cPanel home page.
2. Click on the Delete button next to the specific user in the Users
area.
The official MySQL documentation can be found at: http://www.mysql.com
[http://www.mysql.com/]
Other useful information about MySQL may be found at the following
locations:
http://mysql.turbolift.com/ [http://mysql.turbolift.com/]
http://www.devshed.com/ [http://www.devshed.com/]
While accessing a mysql database if you get the error " mysql 145
error " then you need to repair the database as follows:
Go to Cpanel ==> Databases ==> Mysql databases ==> Modify Databases
==> select the database with which you are facing a problem and click
on Repair DB
There are two different ways to connect to a MySQL database. Locally
(from a script on the server, to the server), and Remotely (from a
remote computer, using Shell, ODBC, or Navicat)
Locally, the settings are:
Hostname: localhost
Username: username_dbuser
Password: dbpassword
db_name: username_dbname
db_table: dbname_table
Remotely, the settings are the same, but you must use yourdomain....
IT IS STRONGLY RECOMMENDED THAT YOU BACKUP YOUR DATABASE AT REGULAR
INTERVALS AND BEFORE AN UPGRADE.
BACKUP USING CPANEL X
cPanel is a popular control panel used by many web host. The backup
feature can be used to backup your MySql database. Do not generate a
full backup, as these are strictly for archival purposes and cannot be
restored via cPanel. Look for 'Download a MySQL Database Backup'...
Help Desk Software by Kayako