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
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'