From Fedora Project Wiki
Javiertury (talk | contribs) |
Javiertury (talk | contribs) |
||
| Line 9: | Line 9: | ||
First let's start MariaDB | First let's start MariaDB | ||
< | <pre>systemctl start mariadb</pre> | ||
Now start the secure installation assistant | Now start the secure installation assistant | ||
< | <pre>mysql_secure_installation</pre> | ||
Press enter if you didn't have setup a password previously | Press enter if you didn't have setup a password previously | ||
Then it is advisable to answer as follows | Then it is advisable to answer as follows | ||
< | <pre>Set root password? [Y/n] Y | ||
Remove anonymous users? [Y/n] Y | Remove anonymous users? [Y/n] Y | ||
Disallow root login remotely? [Y/n] Y | Disallow root login remotely? [Y/n] Y | ||
Remove test database and access to it? [Y/n] Y | Remove test database and access to it? [Y/n] Y | ||
Reload privilege tables now? [Y/n] Y</ | Reload privilege tables now? [Y/n] Y</pre> | ||
To start MariaDB on boot | To start MariaDB on boot | ||
< | <pre>systemctl enable mariadb</pre> | ||
== GUI frontends == | == GUI frontends == | ||
There are some popular frontends as phpMyAdmin | There are some popular frontends as phpMyAdmin | ||
Revision as of 15:26, 1 May 2014
MariaDB is a dropin replacement of MySQL
Installation
$ su root $ yum install mariadb mariadb-server
Initial setup
First let's start MariaDB
systemctl start mariadb
Now start the secure installation assistant
mysql_secure_installation
Press enter if you didn't have setup a password previously
Then it is advisable to answer as follows
Set root password? [Y/n] Y Remove anonymous users? [Y/n] Y Disallow root login remotely? [Y/n] Y Remove test database and access to it? [Y/n] Y Reload privilege tables now? [Y/n] Y
To start MariaDB on boot
systemctl enable mariadb
GUI frontends
There are some popular frontends as phpMyAdmin