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