import.bat file issue
Posted: Wed Jul 02, 2014 6:16 pm
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.
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.