347
edits
Changes
Created page with "==SQL Buddy== ===Overview=== <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 ..."
==SQL Buddy==
===Overview===
<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]]
</p>
===Installation===
<p>
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 directory shown below and remain there for the rest of installation.
<pre>/usr/share/nginx/html</pre>
In order to unzip the file, unzip must first be installed on the server. If it is not type:
<pre>aptidude install unzip</pre>
Then, unzip the file by typing:
<pre>
unzip sqlbuddy.zip
rm -rf sqlbuddy.zip
</pre>
This method of download should have all of the files located directly under the ''sqlbuddy'' directory; however, this needs to be confirmed first. Type:
<pre>ll sqlbuddy</pre>
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/* sqlbuddy</pre>
If there are multiple files in the ''sqlbuddy'' directory, ignore the above command.
</p>
<p>
Now, a final configuration must be done in the ''www'' file so that the index.php will be recognized as the primary site. Go to the file shown below using [[This Is Your Brain On Informatics: Pico|pico]] (or any other text editor of your choice).
<pre>/etc/nginx/sites-available/www</pre>
In this file add ''index.php'' to the line shown below (shown with ''index.php'' added already).
<pre>index index.html index.htm index.php</pre>
Sqlbuddy should now be able to be accessed by typing in ''yourservername/sqlbuddy'' into the browser.
</p>
===Troubleshooting===
<p>
There are still some quirks that may need to be worked out at this point.
</p>
====Firefox====
<p>
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.
</p>
==phpMyAdmin==
===Overview===
<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]]
</p>
===Installation===
<p>
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 directory shown below and remain there for the rest of installation.
<pre>/usr/share/nginx/html</pre>
In order to unzip the file, unzip must first be installed on the server. If it is not type:
<pre>aptidude install unzip</pre>
Then, unzip the file by typing:
<pre>
unzip sqlbuddy.zip
rm -rf sqlbuddy.zip
</pre>
This method of download should have all of the files located directly under the ''sqlbuddy'' directory; however, this needs to be confirmed first. Type:
<pre>ll sqlbuddy</pre>
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/* sqlbuddy</pre>
If there are multiple files in the ''sqlbuddy'' directory, ignore the above command.
</p>
<p>
Now, a final configuration must be done in the ''www'' file so that the index.php will be recognized as the primary site. Go to the file shown below using [[This Is Your Brain On Informatics: Pico|pico]] (or any other text editor of your choice).
<pre>/etc/nginx/sites-available/www</pre>
In this file add ''index.php'' to the line shown below (shown with ''index.php'' added already).
<pre>index index.html index.htm index.php</pre>
Sqlbuddy should now be able to be accessed by typing in ''yourservername/sqlbuddy'' into the browser.
</p>
===Troubleshooting===
<p>
There are still some quirks that may need to be worked out at this point.
</p>
====Firefox====
<p>
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.
</p>
==phpMyAdmin==
