I can't connect to my own database, does anyone have a solution?
screenshot attached.
Printable View
I can't connect to my own database, does anyone have a solution?
screenshot attached.
bump, answer plz.
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..
Yeah i know i can do that, kinda wanted a shorter way...
Are you sure you've allowed a connection from "localhost" or have set up the server correctly?
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.
lol u gaved password and user in installation give thos username+pass in mqsl xD it should work!
I am using the username and pass from install, the thing is the SQLyog won't let my adress or localhost connect to it.
....sometimes MySQL does that...atleast for me...
All i did was grant access
Open up MySQL Instance Config or something and type
then typeCode:GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";
If this doesn't work, i have no clue what to do.Code:FLUSH PRIVILEGES;
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
u have to reinstall ur xammp then config gonfig.inc in phpmyadmin folder then try mysql ans sqlyon
dont have xammp at all
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.
Start the MySQL Service.
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?
You know how to operate SQLYog, but don't know about the MySQL service..?