You need to flush privileges to get the new ones active or restart mysql. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 12:55 PM > To: [EMAIL PROTECTED] > Subject: problem > > hi, > I reinstalled mysql again and did what the website said. > > C:\> C:\mysql\bin\mysql -u root mysql > mysql> DELETE FROM user WHERE Host='localhost' AND User=''; > mysql> FLUSH PRIVILEGES; > mysql> QUIT > C:\> C:\mysql\bin\mysqladmin -u root password "newpwd" > C:\> C:\mysql\bin\mysqladmin -u root -h host_name password "newpwd" > > instead of newpwd i wrote zilnoy > instead of hostname i wrote zilsys > > then i said grant all privileges on genome_db.* to [EMAIL PROTECTED] identified > by 'zilnoy'; > > i am getting an error like : > Access denied to user: '@localhost' to database 'genome_db' > > what should i do??????? > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]