MySQL – nixCraft

How To Install Linux, Apache, MySQL, PHP (LAMP) Stack on Debian 9 Stretch

June 13, 2017June 13, 2017in Apache, Debian / Ubuntu, Linux, MySQL, Package Management, PHP last updated June 13, 2017

I am a new user of Debian 9 operating system. Can you tell me how to setup and install LAMP stack on a Debian 9 (Stretch)?

How to set up MariaDB Master-Slave replication with SSL on Ubuntu Linux

April 14, 2017April 15, 2017in Debian / Ubuntu, Linux, MySQL last updated April 15, 2017

How do I setup Master-slave data replication using MariaDB server on Ubuntu Linux 16.04 LTS server? How do I encrypt replication traffic so that the data get encrypted in transit, protecting my data and users from snooping?
Continue reading

How to set and enable MariaDB slow query log

March 29, 2017March 29, 2017in BASH Shell, CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, RedHat and Friends, Suse, UNIX last updated March 29, 2017

I setup MariaDB server on Linux. How do I enable slow query log in MariaDB server on Linux or Unix-like system?

How to install and configure MariaDB Galera as master to master replication cluster on Ubuntu 16.04 LTS

March 5, 2017March 6, 2017in CentOS, Debian / Ubuntu, Linux, MySQL, RedHat and Friends, Suse last updated March 6, 2017

How do I install and configure MariaDB Galera master to master cluster on Ubuntu Linux 16.04 LTS server to get both read and write scalability?

How to delete or remove a MySQL/MariaDB user account on Linux or Unix

February 15, 2017February 16, 2017in Linux, MySQL, UNIX last updated February 16, 2017

I created a MySQL / MariaDB user account using this page. Now, I have deleted my wordpress blog and I want to delete that user account including database too. How do I delete or remove a MySQL or MariaDB user account on Linux or Unix-like system using mysql command line option?

How to see/get a list of MySQL/MariaDB users accounts

February 5, 2017February 6, 2017in Linux, MySQL, UNIX last updated February 6, 2017

I am using MariaDB mysql command. How do I see MySQL users in a MySQL/MariaDB database stored on my server?

How to setup MariaDB SSL and secure connections from clients

January 24, 2017March 22, 2017in CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, Networking, Security, UNIX last updated March 22, 2017

I am looking to setup MariaDB SSL (Secure Sockets Layer) and secure connections from MySQL client and PHP application. How do I enable SSL for MariaDB server and client running on Linux or Unix-like system?