You are mixing table and global grants together here.
Use separate grant commands. I am too lazy to look
it up right now, but FILE is global. I am not sure about
CREATE and DROP.
Aso, I believe that should be 'id'@'127.0.0.1'
not localhost.
localhost always connects to the pipe.
SSH connects to a
Hi there, I am still having issues creating a user that can access a
database. The only time the user can access is if I SSH into my linux box
(redhat 8) and connect with:
# mysql -u id -p
It works fine when doing that, and I can create and do everything I need to
do.
Now - I am trying to conne