First I must say that it's the first time I'm doing this kind of stuff, I'm a bit confused. I've uploaded a MySQL database to a website I bought few hours ago which I can access through PHPMyAdmin. I'd like to connect remotely to this database from a Linux PC, through terminal using mysql command line, something like mysql -u "user" -p "password" -h "hostname".

If I try this I get an error:

ERROR 1045 (28000): Access denied for user 'user_xxx'@'xxx.xx.xxx.xx' (using password: YES)

Searching on the internet I found that PHPMyAdmin blocks the possibility to access the database remotely, and it seems I can't manage to change this in the website control panel.

Is there a way to solve this?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.