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
Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. Solution Locate your my.cnf, or my.ini and change “pass” with … Read more
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
error: Mysql Workbench Table Fetching How did I get to this issue? I got this error after I imported a few tables via dump from my windows machine to my linux machine. Solution: Run the … Read more
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
