347
edits
Changes
no edit summary
==Introduction ==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.
===Overview=SQL Buddy ==<p>SQLbuddy is a very minimal user interface for MariaDB. It's advantage is that it is a light interface making it very fast. Also, it is not used as much as [[#phpMyAdmin|phpMyAdmin]], which means it is more secure due to being a smaller profile target. A disadvantage is that it will not highlight SQL syntax for easy viewing when writing a query.</p>
===InstallationOverview ===SQLbuddy is a very minimal user interface for MariaDB. It's advantage is that it is a light interface making it very fast. Also, it is not used as much as [[#phpMyAdmin|phpMyAdmin]], which means it is more secure due to being a smaller profile target. However, these advantages bring the disadvantage of SQLbuddy not having a heavy user interface including its lack of syntax highlighting for SQL queries.
SQLbuddy can be acquired from http://sqlbuddy.com/. This site will allow the user to download a zip file of the user interface. Move this file to the server using an ftp client (such as filezilla) and then use [[This Is Your Brain On Informatics: Linux|mv]] to move the zip file to the directory shown below. Remain there for the rest of installation.
If there is a single directory listed named ''src'' then the files, which are embedded in ''sqlbuddy/src'' need to be moved to ''sqlbuddy''. Do this by typing:
<pre>mv sqlbuddy/src/* sqlbuddyrm -rf sqlbuddy/src/</pre>
If there are multiple files in the ''sqlbuddy'' directory, ignore the above command.
<pre>/etc/nginx/sites-available/www</pre>
<pre>index index.html index.htm index.php</pre>
</div>
Finally, the ''www'' file needs a location for SQLbuddy. Type: <pre>cd /etc/nginx/sites-available</pre> and open While still in the ''www'' file. Then, add this block of code below the current locations to set up a new location on the server for SQLbuddy:
<pre>
Sqlbuddy should now be able to be accessed by typing in ''yourservername/sqlbuddy'' into the browser.
Firefox is excellent at tracking history; however, because of this, anything that was done incorrectly during the setup of sqlbuddy, mariadb, or even php will be remembered by the browser. If firefox is your browser of choice, it will be necessary to clear any history, after doing any major troubleshooting in order to allow those changes to take effect in firefox.
===Overview=phpMyAdmin ==
===Installation=== <p>
This is pretty much a repeat from above, so this time we'll use a slightly different method to show how it works. Go to http://www.phpmyadmin.net/ and right click on ''Download''. Then click on the selection that will copy the link to the clipboard (''copy link address'' for Google Chrome). Now go to the following location in the server and remain there for the rest of the installation:
Also, the type of index file that [[This Is Your Brain On Informatics: NGINX|NGINX]] recognizes will need to be changed so that it recognizes [[#index.php|index.php]] if it has not been done so already.
And lastly, we need to make a location for phpMyAdmin just as for SQLbuddy. TypeAccess the following file with your favorite text editor:
<pre>cd /etc/nginx/sites-available/www</pre> and open the ''www'' file.
Then, add this block of code below the current locations to set up a new location on the server for SQLbuddy:
phpMyAdmin should now be able to be accessed by typing in ''yourservername/phpMyAdmin'' into the browser.