Hello,
When you install percona-server 5.7 from the repository the user mysql doesn’t allow a login shell. Actually, it has been like this for awhile so that is not the issue. My issue is with how to use xtrabackup to backup and restore the database. Assuming I don’t want mysql to have a login shell how do you run xtrabackup as it requires access to the files in /var/lib/mysql. How are people setting up their OS backup users to be able to backup and restore a database on CentOS 7 or any RH derivative. ( perhaps the issue is the same on any OS )
Thanks
Scott.