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

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

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

Postby didine93 » Mon Jun 22, 2020 6:12 am

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
didine93
 
Posts: 26
Joined: Thu Oct 24, 2019 3:40 pm

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

Postby carpenox » Mon Jun 22, 2020 8:33 am

Try without a password
Alma Linux 9.4 | SVN Version: 3890 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2428
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

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

Postby williamconley » Mon Jun 22, 2020 3:12 pm

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.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 49 guests