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).

I‘m a new FreeBSD unix user. How can I install MySQL and/or MariaDB database server on a FreeBSD unix based system?

{ 1 comment }

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?

{ 1 comment }

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?

{ 0 comments }

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?

{ 9 comments }

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?

{ 18 comments }

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?

{ 4 comments }

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?

{ 3 comments }