> I'm having a problem with MySQL privileges. SeLinux is turned off, so > should not be an issue.
Not sure if this is absolutely necessary in this case, but it never hurts to flush the privileges. mysql> flush privileges; Cheers, Stephen On Fri, 18 Mar 2005 09:54:43 -0700, Charles Curley <[EMAIL PROTECTED]> wrote: > > As root, I can create a database, customers, and grant privileges on > it to user ccurley. > > mysql> select * from db where Db='customers'; > +------+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ > | Host | Db | User | Select_priv | Insert_priv | Update_priv | > Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | > Index_priv | Alter_priv | > +------+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ > | % | customers | ccurley | Y | Y | Y | Y > | Y | Y | N | Y | Y > | Y | > +------+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ > 1 row in set (0.01 sec) > > mysql> show grants for ccurley; > +--------------------------------------------------------------+ > | Grants for [EMAIL PROTECTED] | > +--------------------------------------------------------------+ > | GRANT ALL PRIVILEGES ON `customers`.* TO 'ccurley'@'%' | > ... > +--------------------------------------------------------------+ > 4 rows in set (0.00 sec) > > As the user, I cannot use the database: > > mysql> use customers; > ERROR 1044: Access denied for user: '@localhost' to database 'customers' > > What am I doing wrong? > > -- > > Charles Curley /"\ ASCII Ribbon Campaign > Looking for fine software \ / Respect for open standards > and/or writing? X No HTML/RTF in email > http://www.charlescurley.com / \ No M$ Word docs in email > > Key fingerprint = CE5C 6645 A45A 64E4 94C0 809C FFF6 4C48 4ECD DFDB > > > .===================================. > | This has been a P.L.U.G. mailing. | > | Don't Fear the Penguin. | > | IRC: #utah at irc.freenode.net | > `===================================' > > > .===================================. | This has been a P.L.U.G. mailing. | | Don't Fear the Penguin. | | IRC: #utah at irc.freenode.net | `==================================='
