Changes

While MySQL can be run completely from the command line, it is very useful in many circumstances to have an interface that allows easy manipulation of the database structure. This can be especially helpful for some of the more complex SQL syntax structures such as creating a user and assigning a password or uploading a CSV (comma separated values) file. Additionally, when creating and modifying tables with a scripting language such as PHP, this can be very helpful for viewing and quickly seeing if the script is working. Below are two of the more popular interfaces for MariaDB, [[#SQL Buddy|SQLbuddy ]] and [[#phpMyAdmin|phpMyAdmin]]; however, there are several others.