banner
阿道

阿道

阿道博客
首页作品集Archives关于我

navicat-BaoTa Panel-How to Connect to MySql Database

#navicat#mysql35
AI Translation
This post is translated from Chinese into English through AI.View Original
AI-generated summary
To allow access to the database, go to the security settings in the management interface and open port 3306. In the database management area, modify user permissions to allow access from all hosts, which increases security risks. Use phpMyAdmin to edit user permissions, changing the host to allow any host. Finally, connect to the database using the Navicat client with the appropriate information, and you should be successfully connected.

Enter the Baota Management Interface - Security - Release Port 3306#

image

Enter the Database Management Interface#

  1. Click Permissions
  2. Change access permissions to all (this will increase security risks)
  3. Submit

image

Edit User Permissions#

  • Enter phpMyAdmin

image

  • User
  • Edit 127.0.0.1 permissions

image

  • Login Information
  • Change Host to any host

image

Connect to the Database with Navicat Client#

  1. Connection in the upper left corner
  2. MySQL
  3. Fill in the corresponding information

image

  1. Successfully connected!

image

Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.