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.

    • Related Articles

    • User Being Signed-Out

      User Configuration User Being Signed-Out If you'd like to change the time out value to prevent users from being signed out, you can modify this setting on the server in the Internet Information Services Manager. Default time out value = 20 minutes. ...

    • Power BI example with FactoryWiz data

      Create a MySQL database user for by following these instructions https://kb.factorywiz.com/portal/en/kb/articles/create-readonly-user-for-large-screens Then create a System DNS on your computer by following these instructions ...

    • Installing an ODBC Connector for FactoryWizTV

      Configuring FactoryWizTV Installing an ODBC Connector for FactoryWizTV NOTE: You will need to create a new ReadOnly user in the MySQL database before proceeding with these instructions Please follow this article to create a new ReadOnly user. ...

    • 10.2 ODBC Installation

      If you wish to connect a computer on your FactoryWiz network to the FactoryWiz database for things such as Microsoft Excel, you can use an ODBC connector. Normally we will install the 32bit MariaDB/MySQL ODBC Connector for things such as FactoryWizTV ...

    • Flipper Not Working from Windows Startup Folder

      For when the application will launch but does not cycle the screens. Updating windows registry to overcome the issue HKEY_CURRENT_USER\Control Panel\Desktop Right click on ForegroundLockTimeout > modify Change value to 0, and base to decimal. This ...