User Tools

Site Tools




Create a database and a associated user

Connect to the mysql console

mysql -u root -p

Create a database

create database employees;

Show all databases

show databases;

Give access rights to the user

GRANT ALL ON employees.* TO employe@localhost IDENTIFIED BY "secret";

Show access rights for a given user

SHOW GRANTS FOR user_emedia@localhost;

Drop Database

drop database magento;

Delete User

delete from mysql.user WHERE User='name';
/srv/ · Last modified: 2011/07/05 13:24 (external edit)