Increase Upload Size for PHP in NGINX

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...

How to Create Root Password in MySQL 8

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...

MSSQL: How To Get Database Out of Single User

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...

Installing WordPress from the Command Line

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...

How to Lock a Windows 10 Screen from a Console Command

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...
Translate »