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:55] – 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 37: Line 37:
  
 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: 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>