I did find out how to change MariaDB PW, but am going a different route for the moment. I'll report back if I still can't get it to work. I'm thankful for getting to be on this email list.
On Fri, Sep 23, 2022 at 1:43 AM Michael L <helpwithmath...@gmail.com> wrote: > Hello NLUG, > If this happens to be too much to communicate via email, we're willing to > pay to fix this. > > Our Joomla CMS website is running on a CentOS 7 LAMP stack on Digital > Ocean. We're trying to recreate the site on a different platform and the > web dev needs access to the MariaDB (I know our root PW, but not the > MariaDB PW). > > As root, I ran the following commands: > mysql -u root -p > > > GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION; > > > FLUSH PRIVILEGES; > > It seemed like progress at first, but according to the dev: > > "Seems the permissions didn't stick. Not sure what's going on but I don't > have access to the sql shell on either account. > > And I have some sort of read permission but it's a weird issue. Can't > quite put my finger on it ." > > > This is holding up our progress. I'm guessing for some of you that are > more knowledgeable in Linux / MariaDB, you know the fix. > > > > > > -- -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to nlug-talk@googlegroups.com To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en --- You received this message because you are subscribed to the Google Groups "NLUG" group. To unsubscribe from this group and stop receiving emails from it, send an email to nlug-talk+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/nlug-talk/CALdmzXZ1iMFHxguOAqUDW4aHHEkn8Pey%2But3Hc38RuY8qeHmLg%40mail.gmail.com.