Category: MySQL

On DBs

MyCLI – A MySQL/MariaDB Client with Auto-completion and Syntax-highlighting

MyCLI is an easy-to-use command line (CLI) interface for the popular database management systems: MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. It is built using prompt_toolkit and requires Python 2.7, 3.3, 3.4, 3.5,

How to Change a Default MySQL/MariaDB Data Directory in Linux

After installing the components of a LAMP stack on a CentOS/RHEL 7 server, there are a couple of things you may want to do. Some of them have to do with increasing the security of

blank

How to Change Root Password of MySQL or MariaDB in Linux

If you’re installing MySQL or MariaDB in Linux for the first time, chances are you will be executing mysql_secure_installation script to secure your MySQL installation with basic settings. One of these settings is, database root

blank

How to Reset MySQL or MariaDB Root Password in Linux

If you are setting up a MySQL or MariaDB database server for the first time, chances are you will be running mysql_secure_installation soon afterwards to implement basic security settings. One of these settings is the

blank

Give your WordPress website some TLC this Valentine’s

Every WordPress website needs tender loving care, to keep up with the latest versions of software, new browsers & devices and the latest security patches. To give your users the best experience possible, make sure

blank

Big WordPress Problem – Slow WP Admin / Uncached Pageloads Slow

Table of Contents Some problems are first world problems. Other problems are big WordPress problems. Slow WordPress Admin? Slow uncached pageloads? We deal with some big WordPress customers, and often their sites can become slow.

blank

Learn How to Use Several Functions of MySQL and MariaDB – Part 2

This is the second part of a 2-article series about the essentials of MariaDB / MySQL commands. Please refer to our previous article on this topic before proceeding. Learn MySQL/MariaDB Basics for Beginners – Part

blank

Learn MySQL / MariaDB for Beginners – Part 1

In this article we will show how to create a database (also known as a schema), tables (with data types), and explain how to perform Data Manipulation Language (DML) operations with data on a MySQL

c
blank

cPanel Server : Restoring MySQL SimLink.

If you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you may see that there is no simlink To create a simlink you can do the

blank

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (13)

Background It wasn’t working! But in more detail: An R1Soft restore had taken place, restoring from the backup server to the live server The files were MySQL data files originally from /var/lib/mysql/ The files were

H
blank

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

This tutorial is based on Falko Timme’s tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer

T
blank

Turbo charging MySQL by setting up the query cache

To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file . Usually its my.cnf or my.ini so check on your server with the shell

blank