Alan Morey wrote:
> I connect to the mysql database, as root
> mysql> GRANT SELECT, INSERT, DELETE UPDATE ON mydatabase.* TO user@stripped
> IDENTIFIED BY 'blah' ;
> mysql> GRANT SELECT ON mydatabase.* TO user2@% IDENTIFIED BY 'bahh';
> But when i try to connect to the mydatabase i get access denied. Any ideas
> what i'm doing wrong
> I am trying to make a web interface to the database and i want two users,
> one user should be able to SELECT, INSERT, DELETE UPDATE and the should
> just be able to SELECT.
You are not specific enough.
Did you try the 'user' account from host '10.0.0.1' and is this _not_ equal to
Did you give the password on connecting?
shell> mysql --user=user --password=blah --host=mysql.machine.com mydatabase
If you tried the 'user2' account from 'localhost', you probably collided with the user
enty for ''@localhost (read: everyone from localhost).
It always is good to give at least some infos about your OS and the mysql version you use.
PS: Sorry for the late answer, I was on vacation.