[Archivesspace_Users_Group] MySQL issue

2020-10-08 Thread Neal, Rick
Good morning, I am having an issue after having upgraded our aspace instance on a new server. I followed the instructions for the database migration and I thought everything was working fine. During troubleshooting an issue with Preservica not being able to connect I find that while the archi

Re: [Archivesspace_Users_Group] MySQL issue

2020-10-08 Thread Blake Carver
Neal, Rick Sent: Thursday, October 8, 2020 8:55 AM To: Archivesspace Users Group Subject: [Archivesspace_Users_Group] MySQL issue Good morning, I am having an issue after having upgraded our aspace instance on a new server. I followed the instructions for the database migration and I thought

Re: [Archivesspace_Users_Group] MySQL issue

2020-10-09 Thread Peter Heiner
Neal, Rick wrote on 2020-10-08 12:55:39: > I then SHOW GRANTS; > > It only lists the grants for the root user. Nothing about the archivesspace > database or user. Plain SHOW GRANTS operates on the current user, root in your case. You need to use SHOW GRANTS FOR 'username'@'host'; p __