MySQL – Ryadel

WordPress Security: What to Do When You Find Suspicious Files From Detecting Suspicious Files to Advanced Protection: Practical Strategies to Secure WordPress. Log Analysis, Malware Removal, and Security Settings

March 5, 2025March 24, 2025 - by Ryan - Leave a Comment

Finding unknown files (especially if they are executable scripts like PHP files and/or configuration files, such as php.ini) within WordPress directories can be a sign of malware infection, an anomalous …

ASP.NET / C# / Coding / SQL / Web

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider

October 15, 2020April 17, 2021 - by Ryan - Leave a Comment

In this article we'll see how to take advantage of Serilog, a neat open-source diagnostic logging library for .NET applications, to log our ASP.NET Core web application’s data to a …

Coding / SQL / Web

WordPress: SQL query to add or remove categories on multiple posts A set of useful MySQL queries to perform bulk operations against the WordPress Database such as adding and/or removing categories on multiple posts

February 29, 2020August 8, 2020 - by Ryan - 7 Comments.

In this article I will try to explain how to perform a series of operations on the WordPress categories associated with articles using SQL queries that act directly on the …

Coding / SQL

WordPress - WP Post Views Counter plugin - import data from Yuzo Related Posts How to import the view count data of each existing post from Yuzo Related Posts to WP Post Views Counter WordPress Plugin

November 18, 2018October 19, 2020 - by Ryan - Leave a Comment

Today a friend asked me to uninstall the Yuzo Related Post plugin from her WordPress blog because she want to switch to the Jetpack built-in "related posts" feature. She could …

Linux / Operating Systems / Servers & Services

Linux - MySQL and MariaDB sock file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.sock and /var/run/mariadb/mariadb.sock files and folders

November 18, 2018November 18, 2018 - by Ryan - Leave a Comment

Yesterday I wrote a small tutorial explaining how to fix a common MySQL or MariaDB problem related to the pid file not being created upon the service startup. That same …

Linux / Operating Systems / Servers & Services

Linux - MySQL and MariaDB pid-file folder issues - how to fix How to force MySQL and MariaDB services to create the /var/run/mysqld/mysqld.pid and /var/run/mariadb/mariadb.pid files and folders

November 18, 2018November 18, 2018 - by Ryan - 6 Comments.

If you've stumbled upon this post it most likely means that you've just discovered that your MySQL or MariaDB service, despite running without issues, are not creating their mysqld.pid or …

Coding / Linux / Servers & Services / SQL

How to safely upgrade from MariaDB 10.x to 10.3 without losing data A quick tutorial explaining how to perform a seamless upgrade from a previous version of MariaDB 10 to MariaDB 10.3 keeping all the existing databases intact

August 13, 2018March 26, 2019 - by Ryan - 6 Comments.

It has been a while since MariaDB 10.3 has been out, bringing its stunning pack of changes, improvements and new features - most notably, System-versioned tables and Sequences. If you found this …

Coding / Servers & Services / SQL

Backup MySQL or MariaDB Server with a single Command-Line using mysqldump How to perform a full backup of a MySQL or MariaDB Server instance on a Windows or Linux machine with single command-line

August 12, 2018November 21, 2021 - by Ryan - 1 Comment

If you like playing with MySQL or MariaDB servers, you most likely know that both of these great open-source DBMS come with mysqldump, a neat command-line utility that can be used to …

Coding / PHP / Servers & Services / Web

WordPress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix What to do if you're randomly and repeatedly getting the "Error establishing a database connection" with your WordPress installation using MySQL or MariaDB

August 12, 2018August 12, 2018 - by Ryan - Leave a Comment

The "Error establishing a database connection" WordPress error is a rather common one. You can either get it upon each request, meaning that you WordPress site is entirely down, or intermittently (randomly …

Coding / SQL

The Importance of learning SQL Programming Language Why SQL Programming Language Is Essential While Building and Developing a Database with DBMS such as MS SQL Server, PostgreSQL, MySQL, MariaDB & more

June 28, 2018 - by Ariya Stark - Leave a Comment

Programming is simply setting instructions that will help a computer perform a certain task. A programmed computer can be used to generate accurate algorithms. Over the years, computers have evolved …