Hi, 1. FLUSH PRIVILEGES is not needed, the SQL commands to manage user and grants reload automatically the grant tables, that was used in the very past when people use to tinker directly the grant tables.
2. you did not specify the @ part of the 'someone' : GRANT ALL ON somedb.* TO 'someone'@'.....' IDENTIFIED BY 'somepass'; cheers Claudio 2012/3/16 Clemens Eisserer <linuxhi...@gmail.com> > Hi, > > All I would like to do is the create a small database with a non-root > user which is allowed to access the db, however after hours of trying > I gave up. > I am using MySQL-5.5.20 on Fedora16 . > > CREATE USER 'someone'@'%' IDENTIFIED BY 'somepass'; > CREATE DATABASE somedb; > GRANT ALL ON somedb.* TO 'someone' IDENTIFIED BY 'somepass'; > FLUSH PRIVILEGES; > > However, when I try to log in to somedb using someone, I always get: > > mysql --user=someone -p somedb > Enter password: > ERROR 1045 (28000): Access denied for user 'someone'@'localhost' > (using password: YES) > > Any idea whats going wrong here? > Connecting with mysql-workbench seems to work, although I don't see > somedb in the list of databases. > > Thanks in advance, Clemens > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- Claudio
