Yesterday I applied a query:
Update mytable
set Column1='Value1'
where Column='Value'
and I do not know why strange reason I stop working the application only on my pc, since for other users it still works very well, now when trying to start my application with my user's access, the following message appears:
Unable to connect to server 5 / Unable to connect to any of the specified MySQL hosts
I am thinking that it is a problem of the port that is used 3316 ... Although personally apply a query in MySQL of this type should not affect me according to anything in the connection .
Update
These are the working conditions:
We work in an environment Windows .
If I have access to the server, by means of ping, remote access and even access to the database through the program mentioned SQL yog ultimate .
The firewall is disabled.
I have the program workbench .
Before executing that query I had only executed select's and the query update that caused me the error mentioned, it was executed correctly and the data that I was changing was updated.
From other PCs if the database works very well if there is connection, the error marks it only on my PC and sometimes on other users, but on the other users the error is removed and they can access it.
Generally more access by the application that I mention in the 2% point SQL yog Ultimate and for this if it allows me to access, only it does not allow me to access by an application of the company programmed in VB , but it works correctly in other users, only in my case no.
I was seeing some error log on the server, which may have something to do with what happened:
160727 17:32:32
InnoDB: Error: page 5244 log sequence number 889049262
InnoDB: is in the future! Current system log sequence number 886549248.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: link
InnoDB: for more information.