database

Install SQL developer

Get Oracle SQL Developer package
1. go to Homepage: http://www.oracle.com/technology/software/products/sql/index.html
2. accept the licence
3. login
4. download "Oracle SQL Developer for other platforms"

#http://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-4.1.0.18.37-no-jre.zip
http://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-17.4.1.054.0712-no-jre.zip

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.sqldeveloper.sh";
echo "wget $URL-qO - | bash -s /tmp/sqldeveloper-17.4.1.054.0712-no-jre.zip";
echo "

";
$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
echo htmlspecialchars(curl_exec($c));
curl_close($c);
echo "

";
?>

# reduced memory usage
sed -i 's|-Xmx640M|-Xmx384M|g' /opt/sqldeveloper/ide/bin/ide.conf

# ToDo
# http://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-4.0.2.15.21-1.noarch.rpm?AuthParam=XXX_XXX
# use a repository
# configure global

MySQL / MariaDB Database

Login
mysql -u root -p

Optimize all databases
mysqlcheck --optimize --all-databases --host=localhost --user=${DB_USER} --password=${DB_PASS}

Links
phpMyAdmin - phpMyAdmin downloads

GUI
apt-get install -y mysql-admin

Allow access from outsice
sed -i 's|bind-address|#bind-address|g' /etc/mysql/my.cnf
/etc/init.d/mysql restart

Allow access to database magento for user dbo_magento from any host