Skip to content

Digitindo Tech

MySQL

how to mysqldump remote db from local machine

January 28, 2022 by Azzam Jihad Ulhaq
MySQL

Sometimes we need to do a mysqldump of a database on a remote server, but the server does not have mysqldump installed. I would like to use the mysqldump on my machine to connect to the remote database and do the dump on my machine. Create an ssh tunnel Run Mysqldump Command Important Note Do … Read more

Categories MySQL, Web Development Tags MySQL, Tips Leave a comment

Authentication plugin ‘caching_sha2_password’ cannot be loaded

April 24, 2021 by Azzam Jihad Ulhaq
MySQL

To solve this problem we need to change the encryption of the password in our mysql server. Enter your mysql terminal then type this command

Categories MySQL Leave a comment

How to remove newline characters from data rows in MySQL?

April 1, 2021April 1, 2021 by Azzam Jihad Ulhaq
MySQL

Last few days I have trouble with one of my production app. The trouble was I could not get my data through the app even though the data was recorded in the database. To give you a context I will explain my table structure. ID DEVICE_ID NAME 123 JDAHADNW JHON My app saves user’s data … Read more

Categories MySQL, Web Development Leave a comment

Recent Posts

  • How to call curl with get, post, put, delete in php
  • ssh “permissions are too open”
  • Why does Eloquent (in Laravel) change my varchar uuid primary key to an integer ?
  • How to execute thousands of promises in series with batching systems
  • How to validate uploaded files in Node JS

Topics

  • Apache2
  • Datadog
  • Devops
  • Docker
  • Golang
  • JavaScript
  • Laravel
  • Linux
  • MacOS
  • MySQL
  • Ruby on Rails
  • SDET
  • Vue JS
  • Web Development
© 2023 Digitindo Tech • Built with GeneratePress