Tag Archives: mysql

Allow remote access to mysql using xampp

If you use XAMPP for your MySQL and you want to use another program to manage your database instead of phpMyAdmin, for example MySQL Workbench, you will need to allow remote access to MySQL.

Here is how from an answer in serverfault.com: How do I allow remote access to mysql using xampp?


Import Excel Data into MySQL

This very helpful little guide shows how to export your excel data into a csv file and then import them to MySQL using a command. I’ve used it many times in the past and I keep it handy in my bookmarks.

Read the full guide here: Import Excel Data into MySQL in 5 Easy Steps