mysql cycle

Door clemens op ma, 2008/03/03 - 12:18pm

I still forget how to do the database and user creation and drop goes. So why not make a note.

Creating

create database test;
create user 'test' identified by 'pwtest';
grant all on test.* to 'test'@'localhost' identified by 'pwtest';

Cleaning up

drop user test;
drop database;

Yeah ... call me stupid ;-)

Reacties

Anonymous (niet gecontroleerd)

za, 2008/06/14 - 9:58pm

set password for root@localhost=password('secret');