[GTALUG] [OT] mySQL help

[ac]

On Wed, 29 May 2019 01:01:23 -0400
Kevin Cozens via talk <talk at 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