Thanks for that. When
I try run that query I get -bash: syntax error near unexpected token `('
And I also cant get to mysql as root it just says access denied.
Every time I make changes i.e change a password for a user or update details the server restarts and I get a "Bad Gateway" error any idea what could be causing this?
Thanks