Rabu, 16 Januari 2008

Forget Your Root Mysql Password ?

How to create user in mysql?
It’s easy, run this:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'easy'@'localhost'
-> IDENTIFIED BY 'secret' WITH GRANT OPTION;

How if we forget our root password in mysql?
It’s very easy, run this:

- shutdown mysql
- # safe_mysqld --skip-grant-tables &
- # mysql -u root
- update user set password=password('new_password') where user='root';
- start mysql
- # safe_mysqld &

---
easy

Tidak ada komentar: