That is correct.  The password for mysql root is probably not the same as the
system root.

ddh


Quoting Adrian Cooper <[EMAIL PROTECTED]>:

> Hello,
>
> I need to restore a mySQL dump file but cannot find the right syntax.
>
> I have root access and have used:
>
> mysql -u root -p account_databasename < backupname
>
> But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password:
> YES)
>
> I have also removed the root password and got: Access denied for user
> '[EMAIL PROTECTED]' (Using password: No)
>
> What is the correct syntax please?
>
> Also, can I create a new database and restore the dump file to it or do I
> need to use the same database name as before?
>
> Thank you very much indeed.
>
> Best regards.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>


--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to