MySQL Add remote connection users and view database table structure

One, increase the remote connection user

1. Log in to the database with root privileges

2. Add User: Grant all privileges on * * to "[email protected]' 192.168.1.% ' identified by ' 222 ' with GRANT option;

Where 111 is the account and 222 is: password allowed remote IP segment: 192.168.1.*

3. Remote connection users: Drop user ' 111 ' @192.168.1.% '; or drop user [email protected];

Second, view the data table structure

1. Install software on Windows: "Navicat for MySQL": http://www.navicat.com.cn/download

2. Connect to the database

3. View the data table structure: Locate the database you want to view--right---reverse to the database model ...

　　

　　　

MySQL Add remote connection users and view database table structure