Knowledge base category
MySQL
69 practical guides in MySQL.
Install MySQL On CentOS 7
MySQL is one of the most popular RDBMS in the market. Follow this tutorial to learn How to install MySQL on the CentOS 7 operating system.
MySQLI get incorrect root password when accessing a MySQL Cpanel feature.
The CPanel needs to know the MySQL root password. To do this you need to edit or create a file in /root called .my.cnf The file should look something like this: [client]...
MySQLWhere can I find more information on MySQL?
Official MySQL site: http://www.mysql.com. Other questions you have can be sent to our support department. We will do our best to answer them.
MySQLHow to Create a DB(DataBase) using the MySQL Database Wizard in cPanel
Login to cPanel and open the MySQL Database Wizard. Enter a name for your database and click the Next Step button: Enter a username, and click the Password Generator...
MySQLMySQL FLUSH Commands.
Flush privileges mysql> FLUSH PRIVILEGES; when we grant some privileges for a user, running the command flush privileges will reloads the grant tables in the mysql...
MySQLHow do I allow remote MySQL connections?
To allow outside hosts to connect to our MySQL servers do the following: Log into your Cpanel control panel at https://:2083/ and go to the MySQL section.
MySQLAllow Remote IP Address to Access MySQL in cPanel Shared Hosting
In order to allow a remote IP address to access the MySQL database, you need to add the Ip address to the remote MySQL access list.
MySQLC.5.2.4. Client does not support authentication protocol with php selector
The error C.5.2.4. Client does not support authentication protocol When using an older PHP version with PHP selector, like 5.2, is due to the version of MySQL not using...
MySQLDEFAULT CHARSET=latin1 or collate latin1_general_ci NOT NULL default or TIMESTAMP errors on importing a database dump
Should you get one of the following errors on importing a MySQL database dump you are most likely dumping from a MySQL 4.1 server to a MySQL 4.0 server.