MYSQL - CREATE command denied to user
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’;
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.