How To Check a MySQL Database for Errors in cPanel

Posted on by dpepper | Updated:
Category: Tutorials | Tags: , , , , , ,
cPanel Tutorial: MySQL
I. How To Set up a Database using the MySQL Database Wizard in cPanel
II. How To Create a MySQL Database in cPanel
III. How To Delete a MySQL Database in cPanel
IV. How To Create a MySQL Database User in cPanel
V. How To Assign a User to a MySQL Database in cPanel
VI. How To Change a MySQL Database User’s Password in cPanel
VII. How To Remove a User from a MySQL Database in cPanel
VIII. How To Delete a MySQL Database User in cPanel
IX. How to Check a MySQL Database for Errors in cPanel
X. How To Repair a MySQL Database in cPanel
XI. How To Manage a MySQL Database with phpMyAdmin in cPanel

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Now let’s learn how to check a database for errors.

  1. Click the “MySQL Databases” icon.cpanel-pl-mysql-9-check-02
  2. Under “Modify Databases”, and in the “Check Database” drop-down box, select the database you want to check.cpanel-pl-mysql-9-check-03
  3. Then click “Check Database”.cpanel-pl-mysql-9-check-04
  4. That’s it! The check has been completed, and no errors were found.cpanel-pl-mysql-9-check-05

 

Error: Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]

Posted on by J. Mays | Updated:
Category: Common Fixes, Technical Support | Tags: , , , , , ,

This error relates to logging into phpMyAdmin, an open source tool used for the administration of MySQL.

Once in awhile, perhaps on a Development server, MySQL won’t be setup with a root password. The aforementioned configuration is generally thought of as against best practices however, if it is what you’re dealing with, then it could also interfere with phpMyAdmin.

Pre-Flight Check

  • These instructions are intended specifically for solving the error: Login without a password is forbidden by configuration (see AllowNoPassword).
  • I’ll be working from a Liquid Web Self Managed Ubuntu 15.04 server, and I’ll be logged in as root.

The Error

The error will read “Login without a password is forbidden by configuration (see AllowNoPassword)” as shown below.

Error Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]
Continue reading “Error: Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]” →

Error: 500 OOPS: priv_sock_get_int [SOLVED]

Posted on by J. Mays | Updated:
Category: Common Fixes, Technical Support, Tutorials | Tags: , , , , ,
Pre-Flight Check
  • These instructions are intended specifically for solving the error: 500 OOPS: priv_sock_get_int.
  • I’ll be working from a Liquid Web Self Managed Fedora 22 server, and I’ll be logged in as root.

Continue reading “Error: 500 OOPS: priv_sock_get_int [SOLVED]” →

How to Install Logwatch on Fedora 21

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , , , ,

Logwatch is a Perl-based log management tool for analyzing, summarizing, and reporting on a server’s log files. It is most often used to send a short digest of server’s log activity to a system administrator.

What are log files? Logs are application-generated files useful for tracking down and understanding what has happened in the past.

Pre-Flight Check

  • These instructions are intended specifically for installing the Logwatch on Fedora 21.
  • I’ll be working from a Liquid Web Self Managed Fedora 21 server, and I’ll be logged in as root.

Continue reading “How to Install Logwatch on Fedora 21” →

Error: 500 OOPS: vsftpd: refusing to run with writable root inside chroot() [SOLVED]

Posted on by J. Mays | Updated:
Category: Common Fixes, Technical Support | Tags: , , , ,
Pre-Flight Check
  • These instructions are intended specifically for solving the error: 500 OOPS: vsftpd: refusing to run with writable root inside chroot().
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.

Continue reading “Error: 500 OOPS: vsftpd: refusing to run with writable root inside chroot() [SOLVED]” →

Error: 500 OOPS: priv_sock_get_cmd [SOLVED]

Posted on by J. Mays | Updated:
Category: Common Fixes, Technical Support | Tags: , , , ,
Pre-Flight Check
  • These instructions are intended specifically for solving the error: 500 OOPS: priv_sock_get_cmd.
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.

Continue reading “Error: 500 OOPS: priv_sock_get_cmd [SOLVED]” →

Apache Error: No matching DirectoryIndex (index.html) found [SOLVED]

Posted on by J. Mays | Updated:
Category: Common Fixes, Technical Support | Tags: , , , ,
Pre-Flight Check
  • These instructions are intended specifically for solving the error: No matching DirectoryIndex (index.html) found.
  • I’ll be working from both Liquid Web Core Managed CentOS 6 and CentOS 7 servers, and I’ll be logged in as root.

Continue reading “Apache Error: No matching DirectoryIndex (index.html) found [SOLVED]” →

How to Install Logwatch on Fedora 20

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , , , ,

Logwatch is a Perl-based log management tool for analyzing, summarizing, and reporting on a server’s log files. It is most often used to send a short digest of server’s log activity to a system administrator.

What are log files? Logs are application-generated files useful for tracking down and understanding what has happened in the past.

Pre-Flight Check
  • These instructions are intended specifically for installing the Logwatch on Fedora 20.
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.

Continue reading “How to Install Logwatch on Fedora 20” →

How To Install Cassandra on CentOS 7

Posted on by J. Mays | Updated:
Category: Technical Support | Tags: , , , , , , , ,

Apache Cassandra is a NoSQL database intended for storing large amounts of data in a decentralized, highly available cluster. NoSQL refers to a database with a data model other than the tabular relations used in relational databases such as MySQL, PostgreSQL, and Microsoft SQL.

Pre-Flight Check
  • These instructions are intended for installing Cassandra 2 on a single CentOS 7 node.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
  • You may be able to skip to Step #2 if you already have a stable version of Java 7 (preferably the Oracle/Sun JVM). Check to see if your server already has Java installed by running the following command: java -version
  • Continue reading “How To Install Cassandra on CentOS 7” →

Error: Failed to connect to ‘127.0.0.1:7199’: Connection refused (Cassandra) [SOLVED]

Posted on by J. Mays | Updated:
Category: Common Fixes, Technical Support | Tags: , , , , ,
Pre-Flight Check
  • These instructions are intended specifically for solving the error: Failed to connect to ‘127.0.0.1:7199’: Connection refused.
  • I’ll be working from both Liquid Web Core Managed CentOS 6 and CentOS 7 servers, and I’ll be logged in as root.

Continue reading “Error: Failed to connect to ‘127.0.0.1:7199’: Connection refused (Cassandra) [SOLVED]” →