This AWS RDS tutorial will show you how to set up MS SQL Server on AWS RDS. Amazon RDS is a cloud database that AWS manage all underlying servers for you. You will first see how to set up SQL Server on RDS. Next you will see how to access your SQL server from RDS.
If you need help on installing a server to connect to your SQL box from please see the tutorials below that may help:
MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation.
After you install MariaDB you log in using the following command:
mysql -u root -p
You may notice that you don’t get prompted for a password. In order to correct this you will need to run the following :
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘yourPassword’);
UPDATE mysql.user SET plugin = ‘ ‘ WHERE user = ‘root’ AND host = ‘localhost’
Run mysql -u root -p You will now need your password to log in.
“MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation”
This short MariaDB tutorial will show you how to check the version of MariaDB you are running. We are running MariaDB on CentOS 7 but the process should be much the same for other operating systems.
Log into your MariaDB instance, in our case we log in using the command:
mysql -u root -p
After you log in you can see your version in the welcome text – highlighted in the screen-grab below:
If you cannot see your version here you can also run the following command to see it:
A full video tutorial on the process can be found here:
This video shows how to install Own Cloud on Centos. Own Cloud is simailr to dropbox but you install it on your own server which gives you full control over your data. There are several prerequisites needed to follow along with this video, which I have also included below.