Differences

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

--- gentoo:mysql [2024/03/12 13:53] – 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 25: / Line 25: @@
 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