Re: Syntax to create admin user for a database

2003-03-14 Thread gerald_clark
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

Syntax to create admin user for a database

2003-03-13 Thread DuSTiN KRySaK
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