Sorry if this is the wrong area for this. I have an issue with the .bat I've never experienced before. After I created the .bat file from the setup guide I tried using it. When I use the .bat I get the error "error 1045 (2800) access denied for user 'root' @ 'localhost' (using password:YES)"
I'm at a loss for what to do. The path in the variables match with .bat path and I uninstalled/reinstalled to make sure the path was the same.The folder location matches the location listed in the .bat files too. I loaded a few files into the DB and then ran the .bat file. When I double checked the DB the tables were deleted. So its dropping the tables but not importing them. I've entered the password numerous times from scratch thinking I might be entering it wrong by mistake. I've changed all three -p locations in the file to -p(insertpasswordherewithoutaspace). I've even attempted to right click "run as administrator" just doing shots in the dark. As you can tell this isn't my area of expertise ^^; I was hoping that someone might have an answer as to how to fix this.
import.bat file issue
Re: import.bat file issue
You need to edit the batch for the proper username and password that your SQL server is configured for.
Re: import.bat file issue
Thank you for the swift reply sir!
I'm an absolute idiot. All the info was correct but somehow the encoding got changed. I searched back through a back up I made from an old computer and ran that .bat and it worked like a charm. I started flipping through the tabs in notepad++ to see where I had went wrong. Everything was verbatim. That's when I noticed the one I was originally trying to use had a different encoding. I'm not sure how I changed it but I had to have hit a wrong button between paste+save as. I apologize for wasting your time and again, I appreciate you taking the time to help me with this issue ^^;; I just wish I had tried that old file before making this post.
I'm an absolute idiot. All the info was correct but somehow the encoding got changed. I searched back through a back up I made from an old computer and ran that .bat and it worked like a charm. I started flipping through the tabs in notepad++ to see where I had went wrong. Everything was verbatim. That's when I noticed the one I was originally trying to use had a different encoding. I'm not sure how I changed it but I had to have hit a wrong button between paste+save as. I apologize for wasting your time and again, I appreciate you taking the time to help me with this issue ^^;; I just wish I had tried that old file before making this post.