DB Creation
***THIS HAS BEEN AUTOMATED***
I MAY AUTOMATE THIS TO HAVE THE LOGIN PAGE CREATE IT IF IT DOES NOT EXIST.
From the root directory of the project type.
sqlite3 dbs/growbox_users_db.sqlite3
CREATE TABLE `users` (`user_id` INTEGER PRIMARY KEY, `user_name` varchar(64), `user_password_hash` varchar(255));
MySQL DB Creation:
DEV PW:HB1KiKnUIgaXm5qx CREATE USER '<user here>'@'%' IDENTIFIED WITH mysql_native_password AS '<password here>'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EXECUTE ON *.* TO '<user here>'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; CREATE DATABASE IF NOT EXISTS `<gbr db here>`; GRANT ALL PRIVILEGES ON `<gbr db here>`.* TO '<user here>'@'%';