The default upload size for PHP is 2M and NGINX also has a default of 1M. This needs to be increased for it to be useful for typical web applications. You can increase the PHP file upload size limits by editing the following in php.ini: upload_max_filesize = 100M...
One of the most frustrating things is installing MySQL and then forgetting what password you set for the root user. This has happened to me on more than one occasion. You can reset the password with the following procedure. If you run mysqld and get errors where it...
The SQL Server Single User Mode only permits one connection to a database at a time. Great for testing, but not for deployment. Here is how you can get it out of this state. Open the Microsoft SQL Server Management Studio. Start a new SQL query and enter the code...
When you backup a database and then later try to restore it, you might get a message that the database is in a restoring state. Here is how you can fix this. Open the Microsoft SQL Server Management Studio. Start a new SQL query and enter the code below with the...
How to install WordPress from the command line in Linux. Installing WordPress on a web server is normally done by downloading the files from wordpress.com and copying the uncompressed files to your web site folder with an FTP or SSH client. You can also install the...
I normally lock my computer when I step away from it to prevent other users from getting access to it which would give them full access to my web sites, databases, and other sensitive files. I do this as opposed to logging out of the computer. Locking the screen keeps...
