[kwlug-disc] Messing up site database (mysql)

[Khalid Baheyeldin]

On Sun, Jan 27, 2019 at 11:50 PM Charles M <chaslinux at gmail.com> wrote:

> I've run into this issue once before. I created a database for my
> website in mysql. Then I created a second database and granted
> permissions the same way:
>
> grant all on database.* to 'user' identified by 'somepassword';
>

Did you remember localhost?

grant all on db.* to 'user at localhost' idenitified by 'password';

Doing it a second time seems to kill the web site for the first
> database. How do I correct this for both sites?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://kwlug.org/pipermail/kwlug-disc_kwlug.org/attachments/20190128/69930006/attachment.htm>