Mysqldump: Using a password on the command line interface can be insecure. Local | mysqldump -host=127.0.0.1 -user=xxxxxx -password=xxxxxxxxxx -result-file="/Applications/AMPPS/xxxxx ❌ error | We can't connect to the MySQL server using credentials ✅ success | mysqldump command is in $PATH ❌ error | '': not matched to pattern /^https?:///. Thanks so much for responding quickly, and apologies for my limited knowledge of CLI. Otherwise I think it's another story and another issue. Mysqldump: Got error: 1045: Access denied for user 'xxxxx (using password: YES) when trying to connecĬould or could not be a related error: if the mysqldump executable is not the expected one, then it's probably related because you have more mysql versions and more clients (mysql/mysqldump are clients to MySQL server) trying to connect to different versions. Ssh which mysqldump should give the expected path on your remote server. Which mysqldump should give your expected path. Generally speaking this is an environment problem I'd like to avoid to tell to wordmove an exact path of the binaries since having binaries in $PATH is a start point to work in a CLI environment. It's useful just for you to know where you have binaries. Locate mysqldump does not mean anything from the executable commands perspective, so I'd advise about simply ignore that information.
Keep in mind that on pull or push we're always doing a connection to both local db and remote db: 1 for the backup and 2 for the export than back to 1 for the import, whatever 1 and 2 would be local or remote. Regarding this error, I had also replied to this ticket a couple of years ago (apologies for not replying to the last comment), where it seems the error may be related to the live server and not my local?Īny ideas how this should be are you able to tell us if the error is local, remote or both? It should be easy to understand from wordmove's logs. Mysqldump: Got error: 1045: Access denied for user 'xxxxx (using password: YES) when trying to connect Now the error when attempting to pull a remote db is: There is also a ticket on flywheel regarding the same issue.
I found a related issue here and also posted on SO And of course every change requires a restart of iTerm!! Otherwise it gives mysql: aliased to nocorrect mysql. Which mysql gives mysql not found (when unalias mysql is uncommented in. Applications/AMPPS/mysql/bin/mysqldump /Applications/AMPPS/mysql/bin/mysqldumpslow /Applications/AMPPS/mysql/man/man1/mysqldump.1 /Applications/AMPPS/mysql/man/man1/mysqldumpslow.1 If which rbenv > /dev/null then eval "$(rbenv init -)" fiĮxport locate mysqldump now at least gives: It seems I need to tell bash (referenced from zsh) to use /Applications/AMPPS/mysql/bin/mysqldumpĮxport PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin/mysql:/usr/local/mysql/bin/mysqldump:/Applications/AMPPS/mysql/bin/mysqldump:$PATH" I am guessing that the wrong mysqldump is being referenced, since I went ahead and installed the mysql pkg installer (which was missing for some reason) that is now located at /usr/local/mysql/bin/mysql Even though I am using Zsh, the original error I was getting was:įollowing on from my previous comments on the above referenced issue, I am not using vagrant, just AMPPS and Flywheel on OSX. I have narrowed the problem down to Bash not knowing where mysqldump is installed.
#CANNOT ACCESS SQLITEMANAGER IN AMPPS CODE#
However, that code has now forked in a few repos and I cannot get any of them to work anymore, hence needing this to work as the only alternative to using a less than ideal plugin or manually search/replacing urls in the db. I could never get the db to push or pull (everything else worked great) and so just resolved to use WP Migrate DB plugin. It seems many people have been struggling with this one. I left a couple of comments on an old and closed issue, but perhaps better to open a fresh one to get to the root of this.
0 kommentar(er)
