Trying to connect directly to a mysql database using SQLYog
Posted on 2006-03-26
Ok, for those of you that dont use SQLYog (I feel bad for you if your using phpmyadmin crap) it allows you to either connect directly to a mysql database or to connect threw what it calls a tunnel. Which is basically a php script on the server that the program uses as an interface to the server. The tunnel works just ducky but sqlyog pro does not support tunnelling and the trial to enterprise ran out. I already paid 9 bucks for pro and I dont want to pay another 70 for enterprise. I have a dedicated server with the mysql database on it and I have ssh access, and plesk ofcourse to do whatever I want with the thing. So I see no reason why I shouldn't be able to connect directly to the mysql server. I have used my login and password in ssh to log into the mysqladmin interface. I use the user and password to connect in my php files so I know the user/pass I am trying to use is valid. When I try to connect in sqlyog it says error # 1045, access denied for bla bla bla, user password (yes). Same thing I get in ssh if I use a bad user/pass. This tells me it is communicating with the mysql server because if I put in a bad ip address it just times out. Like I said I know the user/pass I have is good. Anyone have any idea what might be causing this? I've tried refreshing the mysql server but the damn thing tells me I dont have permission. Which is really weird because my user/pass should have full access to everything because its the account I gave to it in plesk. I'm not opposed to reinstalling the damn mysql server. But I tried the other day and got a bit frightened off by all the dependencies it gave. Plesk gives me like next to no help... I'm logging into plesk with the admin account and it doesn't let me do much of anything with database. I can alter my account and change a few preferences but its pretty limited. Which doesn't surprise me, sometimes I think I would have been better off not getting plesk and just forcing myself to learn all the stuff I need to learn to administer threw ssh. Well I hope someone can help me with this.