Error on MySQL Data Import

Ask Time：2014-03-10T23:06:54 Author：Ben Drury

I am trying to import to a schema in MySQL workbench but get the following error:

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

I had a similar problem trying to connect originally to the schema and solved it by following the fixes in this post but I can't do this import still. I can now access the schema fine, but when I try to do the import it fails with this same error.

Author:Ben Drury，eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/22303857/error-on-mysql-data-import

More about “Error on MySQL Data Import” related questions

mysql database data import error

When I go to import data into mysql, using the wizard, from a csv file it gives me this error : Starting... Prepare Import... Prepare Import done Import data file.... Traceback (most recent c...
Sqoop MySQL Data import error

I am new to Hadoop world. Just started learning the new things about hadoop. I am getting below error while importing data from mysql to hdfs using sqoop: sqoop:000> sqoop import --connect jdbc...
Error on MySQL Data Import

I am trying to import to a schema in MySQL workbench but get the following error: ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth'
MySQL Data Import Failing With Error -1

I recently backed up a MySQL database in anticipation of a hardware swap out. After installing MySQL on the new hardware I attempted to import the database via MySQL WorkBench. All the tables impor...
import CSV to MySQL error

I'm trying to import 5 columns of data from a CSV to MySQL table. The first column of the MySQL is autoincrement, the first column of the CSV is blank. The following code produces an error. impo...
MySQL Workbench - Table Data Import CSV Error

I am attempting to import a CSV file using MySQL Workbench Table Data Import Wizard. However, I am running into an error. I have tried changing the import settings.
Sqoop Import error while loading data from MySQL to HDFS

I am trying to load data from MySQL to HDFS by using below query: $ sqoop import --connect jdbc:mysql://127.0.0.1:3306/userdb \ --username root --password pwd \ --driver com.mysql.jdbc.Driver --ta...
Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as ERROR 1839 (HY000) at line 24: @@
Import .xlsx data to mysql database

I am working on importing .xlsx data to a MySQL database. The data is uploading perfect if I choose a .csv file, but when I choose a .xlsx file it will insert dummy data. How do I solve this? Here ...
Import data to MySQL Workbench

I have a database with 6 tables, and I want to import these tables to an existing database within MySQL Workbench. I used phpMyAdmin to export the database to a .sql file, and imported it to MySQL

Error on MySQL Data Import

mysql database data import error

Sqoop MySQL Data import error

Error on MySQL Data Import

MySQL Data Import Failing With Error -1

import CSV to MySQL error

MySQL Workbench - Table Data Import CSV Error

Sqoop Import error while loading data from MySQL to HDFS

Import MySQL data failed with error 1839

Import .xlsx data to mysql database

Import data to MySQL Workbench

热门文章

jpg图片怎么转换成pdf，详细教程分享！

iphone怎么把图片转成电子版？试试这2个方法！

图片如何转换pdf文件？看看这三个方法！

怎么把图片转换成pdf格式，干货教程不要错过

png图片怎么转换成pdf，实用方法不要错过

图片怎么转pdf格式？三种转换方法分享给你，一分钟轻松解决

图片转pdf格式怎么弄免费？get这五个简单的方法，轻松搞定！

如何将图片转pdf格式？4种转换方法分享给你，一分钟轻松解决

如何图片转pdf免费？快学习这三种免费转换方法

怎么将图片转pdf？分享个图片转pdf在线免费

相关搜索

jpg图片怎么转换成pdf，详细教程分享

电脑图片转pdf工具怎么用

单张pdf图片转照片格式

如何将图片转成pdf文档，经验分享

这么好用的图片转pdf软件，我一定要分享

干货分享，不懂图片转pdf的朋友快快收藏起来

分享一个让你惊叹不已的图片转pdf方法

图片转pdf工具

分享一个大家都不知道的图片转pdf格式方法

好用的图片转pdf软件要和好朋友分享