New answers tagged

0

The issue had nothing to do with MySQL parts. It turned out that Linux's firewall and Selinux were blocking access from outside the server. Once turned off, the connection worked perfectly. Two things I learned from this: 1) Check better the ENVIRONMENT before blaming the product, 2) MySQL could improve the clarity of the messages and include environment ...


3

The values you're trying to insert are above the max allowed for a signed INT column in MySQL: 3088727691 > 2147483647 You can either switch it to an unsigned INT to make the max value 4,294,967,295 or a signed BIGINT to give you the room to hit up to 9,223,372,036,854,775,807.


0

You need to restart mysql to see the changes you made. Go to Task manager and click services tab. In the services tab, you can find mysql to restart..


0

The important part of the error log shows your instance is not able to open() the ibdata1 file (for reading and writing). First to check in such situation are user rights. In Windows another possibility is the read-only file attribute which can block writes too.


-1

we already done the master & master replication in locally , so can any one recommended to which cloud is best for my query like (AWS , Openstack,SoftlayerCloud ) on it.


0

I thought this was some kind of auto-save feature from Amazon EC2 instance or some kind of bug, but nope my bad. I found bug report and at the bottom of the page this is the answer: Andres Giordano: This is not a bug!!! You have to go to Edit --> Preferences --> General --> SQL Editor (panel) and uncheck "Save snapshot of open editor...." That's the ...


0

Hex A0 probably came from a Word document, where it is a "hard space". It appears that you did not specify that the source was 'latin1' and the destination is 'utf8'. Otherwise, A0 should have turned into C2A0. That seems correct. However, this seems incorrect: "Driver sends Unicode data as UTF-8". Or perhaps just inconsistent with "Collation ...



Top 50 recent answers are included