Creating a Readonly User for Large Screen

Create Readonly User for Large Screens

  1. Login to FactoryWiz with the full admin account
  2. Click the Gear icon in the upper right hand corner for Configuration menu then click the Database option and then the MySQL Console tab
  3. Paste in the following and click EXECUTE: 
    CREATE USER 'mysqlreadonly'@'%' IDENTIFIED BY 'ABC123!';
  4. Paste in the following and click EXECUTE: 
    GRANT SELECT ON factorywiz.* TO 'mysqlreadonly'@'%';
  5. Complete
Notes
NOTE: The password ABC123! is just an example, you can use your own password here.