User Tools

Site Tools


database:mysql:start

MySQL

Index

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/wiki.niwos.com/data/pages/database/mysql/start.txt · Last modified: 2011/07/05 13:24 (external edit)