mysqldump export access denied for user (MySQLWorkbench) on Windows

10:14:37 Dumping my_table Running: “mysqldump.exe” –defaults-extra-file=”c:\users\ycsoftware\appdata\local\temp\tmp0v6jpl.cnf” –no-create-info=FALSE –order-by-primary=FALSE –force=FALSE –no-data=FALSE –tz-utc=TRUE –flush-privileges=FALSE –compress=FALSE –replace=FALSE –host=localhost –insert-ignore=FALSE –extended-insert=TRUE –user=ycsoftware –quote-names=TRUE –hex-blob=FALSE –complete-insert=FALSE –add-locks=TRUE –port=3306 –disable-keys=TRUE –delayed-insert=FALSE –create-options=TRUE –delete-master-logs=FALSE –comments=TRUE –default-character-set=utf8 –max_allowed_packet=1G –flush-logs=FALSE –dump-date=TRUE –lock-tables=TRUE –allow-keywords=FALSE –events=FALSE … Read more

Import Microsoft Excel data to Mysql

Import Excel To MySQL First fire up your MySQL Workbench editor or your chosen Mysql Client editor CSV LOAD DATA LOCAL INFILE ‘C:\\Users\\ycsoftware\\Desktop\\ycsoftware.csv’ INTO TABLE `ycsoftware`.`ycsoftware` FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED … Read more