Monday, September 10, 2012

Kippo - MySQL 101

mysqd_safe --skip-grant-tables;
mysql -u root -p;
use mysql;
update user set password=PASSWORD("testpass") where User='root';
create database kippo;
use kippo;
grant all privileges on kippo.* to 'kippo'@'localhost' identified by 'secret';
flush privileges;


just my copy+paste script, useful for fresh installation

No comments: