On Mon, Dec 14, 2020 at 4:22 AM Joe <j...@jretrading.com> wrote: > > On Mon, 14 Dec 2020 10:01:15 +0100 > deloptes <delop...@gmail.com> wrote: > You don't even need the CREATE USER.
> You can GRANT xxxxxxxx TO 'fred'@'localhost' IDENTIFIED BY 'yyyyyyy' > which will create user and privileges at the same time. > Remember that modern versions of MySQL/MariaDB will not allow logging > in as root unless you are already logged in to the terminal as operating > system root. This means that phpmyadmin, if you use it, cannot login to > the database root account, and you need a differently-named account with > all privileges, including GRANT. Joe, Thanks for the GRANT hint and the reminder to configure users in a terminal as root. No phpmyadmin in use here, I'm using the terminal for everything, same as in my $realjob. Appreciate the reply, I'll try this new info from you and Deloptes and see how it goes. Keith
