Can't access MySQL in a new instance created from a snapshot

Question

SSH was corrupted in my Lightsail instance.
I have created a manual snapshot from my instance.
Using this snapshot I have created another instance.
I was able to reach this instance using SSH.
This time I was unable to reach MySQL via console of this newly created instance. 
Trying to start/restart the service didn't work at all.
The error output is as follows:

```
root@ip-172-26-7-211:/home/bitnami# mysql -u root -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp
/mysql.sock' (2)
```
In fact there is no mysql.sock file at this location.

AGIdil · Answer

I have added

```
innodb_force_recovery = 1
```
in
```
 /opt/bitnami/mariadb/conf/my.cnf
```
under [mysqld] and executed the following:
```
root@ip:/opt/bitnami# mysqld --skip-grant-tables --user=mysql --skip-external-locking --port=3306 --sock=/opt/bitnami/mariadb/tmp/mysql.sock
```
Then I was able to connect to MySQL console issuing

```
mysql -u root -p
```

Gary Mclean · Answer

Try connecting via the IP instead of the socket

`mysql -h 127.0.0.1 -P 3306 -u root -p `

Also see if its running `telnet 127.0.0.1 3306`

AGIdil · Answer

```
root@ip:/opt/bitnami# ./ctlscript.sh status
apache already running
mariadb not running
php-fpm already running
root@ip:/opt/bitnami# ./ctlscript.sh start mariadb
Started mariadb
root@ip:/opt/bitnami# mysql -h 127.0.0.1 -P 3306 -u root -p my_database
Enter password: 
ERROR 2002 (HY000): Can't connect to server on '127.0.0.1' (115)
```
Telnet is disabled.

AGIdil · Answer

```
root@ip:/opt/bitnami# ./ctlscript.sh status
apache already running
mariadb already running
php-fpm not running
root@ip:/opt/bitnami# netstat -an | grep 3306
root@ip:/opt/bitnami# netcat to 127.0.0.1 
3306
netcat: port number invalid: 127.0.0.1
```

```
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name  
  
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1443/sshd: /usr/sb
i 
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      696/sendmail: MTA:
  
tcp        0      0 127.0.0.1:587           0.0.0.0:*               LISTEN      696/sendmail: MTA:
  
tcp6       0      0 :::22                   :::*                    LISTEN      1443/sshd: /usr/sb
i 
tcp6       0      0 :::443                  :::*                    LISTEN      839/httpd         
  
tcp6       0      0 :::80                   :::*                    LISTEN      839/httpd         
  
```

Gary Mclean · Answer

What results are returned with `netstat -an |grep 3306` ?
Is NC installed? netcat to 127.0.0.1 3306

Can't access MySQL in a new instance created from a snapshot

Relevant content