User Tools

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
gentoo:mysql [2024/03/12 13:53] – willygentoo: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. [[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! 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>
 +