Database related tutorial/FAQ

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

last updated January 8, 2015 in Database, FreeBSD, Linux, MySQL, UNIX

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?

MySQL Reset Root Password

last updated April 6, 2009 in CentOS, Database, Debian / Ubuntu, Fedora Linux, FreeBSD, Linux, Mac OS X, MySQL, OpenBSD, RedHat and Friends, Solaris-Unix, Suse, Ubuntu Linux, UNIX

I forgot the MySQL root password. How do I reset MySQL root password?

Freebsd Mount a NAS via SMB / CIFS

last updated January 25, 2009 in Backup & Recovery, BASH Shell, Database, File system, FreeBSD, FreeBSD Jails (VPS), Networking, UNIX

Q. I want to use our NAS server to store backups. Our NAS supports FTP and CIFS / SMB sharing technology. How do I mount and store files on NAS using FreeBSD? How do I automate entire procedure using a shell script? Is that doable? If so, what’s the easiest solution ftp or CIFS?