New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
Means the 'db_username' dosen't have the permissions to access 'database'
because you forget tell to 'mysqldump' some extra parameters about user and his password (which have permissions to do something with db).
syntax is next:
@desperand I m having username of mysql = abc_cde and password for that is 1234567
and i m using command mysqldump -u abc_cde -p1234567 abc_cde > abcde.sql
Even though i m getting same error. Plz tell me whre i am going wrong. And one more question we are not giving any path for sql export so where it will be exported???
How about this.
@desperand @edan @AlexanderM
want to first go to mysql prompt... when i put following cmd it shows error
[root@$$$ /]# mysql -u root -p
Enter password: (I have entered here root password)
Reply
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Tell me how to come out of this??
Ubuntu?
@n0my cent os
Are you sure you're using your mysql root pass and not just your root (linux user) password?
@teamacc i have resetted password of mysql and now want to export from old and import to new... is there any perfect tutorial for that ... cent os
http://lmgtfy.com/?q=mysql+export+from+old+and+import+to+new