[MySql problem] SQLyog won't let me connect!

[dbzsv34]

I can't connect to my own database, does anyone have a solution?

screenshot attached.

 

[dbzsv34]

bump, answer plz.

 

[CallProcedure]

Kay..Answer my question too lol..I had this problem..But try uninstalling and deleting the MySQL folder then reinstall and place the DB's back..

 

[dbzsv34]

Yeah i know i can do that, kinda wanted a shorter way...

 

[madsniper]

Are you sure you've allowed a connection from "localhost" or have set up the server correctly?

 

[dbzsv34]

It worked before, until yesterday, don't know how to allow connection.

also, my site says this: Error: Unable to connect to MySQL server. MySQL reported: Host 'web5.byetcluster.com' is not allowed to connect to this MySQL server.

 

[ghostrevan]

lol u gaved password and user in installation give thos username+pass in mqsl xD it should work!

 

[dbzsv34]

I am using the username and pass from install, the thing is the SQLyog won't let my adress or localhost connect to it.

 

[Juggalo90]

....sometimes MySQL does that...atleast for me...
All i did was grant access
Open up MySQL Instance Config or something and type

GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";

then type

FLUSH PRIVILEGES;

If this doesn't work, i have no clue what to do.

 

[dbzsv34]

I ran the MySQL server instance configuration wizard, after hitting execute at the end he gives out an error: The security settings could not be applied to the server because connection has failed with the following error: host 'localhost' is not allowed to connect to this MySQL server.

what gets me right were i was...

I think i need some professional help. :S

 

[devilat]

u have to reinstall ur xammp then config gonfig.inc in phpmyadmin folder then try mysql ans sqlyon

 

[dbzsv34]

dont have xammp at all

 

[Shadei]

It would be easiest just to go ahead and backup all your databases you need. Uninstall MySQL and go to \Program Files and delete the MySQL folder and reinstall.

 

[Paco44]

Start the MySQL Service.

 

[dbzsv34]

First of all, can't backup because i can't log-in to the SQLyog.
Second of all, i'm lucky that i did backup few days before.

And what MySQL service?

 

[Paco44]

You know how to operate SQLYog, but don't know about the MySQL service..?