• Home » kb
  • In this tutorial, we can learn how to resolve this issue: check_mysql has determined that there are corrupted database tables (eximstats) Error "check_mysql has determined that there are corrupted database tablescPanel & WHM has determined that the following database tables are corrupt:Database Erroreximstats error : Record at pos: 26819502 is not remove-markederror : record delete-link-chain corruptederror : Corrupterror : record delete-link-chain corrupted   [...]

    Read More

    How to Enable Remote MySQL Connection in WHM?

    Posted at April 16, 2017 at 9:46 pm by Jithin

    By default, remote MySQL connections are disabled for all cPanel servers. The server hosted with large websites faces a big issue that because MySQL consumes large amount of resources. This will lead to high server load and always slow down the server. So, the best option is to setup a remote MySQL connection. It will randomly reduce the MySQL resource usage. We can enable this feature in WHM. To enable remote MySQL connection in WHM, please follow the below given steps. Steps to en   [...]

    Read More

    Size of MySQL Databases Shown as 0MB in cPanel

    Posted at April 16, 2017 at 9:41 pm by Jithin

    Sometimes, when you log into cPanel, you’ll see non-empty MySQL databases showing 0MB as its size. Those databases actually contain tables and details, but the size is always shown as 0MB.  Steps to fix this issue from command line1) Logon to server using SSH.2) Reset the value of disk_usage_include_sqldbs from 0 to 1 in cPanel configuration file. # vi /var/cpanel/cpanel.configdisk_usage_include_sqldbs=1 3) Run the script below to update the database cac   [...]

    Read More

    MediaWiki Installation on cPanel Server

    Posted at February 27, 2017 at 6:41 pm by Jithin

    This documentation is about the MediaWiki installation on a cPanel Server. We all have used Wikipedia website in order to search for information. MediaWiki is the webserver software behind Wikipedia, Wiktionary and Wikimedia. MediaWiki is open source wiki software licensed under the GNU General Public License (GPL). It is completely written in Hypertext pre-processor language PHP. Also, it uses a database to store contents. MediaWiki software is optimized to handle large projects and is also pow   [...]

    Read More

    How to Change MySQL Server Time Zone

    Posted at February 1, 2017 at 5:38 pm by Jithin

    In this article, we can discuss about how to change the MySQL server time zone. To change the time zone of your MySQL server, please follow the below steps. 1) Login to your server via SSH as root user.2) You can find current MySQL server time zone via executing the following command. $ mysql  -e "SELECT @@global.time_zone;" The output of the above command is something similar to the following: @@global.time_zoneSYSTEM Here we can see that the MySQL time zone is set as    [...]

    Read More

    Easy steps to setup and install Moodle

    Posted at February 1, 2017 at 5:38 pm by Jithin

    Moodle (Modular Object-Oriented Dynamic Learning Environment) is a free and open source software written in PHP for learning management system. Moodle is used to create private websites with online courses for educators and trainers. Moodle is the leading virtual learning environment and it can be used in many environments such as education, training and development. Moodle is primarily developed in Linux using Apache, PostgreSQL/MySQL/MariaDB and PHP sometimes known as the LAMP platform.     [...]

    Read More

    OwnCloud: The Private Cloud-Installation Guide

    Posted at February 1, 2017 at 5:38 pm by Jithin

    OwnCloud is a file sharing server like drop box. You can store our documents, private contents like pictures, videos safely in our own server and can share it with our friends, colleagues etc. OwnCloud is free and open source, allowing anyone to install and operate without any cost. OwnCloud is a client server software for Linux distributions. In this documentation, we address the installation and configuration of the private cloud OwnCloud. Installation RequirementsMemory requireme   [...]

    Read More

    MySQL Error – The Server Quit Without Updating PID File

    Posted at January 28, 2017 at 11:34 am by Jithin

    The MySQL error "Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/yourservername.pid)” is thrown when MySQL fails to start. This occurs when MySQL is upgraded to a later version or due to insufficient permission and ownership issue in MySQL data directory. The PID file in the MySQL data directory is gone and MySQL wont behave without it. The default MySQL data directory is /var/lib/mysql/. You can see ".err" files inside the MySQL data directory. These are MySQL   [...]

    Read More

    How to Change Password in Webuzo?

    Posted at December 23, 2016 at 12:19 pm by Jithin

    In this tutorial, we can learn how to change the password in Webuzo control panel.1) Login to your Webuzo control panel. 2) Click on the ‘Change Password’ icon from the ‘Security’ section. 3) A new window will open and here you can see the options for changing the password for end users, File Manager, Apache Tomcat Manager, and MySQL root user.4) If you want to change End-user password, enter new password and confirm password in the provided area   [...]

    Read More

    How to Reset WordPress Password?

    Posted at December 13, 2016 at 11:37 am by Jithin

    In this tutorial we can learn how to reset WordPress password.Have you ever lost your WordPress admin password? Do you know how to reset the password in case you don't have access to the WordPress dashboard? There is an option "Forgot Password" in the WordPress admin login screen. You can simply reset it by clicking on the link and following the instructions. Suppose someone had intruded into your WordPress installation and reset the password and changed the email address so that the passwor   [...]

    Read More

    Install MariaDB in Linux Server

    Posted at December 13, 2016 at 11:31 am by Jithin

    In this tutorial, we can learn how to install MariaDB in a Linux Server.A relational database is a mechanism that allows the persistence of a data in an organize way. Databases store data items, organize as a set of tables with each table representing an entity. There are two types of relational database packages. They are listed below.1)PostgreSQL: An open source database developed by the PostgreSQL Global Development Group, consisting of Postgres users (both individual and companies) a   [...]

    Read More

    MySQL Pinba storage engine Installation and Details

    Posted at November 29, 2016 at 1:44 pm by Jithin

    Pinba is a MySQL storage engine and it acts as a real-time monitoring server for PHP using MySQL as a read-only interface. Pinba extension is used to measure particular parts of the code using timers with arbitrary tags also it accumulates and processes data sent over UDP by multiple PHP processes. Pinba displays statistics in a nice human readable form of simple "reports" and also it provides read-only interface to the raw data in order to make possible generation of more sophisticated reports    [...]

    Read More

    How to Repair Databases in cPanel

    Posted at November 29, 2016 at 1:44 pm by Jithin

    When the website gets the following error we do have a provision to check and repair database in cPanel.1) cpaneluser_database is marked as crashed and needs to be repaired2) Checking the database3) Table attribute does not exist,4) Supplied argument is not a validIf you are getting the above errors, please do the following steps to check and repair database in cPanel. Checking the Database1) Login to your cPanel interface.2) Click on ‘MySQL Database’ ico   [...]

    Read More

    What is MySQL Query Caching?

    Posted at November 11, 2016 at 12:57 pm by Jithin

    As we know, caching is used to improve performance. It will increase loading speed of the website or application. There are various types of caching mechanisms available. The Query Caching is one of the caching mechanism used to improve performance.For MySQL, there is a general query cache which can help tremendously. The MySQL is one of the important feature in MySQL and an inevitable part of query optimization. After the caching, results will be set in a memory cache like memcached or cass   [...]

    Read More

    XAMPP Installation in Linux and Windows

    Posted at October 28, 2016 at 4:22 pm by Jithin

     XAMPP Server is a free open source cross-platform web server package. XAMPP is an AMP stack which allows to install Apache, MySQL and PHP in your computer together with some other useful software. It has been designed to provide an easy installation experience. It is free and available for Windows, Mac OS and Linux. It provides an easy way for developers to create a local web server for testing purposes. Since most actual web server deployments use the same components as XAMPP, it prov   [...]

    Read More

    Importing .sql file in MySQL via command line and phpMyAdmin

    Posted at October 14, 2016 at 4:01 pm by Jithin

    Websites using databases have become common now. A website can have unlimited number of databases unless the package under which the website is hosted or the plan provided by the hosting provider restricts the number of databases a website can have. When working with databases, it is necessary to back up data in case you need to restore your website. In MySQL, we use dumping a database to a file with extension .sql to backup and import the .sql file to restore the database.In this documentat   [...]

    Read More

    Backup MySQL Database using PhpMyAdmin

    Posted at August 4, 2016 at 5:07 pm by Jithin

    In this documentation, we can learn how to backup MySQL database using phpMyAdmin. 1) Login to cPanel.2) Click the option ‘PhpMyAdmin’ from the section ‘Databases’. 3) Select the database which you wish to back up from the drop down menu. 4) Click on ‘Export’ tab. 5) Select ‘Export Method’. 6) Select the ‘Format’ from the drop down menu.  7) Click the button ‘Go’   [...]

    Read More

    Understanding Mambo CMS

    Posted at August 4, 2016 at 4:42 pm by Jithin

    Mambo (some time ago named Mambo Open Source or MOS) was a free programming/open source content administration framework (CMS) for making and overseeing sites through a straightforward web interface. Its last launch was in 2008, by which time the greater part of the engineers had left for successors of the venture, for the most part Joomla and MiaCMS. Mambo included elements, for example, page reserving to enhance execution on occupied destinations, progressed template methods, and a genuinely s   [...]

    Read More

    What and how to use MYISAMCHECK and MYSQLCHECK

    Posted at August 4, 2016 at 4:32 pm by Jithin

    MYISAMCHECKThe default storage engine of the MySQL database is MyISAM. The myisam is vulnerable to corruption of the table. During the creation of table in MySQL it creates *.frm files to store table format, *.MYD (My Data) file to store the data and *.MYI (My Index) to store the index. 1) Checking all corrupted tables. myisamchk /var/lib/mysql/eximstats/*.MYImyisamchk: error: Wrong bytesec: 0-0-0 at linkstart: 24569875MyISAM-table '/var/lib/mysql/eximstats/error1.MYI'    [...]

    Read More

    MySQL Storage Engines – Types and Details

    Posted at August 4, 2016 at 2:59 pm by Jithin

    What is a Storage Engine?A storage engine is a software that is used by a database management system to create, read, and update data from a database. Most DBMS use APIs (Application Programming Interface) to enable interactions of users with the storage engines. There are two types of storage engines; Transactional and Non-transactional storage engines. Transactional DatabasesTransactional databases mean that the write operations on these databases are able to be rolled bac   [...]

    Read More

    How to Run MySQL Query in phpMyAdmin

    Posted at February 2, 2016 at 2:22 pm by Jithin

    In this documentation, we can check how to run MySQL query in phpMyAdmin. 1) Login to cPanel account.2) Click the icon ‘phpMyAdmin’ from the section ‘DATABASES’. 3) Select the database name. 4) Select the table name where you want to work. 5) Click on the tab ‘SQL’. 6) Enter the query in the text box. 7) Click the button ‘GO’ to execute the query. That is how we    [...]

    Read More

    Database Management in Plesk

    Posted at December 15, 2015 at 7:01 pm by Jithin

    In this documentation, we can check how to manage database in Plesk control panel. 1) Login to Plesk admin panel.2) Click the ‘Domains’ button. 3) Click ‘Manage Hosting’ button near the domain name. 4) Go to ‘Websites & Domains’ tab. 5) Click ‘Databases’ button. 6) Click ‘Add New Database’ icon. 7) Enter the database and user details and click “OK’ button.&nbs   [...]

    Read More

    Access denied for user da_admin – MySQL error in DirectAdmin

    Posted at December 15, 2015 at 7:01 pm by Jithin

    Sometimes we will get the following MySQL errors in DirectAdmin.Error connecting to MySQL: Access denied for user: 'da_admin@localhost' (Using password: YES) Please follow the steps given below to fix this issue.1) Please make sure that the MySQL root password is correct. If you know the password, follow the second step. a) You can find out the MySQL root password in the following file./usr/local/directadmin/scripts/setup.txt   b) If you are not able to find out    [...]

    Read More

    MySQL Management in Direct Admin

    Posted at December 11, 2015 at 4:52 pm by Jithin

    In this documentation, we can check how to manage MySQL in Direct Admin. 1) Login to Direct Admin panel.2) Click the button ‘MySQL Management’ from the section ‘Your Account’. 3) We can create new database by clicking the button ‘Create new Database’. 4) Enter the new database details and click the button ‘Create’. 5) If you want to delete the database, select the database and click the button ‘Delete’.&n   [...]

    Read More

    Where is the MySQL error log?

    Posted at October 23, 2015 at 8:35 am by InterServer Staff

    /var/lib/mysql/server.hostname.err

    Where can I find more information on MySQL?

    Posted at October 23, 2015 at 8:35 am by InterServer Staff

    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.

    Where are MySQL databases located?

    Posted at October 23, 2015 at 8:35 am by InterServer Staff

    By default databases are located in /var/lib/mysql

    PHPMyAdmin shows every database when logging in as a user

    Posted at October 23, 2015 at 8:28 am by InterServer Staff

    If phpmyadmin shows all the databases on a server when it should only show the users databases do the following:First be sure a MySQL root password is set.Add safe-show-database in the mysqld section of /etc/my.cnf[mysqld] safe-show-databaseThen restart mysql.If this does not work do the following:mysql -u root -p mysqlupdate `user` set Create_tmp_table_priv = 'N', Lock_tables_priv = 'N' where user 'root';Go back to shell and run mysqladmin reload    [...]

    Read More

    MySQL FLUSH Commands.

    Posted at October 23, 2015 at 8:28 am by InterServer Staff

        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 database enabling the changes to take effect without reloading or restarting mysql service. Flush TABLES mysql> FLUSH TABLES;The command closes all tables which are currently open or in use. And clears cache which intern make better utilization on available memory. Flush HOSTS mysql> FLUSH HOSTS; The co   [...]

    Read More

    I get incorrect root password when accessing a MySQL Cpanel feature.

    Posted at October 23, 2015 at 8:26 am by InterServer Staff

    The CPanel needs to know the MySQL root password. To do this you need to edit or create a file in /root called .my.cnfThe file should look something like this:[client] user=root pass=rootpasswordThis will fix the error in the CPanel.

    Install Mysql On CentOS 7

    Posted at October 23, 2015 at 8:26 am by InterServer Staff

    CentOS 7 comes with MariaDB. The package mysql-server is no longer available. To install MariaDB on centos 7 use yum -y install mariadb-server mariadb To start systemctl start mariadb.service To enable on boot systemctl enable mariadb.service The name is different but mariadb is a drop in replacement, all the commands are the same.

    How to recover the mysql root password?

    Posted at October 23, 2015 at 8:25 am by InterServer Staff

    Steps to recover the mysql root password 1.Stop the mysql service # service mysql stop (or) # /etc/rc.d/init.d/mysql stop 2.Start mysql in safe mode by using command mysqld-safe # mysqld_safe --skip-grant-tables It will not read the grant tables and allows anybody to enter in to mysql without asking the password. 3.Login to mysql # mysql -u root 4.Use the mysql database which contains the passwords for all the databases and update the root password with the following command # use mysq   [...]

    Read More

    How can I start and stop mysql?

    Posted at October 23, 2015 at 8:10 am by InterServer Staff

    The standard start/stop scripts are located in /etc/init.d or for older linux versions /etc/rc.d/init.d. Stop MySQL: /etc/init.d/mysql stop Start MySQL: /etc/init.d/mysql start If you run cPanel there is a restart script located at /scripts/restartsrv. To restart MySQL run /scripts/restartsrv mysql

    How do I allow remote MySQL connections?

    Posted at October 23, 2015 at 8:10 am by InterServer Staff

    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. You are looking for the access hosts section on the main MySQL page. Add either your ip address or % for all ip addresses. This will allow a remote connection to MySQL.

    How can I increase MySQL max connections?

    Posted at October 23, 2015 at 8:07 am by InterServer Staff

    Edit the file /etc/my.cnfThe file should look like this:[mysqld] set-variable = max_connections=500Increase 500 to the number you desire.

    How can I backup my MySQL Database?

    Posted at October 23, 2015 at 8:07 am by InterServer Staff

    You can use PhpMyAdmin to dump the contexts of a database to a *.sql file. You can also use PhpMyAdmin to restore a database from a *.sql file. In addition to PHPMYADMIN the command line through SSH can be used. The proper format is as follows: Dump: mysqldump -u username -p databasename > dump.sql Restore: mysql -u username -p databasename < dump.sql

    Disable MySQL Strict mode

    Posted at October 23, 2015 at 8:06 am by InterServer Staff

    To disable strict mode on cpanel servers in mysql 5.6edit /etc/my.cnfadd in under [mysqld]sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONfor example[mysqld] default-storage-engine=MYISAM local-infile=0 innodb_file_per_table=1 max_allowed_packet=268435456 query_cache_limit=4M query_cache_size=128M query_cache_type=1 innodb_flush_log_at_trx_commit=2 innodb_lock_wait_timeout=200 max_connections=500 max_user_c   [...]

    Read More

    Allow a remote IP address to access MySQL in cpanel Shared Hosting

    Posted at October 8, 2015 at 1:45 pm by InterServer Staff

    InterServer shared hosting plans, by default, have all IPs are blocked connecting to mysql. In order to allow an IP, it must be added to an access list.Log into cpanel Scroll down to the Databases section. Click on the Remote MySQL icon. Enter the ip address (you can see the IP at http://catchmyip.com) Click the Add Host button.The mysql port to connect to is 3306. You can connect to the server hostname / your domain name / ip address to port 3306.You can use % as a wildcard. For   [...]

    Read More

    C.5.2.4. Client does not support authentication protocol with php selector

    Posted at October 1, 2015 at 12:00 am by InterServer Staff

    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 the old password type (pre 4.1). To fix this error, old passwords can be used. On the server running in mysql SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); Will set the password to use the old password version. When done run mysqladmin reload

    Read More

    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. There are some differences between the two. To get a correct dump format use the following method to create a mysqldump:mysqldump -u username -p --skip-opt database_name > export_file_name.sqlormysqldump -u username -p --skip-extended-insert database_name > export_file_name.sql

    Read More