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
Rabu, 16 Januari 2008
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar