
MYSQL SET UP 
SET GLOBAL validate_password.length = 8;
SET GLOBAL validate_password.policy=LOW;

CREATE DATABASE site_mermsemr_com;
CREATE USER 'mermsemr'@'192.168.%' IDENTIFIED BY 'may12002'; 
GRANT ALL PRIVILEGES ON site_mermsemr_com.* TO 'mermsemr'@'192.168.%';

CREATE USER 'mermsemr'@'10.%' IDENTIFIED BY 'may12002';
GRANT ALL PRIVILEGES ON site_mermsemr_com.* TO 'mermsemr'@'10.%';
 
FLUSH PRIVILEGES;

https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

  
  
SELECT User, Host, plugin FROM mysql.user;


CREATE TABLE `site_mermsemr_com`.`myfit_contact` (
   `uuid` VARCHAR(32) DEFAULT (uuid()),
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `email` VARCHAR(45) NULL,
  `country` VARCHAR(2) NULL,
  `phone` VARCHAR(15) NULL,
  `message` TEXT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `idmyfit_contact_UNIQUE` (`id` ASC) VISIBLE);



  
  CREATE TABLE `site_mermsemr_com`.`myfit_faq` (
   `uuid` VARCHAR(32) DEFAULT (uuid()),
  `id` INT NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(45) NULL,
  `text` TEXT NULL,
  `added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `idmyfit_faq_UNIQUE` (`id` ASC) VISIBLE);