On Wed, 29 May 2019 01:01:23 -0400 Kevin Cozens via talk <talk@gtalug.org> wrote:
On 2019-05-28 7:50 p.m., Stephen via talk wrote:
It has been years. I am creating a new site with database but I can't get the user to have privileges. Can anyone spot what is wrong?
You may find it useful to install phpMyAdmin. It simplifies administration of MySQL.
depending on mysql version, etc I have found that with or without phpMyAdmin, one may still have to do FLUSH PRIVILEGES; or mysqladmin flush-privileges or mysqladmin reload etc afaik maria (and later/newer? versions of mysql?) automagically flushes and reloads grant tables, when not using insert/update/del but older vers of mysql may not...(of course if you are mod grant tables without using grant you have to flush anyway) hth Andre