Mysql could not be started

shlomi_la 2017-01-06 21:01:25 UTC #1

Application name and version:
Is it an installer, cloud image or virtual machine?:
Operative system/Platform (Linux, Windows, OSX)(x86/x64):
Was it installed as the root user?

Is there anything you've done and/or tried with the application before posting here?
E.g. changed permissions or installed a plugin:

I tried to BU mysql database.
The problem started when my password to access mysql root didn't work.
I tried to change it, and during the process I wasn't be able to access mysql anymore.

This is what i got when tried to restart mysql -

bitnami@ip-172-31-33-187:~$ sudo /opt/bitnami/ctlscript.sh restart mysql
Unmonitored mysql
/opt/bitnami/mysql/scripts/ctl.sh : mysql not running
2017-01-06T20:46:07.824903Z mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
2017-01-06T20:46:07.842763Z mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
2017-01-06T20:47:48.673046Z mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/mysqld.pid ended
/opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started
Monitored mysql

And the status -

bitnami@ip-172-31-33-187:~$ sudo /opt/bitnami/ctlscript.sh status
php-fpm already running
apache already running
mysql not running

This is a system in a pilot with customers, i really need your help.
Thanks in advance

silvio 2017-01-09 12:11:16 UTC #2

Hi,

Could you please provide us a little more information?
- Are you using this application in a Cloud Provider (AWS, Google, Azure, ...) native installer (Windows, Linux,...) VMs
- Which exact version of the application are you using?
- Have you installed any plugin or modified any configuration file?

Anycase you can try to reset your root password following this instructions: https://docs.bitnami.com/google/infrastructure/mysql/#how-to-reset-the-mysql-root-password

Apart from the above information, could you send us this file: /opt/bitnami/mysql/data/mysqld.log?

Have you modify any permission in your system?

Best regards,
Silvio Fernández

Radnosedu 2017-01-11 00:57:21 UTC #3

I have the same problem in Google Cloud.

I've tried this:

~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/bitnami/mysql/tmp/mysql.sock' (2)
~$ sudo /opt/bitnami/ctlscript.sh status
php-fpm already running
apache already running
mysql not running
~$ sudo /opt/bitnami/ctlscript.sh start mysql
2017-01-10T23:50:59.532217Z mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
2017-01-10T23:50:59.548495Z mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
2017-01-10T23:51:02.200108Z mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/mysqld.pid ended
/opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started
Monitored mysql
~$ mysql -h localhost -P3306 -u root -p --protocol=tcp
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (111)
~$ sudo /opt/bitnami/ctlscript.sh start mysql
2017-01-11T00:07:26.383452Z mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
2017-01-11T00:07:26.401767Z mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
2017-01-11T00:07:29.019751Z mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/mysqld.pid ended
/opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started

MySql version 5.7.16

I just deleted all records from 1 database of like 5 and tried to configure wordpress to the empty database.

I appreciate some help.

Thank you!

silvio 2017-01-12 09:48:16 UTC #4

Hi,

Your mysqld is not starting. Could you please is your disk is out of space using df -h.

If you are not out of space, could you send us the content of this file: /opt/bitnami/mysql/data/mysqld.log

Best regards,
Silvio Fernández

Not able to connect MySQL DB. “Error establishing a database connection”

Radnosedu 2017-01-13 23:26:39 UTC #5

Hello Silvio,

That was a new bitnami instance, I had almost nothing in the server and the problem came after I trucate some tables from my database via phpmyadmin.

To work around, I just deleted the bitnami instance and created a new one. So I can't to show you the log file

Anyways, thank you so much for trying to help me.

andrescaroc 2017-07-29 17:20:09 UTC #6

Hello,

I'm having the same problem mysql could not be started

What happened?
I was doing a backup of my wordpress as @marcos teach me here https://goo.gl/9ayCf7
I have done this like 5 or 6 times without a problem, but today mysql could not start.

The only thing I changed from before is that used sudo su bitnami as @jota teach me here https://goo.gl/Z5NwUo

I´m trying to output the content of the log file as @silvio asked, but:
bitnami@wordpress-multisite-1-vm:/home/xtartu$ tail -n 100 /opt/bitnami/mysql/data/mysqld.log
tail: cannot open ‘/opt/bitnami/mysql/data/mysqld.log’ for reading: Permission denied

My site is down, thanks for your help.
Regards,
Andres

jariza 2017-07-31 10:30:22 UTC #7

Hello @andrescaroc

Could you please detail the steps you deployed in order to backup your WordPress. Please detail as much as possible the user you're using in every step.

Regarding the error you found:

tail -n 100 /opt/bitnami/mysql/data/mysqld.log
tail: cannot open ‘/opt/bitnami/mysql/data/mysqld.log’ for reading: Permission denied

You can workaround it by using sudo. Please run the command below:

sudo tail -n 100 /opt/bitnami/mysql/data/mysqld.log

Best Regards,

Juan Ariza

andrescaroc 2017-07-31 12:38:33 UTC #8

Hi @jariza,
Thanks for your reply.

This are the steps I followed to do the backup:
sudo su bitnami
(This was the first time I used this command, sugested by jota in another thread)
Then
sudo /opt/bitnami/ctlscript.sh stop
Then,
sudo mkdir -p /opt/bitnami-backups/2017-07-28
sudo cp -R /opt/bitnami /opt/bitnami-backups/2017-07-29
(Here I made a mistake, I created a folder dated at 28th, but copied the bitnami into an folder dated at 29th that wasn't created. How ever i checked the content of the folder dated at 29th and there was the content of the bitnami folder and the folder dated at 28th was empty. So I think the folder dated at 29th was created automatically when I used the cp command)
Then,
sudo /opt/bitnami/ctlscript.sh start
Here the problem appeared the first time.
I looked for the error and came to this old thread but with the same problem.
I want to clarify that I made two things different than before, 1) I used bitnami user and 2)I made a mistake copying into a not created folder

Now I try to get the log file using sudo, but seems that nothing happens:

Thanks Juan,
Andres

Mysql and nginx not starting after reboot

dbarranco 2017-08-01 12:05:48 UTC #9

Hi @andrescaroc

Could you please execute:

ls -la /opt/bitnami/mysql/data/

Just to see if the database files are in the correct place.
Also, did you modify something in the configuration of Wordpress or Mysql?

Thank you. Best regards.

andrescaroc 2017-08-01 12:25:47 UTC #10

Hello @dbarranco,

Here is the output of that command:

I do not modify anything in the configuration of Wordpress or Mysql.

Thanks for your help
Andrés

andrescaroc 2017-08-01 19:32:21 UTC #11

Hello to all, this is a long post but I think It could be useful for newbies like me.

I have to say that I could reproduce the problem, unfortunately with another production site (without wanting to reproduce it).

I only follow these instrucctions to backup here

The recommended way to backup is to do it the following, via SSH commands, which basically consists of:
Stopping the services
sudo /opt/bitnami/ctlscript.sh stop
Copying the installation directory to a backup directory
sudo mkdir -p /opt/bitnami-backups/2017-07-31
sudo cp -R /opt/bitnami /opt/bitnami-backups/2017-07-3
Starting the services again:
sudo /opt/bitnami/ctlscript.sh start

This time without mistakes creating folders and the usual way I used to do that, without sudo su bitnami

But back up fails stating "No space left on device"

It is strange because It is my 5th or 6th backup, the project is running like 2 months ago and the site has les than 100 images and no videos, beside that on Google cloud console there is no info about getting out of space in my 10GB SSD.

Even if backup fails, the services should start again with the proper command, right?, but, mysql didn't.

This time I have all session, including log file and /mysql/data/ content in a rtf file

But after saving that file, I tried to enter again and now I can't even connect with my G Cloud Instance. It keeps in this stage:

The G Cloud Console Output, says:

So the truth is that= No space left on device.

Looking for here at bitnami forum I see that the recommended solution is to resize the server https://community.bitnami.com/t/urgent-error-establishing-a-database-connection/49766/2

I'll try the following and I would tell you later.
https://docs.bitnami.com/google/faq/#how-to-change-the-server-type-or-resize-the-server

Thank you in advance for your help
Andrés

jsalmeron 2017-08-02 10:38:24 UTC #12

Hi,

Please let us know if resizing the server solves all the issues.

Best regards,

Javier J. Salmerón

Was my answer helpful? Click on

andrescaroc 2017-08-02 13:39:35 UTC #13

Hello all,

The article I posted didn't help me to resize the disk, it is for resize the machine, get a better one with the same disk.

At Google Cloud Docs I found how to resize a persistent disk: Resize Disk.
It is very easy, and you don't have to resize the file system, the OS automatic resize it when you restart the instance.

Here you can see now I have 20 GB, but the WPMultisite still down, so I tried to stop and start services again as you see (mysql started, so the problem of this thread seems to be solved), but then appeared another error now with apache

claftshoes@wordpress-multisite-claft-vm:~$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda1        20G  9.7G  9.0G  52% /
udev             10M     0   10M   0% /dev
tmpfs           119M  4.3M  115M   4% /run
tmpfs           298M     0  298M   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           298M     0  298M   0% /sys/fs/cgroup
tmpfs            60M     0   60M   0% /run/user/1002
claftshoes@wordpress-multisite-claft-vm:~$ sudo /opt/bitnami/ctlscript.sh stop

Syntax OK
/opt/bitnami/apache2/scripts/ctl.sh : apache not running
/opt/bitnami/php/scripts/ctl.sh : php-fpm stopped
/opt/bitnami/mysql/scripts/ctl.sh : mysql stopped
claftshoes@wordpress-multisite-claft-vm:~$ sudo /opt/bitnami/ctlscript.sh start
2017-08-01T23:11:02.394454Z mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
2017-08-01T23:11:02.396682Z mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
2017-08-01T23:11:02.417610Z mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
/opt/bitnami/mysql/scripts/ctl.sh : mysql  started at port 3306
/opt/bitnami/php/scripts/ctl.sh : php-fpm started
Syntax OK
(98)Address already in use: AH00072: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
AH00015: Unable to open logs
/opt/bitnami/apache2/scripts/ctl.sh : httpd could not be started

claftshoes@wordpress-multisite-claft-vm:~$ 
claftshoes@wordpress-multisite-claft-vm:~$ sudo netstat -ltnp | grep :80
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      765/apache2     
claftshoes@wordpress-multisite-claft-vm:~$ ps aux | grep apache2
root       765  0.0  0.7  75604  4480 ?        Ss   22:49   0:00 /usr/sbin/apache2 -k start
www-data   770  0.0  0.7 495976  4824 ?        Sl   22:49   0:00 /usr/sbin/apache2 -k start
www-data   771  0.0  0.8 561544  4880 ?        Sl   22:49   0:00 /usr/sbin/apache2 -k start
claftsh+  4541  0.0  0.3  12732  2092 pts/0    S+   23:38   0:00 grep apache2
claftshoes@wordpress-multisite-claft-vm:~$

Searching for that error "(98)Address already in use: AH00072:" I found how to troubleshooting in this bitnami doc

It says that there is another service using this port, but the service is apache2, so I don't know i there was a second apache running and using that por or what, maybe you bitnami guys can explain it better.

I tried to restart services but the apache problem still there.

Looking for a solution, I found in this post that a sudo pkill command worked for him. So I stoped all services and run this:

sudo pkill -f apache
sudo /opt/bitnami/ctlscript.sh start

And now the site is up and running again.

I hope this could be useful for someone.

I suggest you to avoid the recommended backup process of this post, as it will run out your storage in 5 backups.

I will try to do snapshots from google cloud

Thanks all for your help
Andrés

Mysql not running with bitnami google cloud wordpress

My Website Showing Error establishing a database connection

WordPress error establishing a database connection

dbarranco 2017-08-03 10:40:23 UTC #14

Hi @andrescaroc

Nice work!! Glad you have been able to solve your issue and sharing it here with us. I'm sure the community will find it useful.

Do not hesitate on asking us if you have any other type of question, we'll be more than glad to help you.

Best regards!!

jsalmeron 2017-10-24 11:53:58 UTC #15

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!