Build the server. How do I import a database? Let's just get a user.
Database name (already exists): Table
Create a new MySQL user and specify the database to allow remote access
MySQL User: Test
MySQL User password: test666
CREATE USER 'Test'@'%'Identified by 'test666';GRANT GRANT OPTION on *.* to 'Test'@'%';GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP, RELOAD,SHUTDOWN, PROCESS,FILE,REFERENCES,INDEX,ALTER, SHOW DATABASES, SUPER,CREATE TemporaryTABLES, LOCK TABLES,EXECUTE,REPLICATIONSLAVE,REPLICATIONCLIENT,CREATE VIEW, SHOWVIEW,CREATEROUTINE,ALTERROUTINE,CREATE USER, EVENT,TRIGGER on *.* to 'Test'@'%';GRANT SELECT,INSERT,UPDATE,REFERENCES,DELETE,CREATE,DROP,ALTER,INDEX,TRIGGER,CREATE VIEW, SHOWVIEW,EXECUTE,ALTERROUTINE,CREATEROUTINE,CREATE TemporaryTABLES, LOCK TABLES, EVENT on`Table`.* to 'Test'@'%';GRANT GRANT OPTION on`Table`.* to 'Test'@'%';
Simple rough (basic knowledge I will not wordy, my own online search)
Linux allows MySQL users to access remotely