Database Design - Meng-Gen/StockDocs GitHub Wiki

Setup

MySQL Downloads: https://www.mysql.com/downloads/

MySQL Community Server: https://dev.mysql.com/downloads/mysql/

  • Mac OS X 10.12 (x86, 64-bit), DMG Archive
  • (mysql-5.7.19-macos10.12-x86_64.dmg)
  • MD5: 999a9461663f3f873afe0c165316ef86
  • root@localhost: -suqL-rs*2s<

MySQL Client: Sequel Pro: http://www.sequelpro.com/

Trouble Shooting

MySQL said: Your password has expired. To log in you must change it using a client that supports expired passwords.

$ /usr/local/mysql/bin/mysql -u root -p
mysql> SET PASSWORD = PASSWORD('YourPassword');

Create database in MySQL

CREATE DATABASE `stockcats`;
USE `stockcats`;
ALTER DATABASE `stockcats` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Show character set and collation:

USE `stockcats`;
show variables like "collation_database";
show variables like "character_set_database";

Grant Permission

CREATE USER 'stockcat'@'localhost' IDENTIFIED BY 'stockcat';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON *.* TO 'stockcat'@'localhost';

Table details

股票代號與名稱:

資產負債表: (以台積電為例)