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

Connect to the local mysql mysql-uroot-p # and enter the password to log in to the remote mysql mysql-h210.110.110.110-uroot-p 123; (note: there is no space between u and root, and others are the same)

-- exit mysql

Exit change password: 1 update the fields of the user table in the mysql library: UPDATE mysql.user SET password=password ('newpassword') WHERE user='root'; flush privileges; 2 or use the set instruction to set the root password: SET password for' root'@'localhost'=password ('newpassword')

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.