Remotely connect to the mysql database .. I have been busy this afternoon and haven't completed mysql remote connection .. Depressing ..
At last, I went back to my home and got online without any comments ..
Haha ,,
The problem is solved ..
The ftp server will be ready tomorrow .. Haha
Netstat-an | grep LISTEN view port
What to do to remotely connect to mysql --
1. go to mysql and create a new user, xuys:
Format: grant permission on database name. table name user @ login host identified by "user password ";
Grant select, update, insert, delete on *. * to xuys@192.168.88.234 identified by "xuys1234 ";
View the result and execute:
Use mysql;
Select host, user, password from user;
You can see that the created xuys user already exists in the user table. The host field indicates the host to log on to. The value can be an IP address or
Host name,
Changing the value of the host field to % indicates that you can log on to the mysql server as an xuys user on any client machine. we recommend that you
Set to %.
Update user set host = '%' where user = 'xuys ';
2../mysqladmin-uroot-ppwd reload
./Mysqladmin-uroot-ppwd shutdown
3../mysqld_safe -- user = root &
Remember: any modification to the authorization table must be reload again, that is, step 1.
If you still cannot connect from the client after the above three steps, perform the following operations to insert a record in the db table of the mysql database:
:
Use mysql;
Insert into db
Values ('2017. 168.88.234 ',' % ', 'xuys', 'y ', 'Y', 'y', 'y ');
Update db set host = '%' where user = 'xuys ';
Repeat steps 2nd and 3 above.