Hey guys, I created a remote mysql base on tutorial here https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql . However I failed to create tables from the remote site.
Here command I ran
On Database Server:
create databases test; create user ‘test’@‘localhost’ identified by ‘password’; create user ‘test’@‘web_server’ identified by ‘password’;
grant all privileges on test.* to ‘test’@‘localhost’; grant all privileges on test.* to ‘test’@‘web_server’;
flush privileges;
I successfully conencted but failed to create tables; Due to command denied user…
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi! Could you give an example of how you tried to create a table? You need to make sure that the table is in the
test
database as thetest
user only has permissions there. For example, this would create a table namedtable
in the `test: database:The result is:
Check out this article for more information on working with MySql: