The Helpdesk For I.T. Administrators
Ensuring you have a secure, and hard to guess MySQL root password is critical on production servers. If you don’t currently have a strong MySQL root password, please update it using the details below. Likewise, if you think someone may know the password, who shouldn’t, change the password immediately. Run the following SQL statement on …
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.
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 …
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: …
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 …
Microsoft SQL Server allows you to add multiple triggers on a specific table. This is a great feature of Microsoft SQL Server, however one of the issues that can catch people out is in the order that the triggers will ‘fire’. By default, the triggers will run in the order that they were created/added to …
Minimizing the time it takes for an MS SQL query to run is important when creating an application or website. You can always add more resources on the SQL server, such as RAM and CPU, but that doesn’t really fix the source of the issues, especially if the there are large volumes of SQL transactions. …
This ‘How To’ article outlines the steps required to compile and install the Firebird database server on a Linux machine. Download the latest version of the source code from http://www.firebirdsql.org/en/server-packages/ At the time of writing this article, the latest version was 2.5.1.26351-0. Replace the URL below with the latest version, or get the source code …
Its always good to have a firewall set up to prevent users from accessing services they shouldn’t have access to, however this usually means that you need to explicitly allow specific ports and protocols to allow users to access services they need to access. One such service would be a database server. Below is a …
In Microsoft SQL server 2000 and 2005, as part of the ‘BACKUP LOG’ command, there was an option to truncate the log file, without storing a backup to file. In Microsoft SQL Server 2008, this option has been removed, and you can now no longer use the ‘TRUNCATE_ONLY’ option when performing a transaction log backup. …