≡ Menu

MySQL DBA Tutorials & HowTos

MySQL tutorials and howtos for database admins, sysadmins, DBAs, webmasters, and Unix/Linux users who wish to improve their database skills such as backup, security, optimization, management and much more (rss feed).

How to install mysql server 5.7 on Ubuntu 16.04 LTS ( Xenial Xerus )

MySQL is a popular database management system used for my web applications. How do I install MySQL server version 5.7 on Ubuntu Linux 16.04 LTS ( Xenial Xerus )?
[click to continue…]

How To Setup a LAMP Server on Debian Linux 8 (Jessie)

How can I setup up a LAMP (Linux, Apache, MySql, PHP) stack on Debian Linux version 8 (Jessie) using command line options?
[click to continue…]

Ubuntu Linux 12.04/14.04 LTS Install Memcached Server For Python and PHP Apps

I‘m a new Ubuntu 12.04/14.04 server user. How do I install and use memcached on an Ubuntu Linux 14.04 LTS server? How can I my apps written in PHP or Python can use memcached on an Ubuntu LTS server?
[click to continue…]

How To Install MariaDB Databases on a FreeBSD v10 Unix Server

I‘m a new FreeBSD unix user. How can I install MariaDB database server on a FreeBSD unix based system?
[click to continue…]

How To Install Apache, MySQL, PHP stack on FreeBSD Unix Server

I‘m a new FreeBSD Unix system users. How can I setup and install Apache, MySQL, PHP stack on a FreeBSD 10 based Unix server?
[click to continue…]

Check The Number Of MySQL Open Database Connections on Linux Or Unix-like Server

I‘m a new MySQL server user. My server is running on a CentOS Linux. How can I check the number of active MySQL connections on Linux based system?
[click to continue…]

Install LEMP (Linux, Nginx, MySQL and PHP) Stack on Ubuntu Linux 14.04 LTS

I‘m a new Ubuntu Linux user. How do I install the LEMP stack on an Ubuntu Linux 14.04 LTS server using command line options to serve dynamic web apps?
[click to continue…]

CentOS and RHEL 7: Install Linux, Apache, MariaDB, PHP (LAMP) Stack

I am new Red Hat Enterprise Linux version 7 user/sysadmin/developer. This version made the big number change for RHEL 7/CentOS 7. How can I install LAMP (Linux, Apache, MariaDB, PHP) stack on a RHEL version 7 or CentOS Linux version 7 using CLI or over ssh based session?
[click to continue…]

HowTo: Uninstall MySQL Server in Ubuntu Linux

I‘m a new Ubuntu Linux user and my cloud hosting company installed MySQL server by default. I need to remove it and delete it from my server as I have no use of MySQL server. How can I uninstall MySQL on a Ubuntu based systems?
[click to continue…]

HowTo: Reinstall MySQL v5.x On Linux

My MySQL database installation has been corrupted. I would like to delete old mysql server. How do I reinstall MySQL database server version 5.x on Linux or Unix-like oses? A software upgrade broke my system. How can I uninstall and re-install mysql again to get fresh full mysql again?
[click to continue…]