Shulou(Shulou.com)06/01 Report--

How to set password for mysql

The newly installed mysql does not have a password by default. Let's directly root users into mysql.

There are many ways: 1. Enter mysql with root and mysql > set password = password ('your password'); mysql > flush privileges;2. Use the phrase mysql > all on *. * to 'root'@'localhost' IDENTIFIED' your password 'with option; mysql > flush privileges;3. Go to the mysql library and modify the user table mysql > use mysql;mysql > update user set password=password (' your password') where user='root'; mysql > flush privileges

Java Technology Exchange Group: 251303758

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.