Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "mysql connection Times wrong Access denied for user how to do", interested friends might as well take a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "mysql connection Times wrong Access denied for user how to do" it!

First log in to MySQL locally, and then execute these two lines of code: GRANT ALL PRIVILEGES ON *. * TO root@'%' IDENTIFIED BY '000000'

FLUSH PRIVILEGES

Format: grant permissions on database name. Table name user @ Login Host identified by "user password"

Parameter description: ALL PRIVILEGES represents the permissions assigned to remotely logged-in users, ALL PRIVILEGES represents all permissions, or you can assign select,update,insert,delete permissions individually or in combination *. *: the first * indicates the name of the database to be empowered, * of course it represents all databases, and the second * represents the name of the table under the database, in the same way, * indicates all tables. Of course, lazy people like me will directly use *. * anyway, they are all developed by themselves (not BS me). No, no, no. Root indicates the user to be empowered;% indicates the IP for remote login. If you want to restrict login to IP, add the IP you are allowed to log in, such as 192.18.1.99,% means no restriction on IP (lazy again), and 000000 is the password for the user to log in remotely. It's that simple. Run this sentence and then run FLUSH PRIVILEGES, done!

At this point, I believe you have a deeper understanding of "mysql connection Times wrong Access denied for user how to do", might as well come to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.