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 Database Backup and Reload
You will need to remote access to the FactoryWiz server to perform these procedures. NOTE: the password portion askusforthispassword in these commands is not the actual password. You will need the actual password for the root user. Please send an ...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
Login to FactoryWiz with the full admin account Click the Gear icon in the upper right hand corner for Configuration menu then click the Database option and then the MySQL Console tab Paste in the following and click EXECUTE: CREATE USER ...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: ...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 · ...