Différences
Ci-dessous, les différences entre deux révisions de la page.
systemes:bdd:mariadb [2016/02/23 11:03] william [Configuration] |
systemes:bdd:mariadb [2019/02/06 14:03] |
||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
- | ====== MariaDB ====== | ||
- | ===== Introduction ===== | ||
- | |||
- | |||
- | ===== Installation ===== | ||
- | |||
- | L' | ||
- | |||
- | |||
- | |||
- | <code bash> | ||
- | apt-get install mariadb-server mariadb-client | ||
- | ou | ||
- | yum install | ||
- | </ | ||
- | |||
- | ===== Configuration ===== | ||
- | |||
- | <code bash> | ||
- | systemctl start mariadb | ||
- | </ | ||
- | <code bash> | ||
- | / | ||
- | |||
- | NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB | ||
- | SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! | ||
- | |||
- | In order to log into MariaDB to secure it, we'll need the current | ||
- | password for the root user. If you've just installed MariaDB, and | ||
- | you haven' | ||
- | so you should just press enter here. | ||
- | |||
- | Enter current password for root (enter for none): | ||
- | OK, successfully used password, moving on... | ||
- | |||
- | Setting the root password ensures that nobody can log into the MariaDB | ||
- | root user without the proper authorisation. | ||
- | |||
- | Set root password? [Y/n] Y | ||
- | New password: | ||
- | Re-enter new password: | ||
- | Password updated successfully! | ||
- | Reloading privilege tables.. | ||
- | ... Success! | ||
- | |||
- | |||
- | By default, a MariaDB installation has an anonymous user, allowing anyone | ||
- | to log into MariaDB without having to have a user account created for | ||
- | them. This is intended only for testing, and to make the installation | ||
- | go a bit smoother. | ||
- | production environment. | ||
- | |||
- | Remove anonymous users? [Y/n] Y | ||
- | ... Success! | ||
- | |||
- | Normally, root should only be allowed to connect from ' | ||
- | ensures that someone cannot guess at the root password from the network. | ||
- | |||
- | Disallow root login remotely? [Y/n] Y | ||
- | ... Success! | ||
- | |||
- | By default, MariaDB comes with a database named ' | ||
- | access. | ||
- | before moving into a production environment. | ||
- | |||
- | Remove test database and access to it? [Y/n] Y | ||
- | - Dropping test database... | ||
- | ... Success! | ||
- | - Removing privileges on test database... | ||
- | ... Success! | ||
- | |||
- | Reloading the privilege tables will ensure that all changes made so far | ||
- | will take effect immediately. | ||
- | |||
- | Reload privilege tables now? [Y/n] Y | ||
- | ... Success! | ||
- | |||
- | Cleaning up... | ||
- | |||
- | All done! If you've completed all of the above steps, your MariaDB | ||
- | installation should now be secure. | ||
- | |||
- | Thanks for using MariaDB! | ||
- | |||
- | |||
- | </ | ||
- | |||
- | ===== Utilisation ===== | ||
- | |||
- | |||
- | ====Création d'une première base de données==== | ||
- | |||
- | <code sql> | ||
- | mysql -u root -p | ||
- | CREATE DATABASE bddtest CHARACTER SET ' | ||
- | </ | ||
- | |||
- | |||
- | ====Création d'un utilisateur==== | ||
- | |||
- | <code sql> | ||
- | mysql -u root -p | ||
- | |||
- | CREATE USER ' | ||
- | GRANT ALL PRIVILEGES ON bddtest.* TO ' | ||
- | flush privileges; | ||
- | </ | ||
- | |||
- | |||
- | ====Import d'une base==== | ||
- | |||
- | <code sql> | ||
- | mysql -u william -ppassword bddtest < dump.sql | ||
- | </ | ||
- | |||
- | |||
- | |||
- | [[systemes: |