≡ Menu

Database

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

MySQL Reset Root Password

I forgot the MySQL root password. How do I reset MySQL root password?
[click to continue…]

Freebsd Mount a NAS via SMB / CIFS

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

MySQL: Find Out Which Table is Consuming Resources

Q. How do I find out which table is consuming resources under MySQL Database server from UNIX shell prompt?
[click to continue…]

What’s New in MS-SQL 2008

Q. Can you tell me more about MS SQL Server 2008? What’s new in MS-SQL Server 2008?
[click to continue…]

Ubuntu Linux Remove Oracle Express Edition

I know how to install Oracle XE on Debian / Ubuntu Linux. But, how do I remove Oracle Express edition under Ubuntu Linux?
[click to continue…]

MSSQL: Enable Mixed Mode Authentication

Q. How do I enable mixed mode authentication under MS-SQL running on Microsoft Windows server 2003?
[click to continue…]

MySQL Change a User Password

I would like to change a password for a user called tom using UNIX / Linux command line option. How do I change a user password under MySQL server?
[click to continue…]