Creating a Readonly User for Large Screen

Create Readonly User for Large Screens

How to create readonly user for large screens

  • Login to FactoryWiz with the full admin account
  • Go to CONFIG > DATABASE > CONSOLE
  • Paste in the following and click EXECUTE: CREATE USER 'mysqlreadonly'@'%' IDENTIFIED BY 'ABC123!';
  • Paste in the following and click EXECUTE: GRANT SELECT ON factorywiz.* TO 'mysqlreadonly'@'%';
  • Complete

    • 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. ...

      • 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 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 ...

      • Preparing for FactoryWiz Monitoring

        Preparing for FactoryWiz Monitoring FactoryWiz Installation This document is to help you understand the preparation which is required to ensure that your system deployment goes as smoothly as possible. We want to make sure that you have a good ...