Wednesday, July 25, 2018

SOLUTION: RESET MYSQL root password

PROBLEM:
-PHPMYADMIN SHOW "NO" FOR GRANT PRIVILEGES FOR ROOT USER
-CANNOT GRANT PRIVILEGES FOR USERS
-RASPBIAN / DEBIAN


SOLUTION:
  1. STOP MYSQL
    sudo service mysql stop     OR      sudo killall mysqld
  2. START MYSQL SKIPPING PRIVILEGES sudo mysqld_safe --skip-grant-tables &
  3. CHANGE PASSWORD FOR ROOT USER
    SET PASSWORD FOR 'root'@'localhost' = PASSWORD("newPassWD");
  4. FLUSH PRIVILEGES
    FLUSH PRIVILEGES;
  5. STOP AND RESTART MYSQLD
     sudo killall mysqld | sudo service mysQL start





SOLUTION: mysql root cannot grant privileges for database


PROBLEM:
-PHPMYADMIN SHOW "NO" FOR GRANT PRIVILEGES FOR ROOT USER
-CANNOT GRANT PRIVILEGES FOR USERS
-RASPBIAN / DEBIAN


SOLUTION:
  1. STOP MYSQL
    sudo service mysql stop     OR      sudo killall mysqld
  2. START MYSQL SKIPPING PRIVILEGES sudo mysqld_safe --skip-grant-tables &
  3. GRANT PRIVILEGES for root user
    UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
  4. FLUSH PRIVILEGES
    FLUSH PRIVILEGES;
  5. STOP AND RESTART MYSQLD
     sudo killall mysqld | sudo service mysQL start


Saturday, July 14, 2018

STEM LAB IDEA

https://www.lib.polyu.edu.hk/makerspace/iot

Free 3D Print Model Download / Free Laser Cut CAD Download

3D Print
https://www.thingiverse.com/
https://grabcad.com/library
https://www.cgtrader.com/free-3d-models
http://3dsky.org/
https://www.myminifactory.com/
https://gallery.autodesk.com/
https://cults3d.com/en/creations/latest/page/1?direction=asc&sort=download_price_cents
http://www.free-3d-models.com/
https://www.turbosquid.com/Search/3D-Models/free
http://www.3dxtras.com/
https://free3d.com/3d-models/






Laser Cut
https://www.librarylaser.com/en/
https://www.vecteezy.com/free-vector/laser-cut
https://obrary.com/collections/open-designs
https://www.bosslaser.com/laser-files/downloads/
https://www.freepik.com/free-photos-vectors/laser-cut
https://dxfprojects.com/root/tag/67-free-download
https://grabcad.com/library/tag/lasercut

Sunday, July 8, 2018

MAC Shortcut Key to Convert to Simplified Chinese / Traditional Chinese




To Simplified Chinese:
Shift Control Option Command C

To Traditional Chinese
Shift Control Command C