I have been plagued by a problem when I was studying the LAMP environment. That is, if a website contains a database installation page, it must be installed on the host, that is, it must be installed using localhost. My current environment is installed with X-WINDOWS interface, if not installed? What should I do? So we need to solve this problem.
Today, we finally solved the problem. Just add a Remote user to the MYSQL database:
Add Mysql remote user with Linux OS
MYSQL> grant all privileges on *. * TO color @ localhost identified by 'Password' with grant option;
*: More attention the Capital letters!
*: Add an user 'color' and PWD is 'Password', the authority is local and all databases;
MYSQL> grant all privileges on *. * TO color @ "%" identified by 'Password' with grant option;
*: % => Remote server
*: Set color (password) get all authority to the databaese on the remote server or station.