How do I send a MySQL database to AYS?
You must first export (or dump) the MySQL database from the database server before it can be sent to AYS. Here are two options for creating that file to send to us.
mysql
How to Configure MySQL for AYS
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.
Error -2147467259 – MySQL “Malformed communication packet”
You may encounter the following error with MySQL Server 8.0.25 or below when adding a new record:
Moving AYS From One Server to Another
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.
Which MySQL versions are supported?
At Your Service – Repair Center works with the following MySQL versions:
Error -2147206396 – Not Supported
Can AYS run on Linux?
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 AYS program is not compatible with emulated Windows environments on Linux (such as Wine).
Error -2147024882 – Memory allocation error
MySQL Client Setup
The following is how to connect from a desktop to an existing MySQL server on your network.
MySQL System Requirements
Here are the requirements for setting up an At Your Service installation to connect to MySQL Server.