How To Check a MySQL Database for Errors 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]

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]

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

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]

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]

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]

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

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

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]

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]”