Reloading the MySQL priviledge tables
After making changes to MySQL permissions/user accounts, make sure you flush the provilege tables using the following command: FLUSH PRIVILEGES; This will make any changes take effect immediately.
April 15, 2012
-
-
Disable remote root logins into MySQL
To keep a MySQL database server secure, you should always only allow root logins from the local machine (localhost, 127.0.0.1 for IPv4, and ::1 for IPv6. Run the following SQL script against the MySQL server, to remove all access from remote hosts for the ‘root’ user account: DELETE FROM mysql.user WHERE User=’root’ AND Host NOT …
April 15, 2012 -
Remove anonymous user from MySQL
MySQL includes an anonymous user account that allows anyone to connect into the MySQL server without having a user account. This is meant only for testing, and should be removed before the database server is put into a production environment. Run the following SQL script against the MySQL server to remove the anonymous user account: …
April 15, 2012 -
Secure a MySQL installation using mysql_secure_installation
A standard installation of MySQL includes a number of tools to manage the database server. One of these tools is the ‘mysql_secure_installation’ script. This script guides the user through setting up a secure MySQL root password, removes the anonymous user account, disabling remote root connections, removes the test database, and finally flushes all the changed …
April 15, 2012 -
Start a Headless VirtualBox Virtual Machine on Windows
Oracle’s VirtualBox software comes with a wide range of command line tools that allow you to manage the VirtualBox virtual machines. One of these tools is “VBoxHeadless.exe”. This tool allows you to start up a virtual machine from the command line, without having to load the Virtualbox application itself. This is great for when the …
April 13, 2012 -
PowerShell Command to Show Exchange Service Status
The “Get-Service” PowerShell command can be used to display the status of all services on a machine. To make this easier to read, and to narrow down the results to specific services, you can pipe the output to “Where” and filter the results. The following command displays a list of Microsoft Exchange related services, and …
April 13, 2012 -
View Exchange Mailbox statistics from the PowerShell
The “Get-MailboxStatistics” PowerShell command can be used to view statistics for a specified mailbox/user account. The only required parameter is the mailbox name, or the user identity. For example: Get-MailboxStatistics -Identity Administrator” Simply running the Get-MailboxStatistics as per the example above, you will only see a few of the columns that get returned (DisplayName, ItemCount, …
April 11, 2012 -
Installing Microsoft Exchange 2010 on Windows Server 2008 R2
Exchange Server 2010 is currently (at the time of writing) the latest version of Microsoft’s email server software. Its main features consists of email, calendaring, contacts, and tasks. This how to article will outline the steps required to install Microsoft Exchange Server 2010 on a Windows Server 2008 R2 machine. The steps should remain the …
April 11, 2012 -
Enable GZIP compression in Nginx
All commonly used web browsers nowadays support GZIP compression, so enabling this on your web server is a great way to decrease how much data you are sending out, and in turn, speed up your site. While it may not make a huge difference on a small site, you may notice a big difference on …
April 8, 2012 -
Kill a process from the command line on windows
There may be times when you want to close a process from the command line on a Windows machine. The ‘taskkill’ command allows you to kill processes/programs by process id or exe name (image name). You can do the same thing from the windows task manager, but sometimes this is not suitable. For example, if …
April 8, 2012