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

[John Sellens]

I believe that the password is per-user, not per-database.

So if 'somepassword' is not the same as the existing, you
will likely block access to the other database.

If the user already exists, consider
    grant all on database.* to 'user';

Often you will want to limit source IP addresses as well,
especially if your database is open to the world.

You might also consider one user per database, and
one database per user.

Hope that helps! (Hope I'm not mis-remembering!)

John


On Sun, 2019/01/27 11:50:25PM -0500, 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';
| 
| Doing it a second time seems to kill the web site for the first
| database. How do I correct this for both sites?
| 
| _______________________________________________
| kwlug-disc mailing list
| kwlug-disc at kwlug.org
| http://kwlug.org/mailman/listinfo/kwlug-disc_kwlug.org