On Tue, 2004-03-30 at 13:48, Michael S. Dunsavage wrote: > I get the following error when I do > > mysql -u mikesd -p > > ERROR 1045: Access denied for user: 'mikesd@localhost' (Using password: YES) > > > the user mikesd exists. > > I did > > mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'localhost' > -> IDENTIFIED BY 'pass' WITH GRANT OPTION; > mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'%' > -> IDENTIFIED BY 'pass' WITH GRANT OPTION; > mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost'; > mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost'; > > > What else? > > -- > Michael S. Dunsavage > look at mysql.user mysql>select host,user from mysql.user; do you get | localhost |mikesd | returned ? I've always added users without the quotes around the @ MYSQL>grant all privileges on *.* to mikesd@localhost idenified by 'pass'; MYSQL>flush privileges; -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
