Quick Jump Menu
Categories
There are no subcategories in this category.
31 PHPMyAdmin Error #1045 Cannot log in to the MySQL server

This is a known cPanel bug if you are accessing the cPanel using the cPanel proxy (eg http://cpanel.yourdomain.com). Please use http://yourdomain.com:2082 (replacing youromain.com with your actual domain name ! ) to access cPanel to remove this error Note…

32 Remote Mysql Connections

Remote / External connections to mysql are permitted on premium hosting. In order to make a remote connection please follow the following procedure : 1) Log into your cPanel 2) Click on 'Remote Mysql' 3) In this screen enter the ip address of the server that…

33 Setting a Cron Job to do a MySQL Database Backup

In order to do a backup of your database through a cron job, you can set this up in cPanel. Navigate to cPanel >> Advanced >> Cron Jobs. You can select the backup frequency that you need then enter the command to backup. Here is a sample cron…

34 What are MySQL triggers and how to use them?

The MySQL trigger is a database object that is associated with a table. It will be activated when a defined action is executed for the table. The trigger can be executed when you run one of the following MySQL statements on the table: INSERT, UPDATE and DELETE.…

35 What are the name servers to use

Once you have registered an account with us you will receive an email including all of your account information, this will include your allocated nameservers to use. If you have any issues or questions regarding setting up your nameservers for your domain…

36 What is the default path to the MySQL binary?

The correct path to the MySQL binary at all our servers is: /usr/bin/mysql

37 What is the information_schema database?

In MySQL version 5.02++ there is an additional database called information_schema. This database is available inside the cPanel -> phpMyAdmin tool and provides access to the database metadata for the corresponding user. information_schema is the database…