How to change collation for particular tables in cPanel?
MySQL enables you to store and process data in a wide variety of languages using various character sets. For some operations, such as comparing two strings, MySQL uses a set of rules to…
Tag:
Database
52 Articles
52
How to allow Remote MySQL connection in WHM?
Steps to allow Remote MySQL connection in WHM To prevent potential security risks to MySQL server, by default remote MySQL connections are disabled in cPanel servers. Remote MySQL connections can be allowed either…
How to Add Access Host in cPanel?
Add Access Host in cPanel cPanel allows remote servers or web application to access a database hosted on your account. If a server or web application tries to access the database on your…
How to Remove Access Host in cPanel?
Remove Access Host in cPanel The cPanel allows remote servers or web application to access a database hosted on your account. If a server or web application tries to access the database on…
How to manage a database with phpMyAdmin?
The phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Databases must be created in cPanel, but phpMyAdmin can drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage…