Installing WordPress Step 2: Setting up MySQL for WordPress using Command Line MySQL Client on Linux (CentOS 6)

This post is part of a step-by-step series on installing WordPress on Linux (CentOS 6) There are several ways to access your MySQL database, but in this tutorial we will be using command line. Before we begin we assume the following: Requirements MySQL has been installed and secured WordPress Directory has been Installed Using yum…

Solving MySQL ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

I came upon this error after installing the latest version of MySQL using yum and securing it. The Error With mysqld running I tried to run mysql as follows: [ahmed@amayem ~]$ mysql ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) Different failed attempts: Here are more attempts to get it…

Installing Latest Version of MySQL on Linux (CentOS 6) Production Server

Checking if MySQL is Already Installed [ahmed@amayem ~]$ rpm -q mysql-server package mysql-server is not installed Or you can do it this way: [ahmed@amayem ~]$ yum list installed | grep mysql [ahmed@amayem ~]$ Downloading the MySQL Yum Repository Release Package: Choose your operating system from http://dev.mysql.com/downloads/repo/yum/ In my case it was CentOS 6, which means…