Welcome to Open Source Software and Linux Blog.
Hi, everyone!. I just created this blog to share knowledge about open source software and Linux. If you all have knowledge and info related to open source / Linux, please share or send me an email. Thanks ^_^
As default, Mysql database didn't have any password. For some security reason, you need give the Mysql with a password. This is the way how to give the password to your Mysql database.
1. Go in to Mysql by type mysql
2. Type
update user set password=password ('yourpassword') where user='root'; and enter. yourpassword mean enter your own password.
3. Type flush privileges
4. Exit mysql
To test:
1. Go in to Mysql by type mysql -u root -p and enter
2. It promt you to enter the password. Enter you password given before.
3. If you can login with you password, it mean your work is successfully.
No comments:
Post a Comment