Stop mysqld_safe Safely

After running “mysqld_safe –skip-grant-tables”  you may notice that the process is still running. Instead of killing the process by running: kill -9 process ID you can safely kill mysqld_safe by running the following command: mysqladmin shutdown

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