Page 1 of 1

"Access denied for user 'root'@'localhost'

PostPosted: Mon Jun 22, 2020 6:12 am
by didine93
Hello ;
version: Vicibox 9.0.2
when i try to restore the asterisk backup by typing the following command mysqldump -p asterisk <192.168.1.7asterisk1 it shows me this message ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)
thank you in advance for your help

Re: "Access denied for user 'root'@'localhost'

PostPosted: Mon Jun 22, 2020 8:33 am
by carpenox
Try without a password

Re: "Access denied for user 'root'@'localhost'

PostPosted: Mon Jun 22, 2020 3:12 pm
by williamconley
didine93 wrote:Hello ;
version: Vicibox 9.0.2
when i try to restore the asterisk backup by typing the following command mysqldump -p asterisk <192.168.1.7asterisk1 it shows me this message ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)
thank you in advance for your help

1) mysqldump is used to create a .sql backup file. It is NOT used to restore a mysql database.

2) To restore a mysql database, you use "mysql" (without the dump).

3) If you don't know the password, you can make a few guesses on the command line (it won't lock you out no matter how many bad tries you make). But if you've not SET a password for the "root mysql user", then you can just leave off the "-p" from the command line, and it will assume the root user has NO password.