I usually have to specify a database.  
use dbname
grant all on dbname...

I have not ever used phpmyadmin, but I am cautious about it, because malicious scripts are searching my websites for it all day, every day for at least the last 15 years.

On Wed, May 29, 2019, 01:01 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.

--
Cheers!

Kevin.

http://www.ve3syb.ca/               | "Nerds make the shiny things that
https://www.patreon.com/KevinCozens | distract the mouth-breathers, and
                                     | that's why we're powerful"
Owner of Elecraft K2 #2172          |
#include <disclaimer/favourite>     |             --Chris Hardwick
---
Talk Mailing List
talk@gtalug.org
https://gtalug.org/mailman/listinfo/talk