Tag Archives: MySQL

Filling Empty Cells with Zero in Excel

I had an enormous spreadsheet I’d made by saving a PDF as an Excel workbook and rearranging the data. I needed to get the data into MySQL but there were countless empty cells where candidates received no votes and I … Continue reading

Posted in Tutorials | Tagged , | Leave a comment

Then Things Went Unsmoothly

Everything installed and, for the most part, configured quite easily. Then I couldn’t log in to PHPmyAdmin. Spent hours troubleshooting and reconfiguring Apache, PHP, and MySQL only to find out that my root MySQL user username wasn’t my username, it … Continue reading

Posted in LAMP | Tagged , | Leave a comment