Specific MySQL server permissions are necessary for AYS users to access the data and run reports. Some additional permissions may be necessary for those that administer the AYS database on the server. This article will assist you in configuring the security on MySQL for both of these cases.
You may encounter the following error with MySQL Server 8.0.25 or below when adding a new record:
When you change or upgrade hardware you may wish to relocate the AYS application or data to another server. Depending on your edition and setup, you can follow one of the following procedures.
At Your Service – Repair Center works with the following MySQL versions:
MySQL databases may be installed natively on a Linux server.
Microsoft Access databases may be hosted on a Linux server using Samba file sharing for Windows clients.
The AYS program itself was designed to work on Microsoft Windows operating systems and is not officially supported on Linux desktop operating systems.
However, the AYS program can be run on a Linux desktop operating system by using one of the following methods:
- Remote client software (such as Citrix XenApp)
- A virtual machine running a Windows operating system (such as VMware).
The following is how to connect from a desktop to an existing MySQL server on your network.
Here are the requirements for setting up an At Your Service installation to connect to MySQL Server.