projet-bdd-dvf/init_database.mysql

9 lines
311 B
SQL

# init.mysql
-- Create the database and user.
-- Usage: $ sudo mysql < init.mysql
# =================================
CREATE DATABASE IF NOT EXISTS bdd_project;
CREATE USER IF NOT EXISTS 'efrei'@'localhost' IDENTIFIED BY 'efrei';
GRANT ALL PRIVILEGES ON bdd_project.* TO 'efrei'@'localhost';
FLUSH PRIVILEGES;