All downloads for MariaDB are situated in the Download part of the authority MariaDB establishment site. Snap the connect to the form you might want, and a rundown of downloads for numerous working frameworks, designs, and establishment document types is shown.
Installing on LINUX/UNIX
In the event that you have cozy information on Linux/Unix frameworks, essentially download source to fabricate your introduce. Our prescribed method of introducing is to use conveyance bundles. MariaDB offers bundles for the accompanying Linux/Unix circulations −
- RedHat/CentOS/Fedora
- Debian/Ubuntu
The accompanying dispersions incorporate a MariaDB bundle in their stores −
- openSUSE
- Curve Linux
- Mageia
- Mint
- Slackware
Follow these means to introduce in a Ubuntu climate −
Stage 1 − Login as a root client.
Stage 2 − Navigate to the catalog containing the MariaDB bundle.
Stage 3 − Import the GnuPG marking key with the accompanying code −
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
Stage 4 − Add MariaDB to the sources.list record. Open the document, and add the accompanying code −
sudo add-apt-repository 'deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntuprecise main'
Stage 5 − Refresh the framework with the accompanying −
sudo apt-get update
Stage 6 − Install MariaDB with the accompanying −
sudo apt-get install mariadb-server
Installing on Windows
Subsequent to finding and downloading a mechanized introduce record (MSI), essentially double tap the document to begin the establishment. The establishment wizard will walk you through each progression of establishment and any essential settings.
Test the establishment by beginning it from the order brief. Explore to the area of the establishment, ordinarily in the index, and type the accompanying at the brief −
mysqld.exe --console
In the event that the establishment is effective, you will see messages identified with startup. In the event that this doesn't show up, you may have authorization issues. Guarantee that your client record can get to the application. Graphical customers are accessible for MariaDB organization in the Windows climate. On the off chance that you discover the order line awkward or unwieldy, make certain to try different things with them.
Testing the Installation
Play out a couple of straightforward errands to affirm the working and establishment of MariaDB.
Use the Admin Utility to Get Server Status
View the worker variant with the mysqladmin double.
[root@host]# mysqladmin --version
It should show the form, appropriation, working framework, and engineering. On the off chance that you don't see the yield of that kind, inspect your establishment for issues.
Execute Simple Commands with a Client
Raise the order brief for MariaDB. This ought to associate you to MariaDB and permit execution of orders. Enter a straightforward order as follows −
mysql> SHOW DATABASES;
Post- Installation
After effective establishment of MariaDB, set a root secret key. A new introduce will have a clear secret key. Enter the accompanying to set the new secret key −
mysqladmin -u root password "[enter your password here]";
Enter the accompanying to associate with the worker with your new accreditations −
mysql -u root -p
Enter password:*******
Upgrading on Windows
On the off chance that you as of now have MySQL introduced on your Windows framework, and need to move up to MariaDB; don't uninstall MySQL and introduce MariaDB. This will cause a contention with the current information base. You should rather introduce MariaDB, and afterward utilize the update wizard in the Windows establishment document.
The alternatives of your MySQL my.cnf record should work with MariaDB. Be that as it may, MariaDB has numerous highlights, which are not found in MySQL.
Consider the accompanying clashes in your my.cnf record −
- MariaDB utilizes Aria stockpiling motor of course for transitory documents. In the event that you have a ton of impermanent documents, alter key cradle size in the event that you don't utilize MyISAM tables.
- In the event that your applications associate/detach habitually, adjust the string reserve size.
- On the off chance that you use more than 100 associations, utilize the string pool.
Compatibility
MySQL and MariaDB are basically indistinguishable. Nonetheless, there are sufficient contrasts to make issues in upgradation. Survey a greater amount of these critical contrasts in the MariaDB Knowledge Base.