BuycPanel Blog

BuycPanel Blog

Latest news and updates

Advanced cPanel Tips and Tricks

Posted by Jamison on 22 12 2016.

In your cPanel account, you will find a section called “Databases.” They provide users with means to easily manage huge amounts of data via the Internet. You need these databases to execute many applications requiring the use of the Internet, such as online retail shops, bulletin boards, and content management systems.

 

There are several features under the Databases section, including the following:

 

MySQL Databases – x3

 

Thanks to this interface, you can easily create, delete, and configure MySQL® databases as well as your MySQL database users. Keep in mind though, that you should never use phpMyAdmin when creating databases or users for them.

 

Use the MySQL Database Wizard – x3 interface when you want to generate your first ever database and database user. The database name should only have 64 characters or less. Know though, that the character underscore (_) consumes two characters already.

 

MySQL Database Wizard – x3

 

Use this wizard and you will have…

In your cPanel account, you will find a section called “Databases.” They provide users with means to easily manage huge amounts of data via the Internet. You need these databases to execute many applications requiring the use of the Internet, such as online retail shops, bulletin boards, and content management systems.

 

There are several features under the Databases section, including the following:

 

MySQL Databases – x3

 

Thanks to this interface, you can easily create, delete, and configure MySQL® databases as well as your MySQL database users. Keep in mind though, that you should never use phpMyAdmin when creating databases or users for them.

 

Use the MySQL Database Wizard – x3 interface when you want to generate your first ever database and database user. The database name should only have 64 characters or less. Know though, that the character underscore (_) consumes two characters already.

 

MySQL Database Wizard – x3

 

Use this wizard and you will have an easier time setting up and configuring MySQL databases, privileges, and requisite accounts. When creating your first ever database and database user, you should use this tool to make things a lot easier.

 

You can also use it when you want to generate more databases and database users. You will find it under the MySQL Databases – x3 interface.

 

phpMyAdmin

 

A third-party tool allowing you to manipulate and control MYSQL databases, phpMyAdmin can be quite useful.

 

PostgreSQL Databases – x3

 

Through this interface, you can manage all your PostgreSQL® databases as well as database users. You can create, delete, manage, and configure PostgreSQL® databases and users through this interface too. Never use phpPgAdmin when creating databases or users.

 

When you already want to generate your first PostgreSQL® database or PostgreSQL® database user, take advantage of the the PostgreSQL Database Wizard – x3 interface. Also, keep in mind that you can only use up to 63 characters when naming a database.

 

PostgreSQL Database Wizard – x3

 

As mentioned above, this is the tool you should use when creating your first ever PostgreSQL® databases and PostgreSQL® database users. The PostgreSQL® Database Wizard contains directions on how you can create a PostgreSQL database, privileges, and requisite accounts, making it far easier and convenient for you.

 

To generate more PostgreSQL databases or PostgreSQL users, you can use the same tool, which you will find under the PostgreSQL Databases – x3 interface.

 

phpPgAdmin

 

Like the phpMyAdmin, the phpPgAdmin is also a third-party program allowing you to control PostgreSQL databases.

 

Keep in mind though, that some PostgreSQL versions are ANSI SQL-92 compliant, which means that they may not support wildcard grants, future grants, or recursive grants.

 

In the event you want some other users to have access to your PostgreSQL tables, go to the PostgreSQL Databases interface and then choose the Synchronize Grants option right after adding a table.

 

Remote MySQL – x3

 

Use this interface to set up how you want your other web servers to remotely access your databases. When you want to have a guestbook applications, shopping cart, or other similar services on your website, you will find this interface useful.