Differences

This shows you the differences between two versions of the page.

--- gentoo:mysql [2024/03/12 13:52] – created willy
+++ gentoo:mysql [2025/03/13 13:24] (current) – [MariaDB / MySQL] willy
@@ Line 1: / Line 1: @@
-====== MariaDB / MySQL ======
+====== D) MariaDB / MySQL ======
 [[https://mariadb.org/|MariaDB]] is the successor to [[https://www.mysql.com|MySQL]] after Oracle went a bit crazy on it. MariaDB is more updated, more secure and generally the logical successor to MySQL. And it's 100% compatible.
@@ Line 22: / Line 22: @@
 <code bash>
 emerge --config dev-db/mariadb
+</code>
+Input and **remember** your root password!
+===== Startup =====
+Start the service and set it on boot:
+<code bash>
+rc-update add mysql default
+/etc/init.d/mysql start
+</code>
+===== Management =====
+It's a good idea to create a separated database and user for each service you are oging to use with MariaDB. These instructions are not exaustive but only a quick reference:
+**Login to the MariaDB**
+<code bash>
+mysql -u root -p -h localhost
+</code>
+**Creating a database with user**
+<code>
+create database DATABASE_NAME;
+grant all privileges on DATABASE_NAME.* TO 'USER_NAME'@'localhost' identified by 'PASSWORD';
+flush privileges;
 </code>

Willy's Wiki