RSS Feed
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'...