8.3.5 MySQL Console
FactoryWiz™ Monitoring provides a MySQL command console to
access the database directly using T-SQL database commands.
FactoryWiz™ recommends that only users with MySQL experience and training be authorized to open this console.To access the console, click on the MySQL Console tab in the Database
Configuration.
Related Articles
MySQL Too Many Connections
Too Many Connections We recommend taking a back up of your server beforehand. Set the following: You need to create 2 new DWORDS in the Registry. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters Value Name: MaxUserPort Data Type: ...Receiving Blank or Unknown Emails From FactoryWiz
Email Troubleshooting Email Configuration Settings To find out where emails are being sent from, go to the MySql console in FactoryWiz CONFIG > Database > Console. Run the following command: select * from emailqueue order by eqadded desc limit 100 ...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 ...11 External Documentation
FactoryWiz uses multiple external libraries and software packages. Here are links to vendor resources and manuals. · MySQL Database · Adam APAX Utility · Adam APAX Utility Manual · Moxa Device Manager Software · Moxa Nport Manual · Comtrol Manual · ...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. ...