≡ Menu

MySQL

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

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?
[click to continue…]

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

I am using MariaDB mysql command. How do I see MySQL users in a MySQL/MariaDB database stored on my server?
[click to continue…]

How to setup MariaDB SSL and secure connections from clients

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?
[click to continue…]

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/11 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…]