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

The following is about using navicat to connect to a mysql remote database. The secret of the text is that it is relevant to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article of using navicat to connect to mysql remote database.

Navicat for mysql connects to the remote database:

(1) mysql-u root-p # log in to the database

(2) use mysql # uses mysql database

(3) update user set host= "%" where user='root' # modifies the user table% to indicate that all sources can log in to the database as root users.

(4) flush privileges; # refresh permission table

(5) remote login with navicat.

Is there anything you don't understand about using navicat to connect to a mysql remote database? Or if you want to know more about it, you can continue to follow our industry information section.

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.