I m trying to use mysqldump but getting error mysqldump: Got error: 2003: Can't connect to MySQL server on host(110) when trying to connect

vithya m

4/27/23, 1:16 PM

Here is my sam template for taking database backup trigger:

- none  
  
pool:  
  vmImage: ubuntu-latest  
  
steps:  
- script: echo Hello, world!  
  displayName: 'Run a one-line script'  

- script: |
    sudo apt-get -f install -o Dpkg::Options::="--force-overwrite"
    sudo apt-get update
    sudo apt-get purge mysql\*
    rm -rf /var/lib/mysql
    rm -rf /etc/mysql
    dpkg -l | grep -i mysql
    sudo apt-get clean
    updatedb
    sudo apt-get install mysql-client
  displayName: 'Getting Mysql Client'
- script: |
    mysql -V
  displayName: 'Displaying Mysql Client version'
- script: |
    mysqldump -h host --triggers --routines -u username --password="password" -P 3306 SDA_RMA_DE > dev_sda_db_bkp_test.sql
  displayName: 'Taking Backup'

When I try running pipeline it got failed in taking backup step mysqldump:

Got error: 2003: Can't connect to MySQL server on 'host' (110) when trying to connect

Please help me by saying how to overcome this error

196

0 + 0

database-backup

yaml

azure-devops

Nikita Kipriyanov

4/27/23, 1:21 PM

Do you have a *working* way to connect to mysql on this server? E.g. which application does that and how it is configured?

digijay

4/27/23, 5:37 PM

`-h host` seems to be wrong. Did you mean `-h localhost`?

vithya m

4/28/23, 6:46 AM

No I have given main host only but I didnt mentioned here

vithya m

4/28/23, 6:54 AM

@NikitaKipriyanov Sorry I m very to this templates can you please provide some examples like how it needs to be done

vithya m

4/28/23, 7:01 AM

@NikitaKipriyanov Now maually we are taking backup through ec2 instance only, need to mention that connection here or any other way there please help us we are trying to make it automate through pipeline the above mentioned template is for automating db backup and if you have ay idea on this please let me know

Nikita Kipriyanov

4/28/23, 9:41 AM

You didn't answered to my question at all. Forget about automation until later. Do you have any means to make a working connection to this database server? From the target application, from `mysql` console client? Which options that connection uses?

vithya m

4/28/23, 9:45 AM

In Ec2 instance only connection establishes

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: I m trying to use mysqldump but getting error mysqldump: Got error: 2003: Can't connect to MySQL server on host(110) when trying to connect

TH: ฉันพยายามใช้ mysqldump แต่ได้รับข้อผิดพลาด mysqldump: มีข้อผิดพลาด: 2003: ไม่สามารถเชื่อมต่อกับเซิร์ฟเวอร์ MySQL บนโฮสต์ (110) เมื่อพยายามเชื่อมต่อ

RO: Încerc să folosesc mysqldump, dar primesc o eroare mysqldump: Am o eroare: 2003: Nu mă pot conecta la serverul MySQL pe gazdă (110) când încerc să mă conectez

RU: Я пытаюсь использовать mysqldump, но получаю сообщение об ошибке mysqldump: Got error: 2003: Не удается подключиться к серверу MySQL на хосте (110) при попытке подключения

VI: Tôi đang cố gắng sử dụng mysqldump nhưng gặp lỗi mysqldump: Got error: 2003: Can't connect to MySQL server on Host(110) when try to connect

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.