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]