ERROR 1044 (42000): Access denied for user 'root'

2004-12-15 Thread estoy
Hi, As the root user I created a DB a populated with tables... but when I want to create a user to handle that DB i get this error message: mysql> grant all on db.* to [EMAIL PROTECTED] identified by 'password'; ERROR 1044 (42000): Access denied for user 'root' What could be the reason??? I

Duplicate columns in mysql database

2004-12-13 Thread estoy
Hi, I used mysqldump to recreate the a DB in another machine: % mysqldump -A -u root --opt -p > backup.sql But I guess that duplicates some columns in the mysql database, `cause when want to add a new user to a new database: mysql> grant all on some_db.* to [EMAIL PROTECTED] identified by 'pwd'