LinuxQuestions.org - [SOLVED] Using MySQL with putty

- Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)

- - Using MySQL with putty (https://www.linuxquestions.org/questions/linux-software-2/using-mysql-with-putty-821445/)

Using MySQL with putty

I am configuring home server and I want to use mysql with putty, but this msg appear every time I use mysql command:

ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: NO)

where user is my username. I try with root also but with no success. Same error appear.

Is there any way to configure graphical interface for mySQl like phpmyadmin or mysql administrator in order to execute queries and manage database?

If this is not possible I will stick the way that some ugly "mysql>" appear.

But for now this is not working too. I need some hints what can be done, so i will know what to search and waht to do.

Any hints, help and suggestions are appreciated!

Code:

mysql -u username -p

enter password

Quote:

Is there any way to configure graphical interface for mySQl like phpmyadmin or mysql administrator in order to execute queries and manage database?

Yes. Install and configure phpmyadmin.

ok this with -u and -p parameters works.

I installed phpmyadmin on the box but can't run it. My debian box is without monitor and i use it through ssh. Do I have to configure MySql to access it remotely? Something like xx.xx.xx.xx:3306/phpmyadmin or what?

phpmyadmin is accessed via HTTP, so you have to configure your Web server to serve phpmyadmin's pages.