- Posts: 2
Mysql Connection problem
- ESteban
- Topic Author
- Offline
- User
Less
More
11 years 8 months ago #2273
by ESteban
Mysql Connection problem was created by ESteban
I want to import from cvs to mysql, I can read the cvs file but went I try to connect to mysql there is a problem. if I write the servername, user and password and test de connection is ok but went I select the database I got an error and is no posible to connect.
the error is : connection could not be established, bad handshake, the problem is the same with any of mysql databases
Thanks
Esteban
the error is : connection could not be established, bad handshake, the problem is the same with any of mysql databases
Thanks
Esteban
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
11 years 8 months ago #2274
by FlowHeater-Team
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Replied by FlowHeater-Team on topic Re:Mysql Connection problem
Hi Esteban,
In case you use an older version than 2.2.0 please try to use the current version 2.5.1. The MySQL Bad Handshake issue for MySQL version 5.5 was solved with version 2.2.0.
In case this does not solve your problem please post your used FlowHeater and also your used MySQL Server version.
In case you use an older version than 2.2.0 please try to use the current version 2.5.1. The MySQL Bad Handshake issue for MySQL version 5.5 was solved with version 2.2.0.
In case this does not solve your problem please post your used FlowHeater and also your used MySQL Server version.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Please Log in or Create an account to join the conversation.
- ESteban
- Topic Author
- Offline
- User
Less
More
- Posts: 2
11 years 8 months ago #2275
by ESteban
Replied by ESteban on topic Re:Mysql Connection problem
yes, I update to 2.5 and works fine, the only problema I still have is I dont want to import the quotation mark "" which is in all columns. is there a way to delete with flowheater before import to database, I tried with the option "without" but nothing change
thank you
Esteban
thank you
Esteban
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
11 years 8 months ago #2276
by FlowHeater-Team
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Replied by FlowHeater-Team on topic Re:Mysql Connection problem
Hi Esteban,
You just have to use the option "abc".
This means
On the READ side, importing) Are in your CSV file the data enclosed by quotation marks FlowHeater removed this during the import process.
On the WRITE side, exporting) FlowHeater enclose your data with quotation marks during the export.
You just have to use the option "abc".
This means
On the READ side, importing) Are in your CSV file the data enclosed by quotation marks FlowHeater removed this during the import process.
On the WRITE side, exporting) FlowHeater enclose your data with quotation marks during the export.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Please Log in or Create an account to join the conversation.
Time to create page: 0.262 seconds