MySQL root Password Reset Issue

stoi2m1 2017-08-22 19:04:26 UTC #1

I do not fully understand how the bitnami install I am using for wordpress on AWS works so I did the following to reset my root MySQL password and now I can not get MySQL to restart.

Here are the steps I followed
Step 1: Stop MySQL Service.
sudo /opt/bitnami/ctlscript.sh stop mysql

Step 2: Kill all running mysqld.
sudo killall -9 mysqld

Step 3: Starting mysqld in Safe mode.
sudo mysqld_safe --skip-grant-tables --skip-networking &

Step 4: Start mysql client
mysql -u root

Step 5: After successful login, please execute this command to change any password.
FLUSH PRIVILEGES;

Step 6: You can update mysql root password .
UPDATE mysql.user SET authentication_string=PASSWORD('newpwd') WHERE User='root';

Step 7: Please execute this command.
FLUSH PRIVILEGES;

Step 8. Kill mysqld_safe
sudo killall -9 mysqld_safe

Step 9 Start MySQL Service
sudo /opt/bitnami/ctlscript.sh start mysql

The info I get back from console
mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
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

Step 10 review the mysql.log for any errors /opt/bitnami/mysql/data/mysqld.log
Access denied for user 'bitnami'@'localhost' (using password: YES)

Reset MySQL Password

silvio 2017-08-23 09:19:51 UTC #2

Hi,

We have a Support Tool that will gather relevant information for us to debug the issue. Could you please download and execute it in the machine where the stack is running?

These are the links to download the tool.

https://downloads.bitnami.com/files/bnsupport/0.1.0/bnsupport-windows.exe
md5: 7950e40c3a85eaeb8e09c3270f9d2736
https://downloads.bitnami.com/files/bnsupport/0.1.0/bnsupport-linux-x64.run
md5: 1e6525abb305016197b461e969062b7e
https://downloads.bitnami.com/files/bnsupport/0.1.0/bnsupport-osx.dmg
md5: a3b34dac83df24f71ee097b2e0bbfb37

If you are using a console, just type the following to download the tool:

wget -O bnsupport_tool LINK_OF_THE_TOOL && \
chmod +x bnsupport_tool && \
./bnsupport_tool

Note: Remember to change the placeholder LINK_OF_THE_TOOL for the link related to your operative system.

The output of the execution of this tool will be a zip file with all the information inside. Could you please send it to silvio@bitnami.com ?

If you are working with a remote instance and you do not know how can you download the zip file from your instance, you can follow this guide to download it.

Best regards,
Silvio Fernández

stoi2m1 2017-08-24 01:12:43 UTC #3

I sent you the file via email. Please advise when you review the archive.

silvio 2017-08-24 11:18:47 UTC #4

Hi,

I hve received and check your files, there is no the reason of your problem, sorry. Could you please attach your mysql log file so we can have a closer look at the errors?

/opt/bitnami/mysql/data/mysqld.log

Best regards,
Silvio Fernández

stoi2m1 2017-08-24 17:43:42 UTC #5

I have sent you another email with the file requested attached

silvio 2017-08-25 11:24:40 UTC #6

Hi,

you get [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11, that means that you have a different MySQL instance running. In order to solve this you can execute:

lsof -i:3306

Then kill it (the process number)

kill -9 PROCESS

e.g. kill -9 13498

Hope it helps.

Best regards,
Silvio Fernández

stoi2m1 2017-08-25 19:15:53 UTC #7

I ran the command

lsof -i:3306

and the out put was blank. So I tried another command just to make sure it didn't find something.

 netstat -tulpn | grep :3306

and the output was tha following
(No info could be read for "-p": geteuid()=1000 but you should be root.)

I ran the same command as sudo and the output was blank.

I'm not sure what I should do from here. Any other advice? Is it some script trying to use my old MySQL root password? Is it possible for me to find what my MySQL root password was and change it back?

Thanks,
Jesse

jsalmeron 2017-08-28 13:20:45 UTC #8

Hi,

This does not look good. I found this answer in StackOverflow that could help you. Could you try that?

mv ibdata1 ibdata1.bak 
cp -a ibdata1.bak ibdata1

Hope it helps.

Best regards,

Javier J. Salmerón

Was my answer helpful? Click on

stoi2m1 2017-08-28 20:19:29 UTC #9

Please explain the relevance. Plus where is this ibdata1 file?

stoi2m1 2017-08-28 20:23:50 UTC #10

Since @silvio was pointing me in a direction that pointed to a process running keeping MySQL from running I ran the following command.

ps aux | grep mysql

and got the following output

mysql 12616 0.0 18.6 1003040 189276 ? Sl Aug22 2:29 INSTALLED_DIR/mysql/bin/mysqld.bin --defaults-file=INSTALLED_DIR/mysql/my.cnf --basedir=INSTALLED_DIR/mysql --datadir=INSTALLED_DIR/mysql/data --plugin-dir=INSTALLED_DIR/mysql/lib/plugin --user=mysql --skip-grant-tables --skip-networking --log-error=INSTALLED_DIR/mysql/data/ip-172-31-4-211.err --pid-file=INSTALLED_DIR/mysql/data/ip-172-31-4-211.pid --socket=INSTALLED_DIR/mysql/tmp/mysql.sock --port=3306 root 14714 0.0 0.0 4440 696 ? S 20:09 0:00 /bin/sh INSTALLED_DIR/mysql/scripts/ctl.sh start root 14715 0.0 0.0 4440 732 ? S 20:09 0:00 /bin/sh INSTALLED_DIR/mysql/bin/mysqld_safe --defaults-file=INSTALLED_DIR/mysql/my.cnf --mysqld=mysqld.bin --socket=INSTALLED_DIR/mysql/tmp/mysql.sock --datadir=INSTALLED_DIR/mysql/data --log-error=INSTALLED_DIR/mysql/data/mysqld.log --pid-file=INSTALLED_DIR/mysql/data/mysqld.pid --lower-case-table-names=1 mysql 15042 0.2 14.0 427380 143072 ? Sl 20:09 0:00 INSTALLED_DIR/mysql/bin/mysqld.bin --defaults-file=INSTALLED_DIR/mysql/my.cnf --basedir=INSTALLED_DIR/mysql --datadir=INSTALLED_DIR/mysql/data --plugin-dir=INSTALLED_DIR/mysql/lib/plugin --user=mysql --lower-case-table-names=1 --log-error=INSTALLED_DIR/mysql/data/mysqld.log --pid-file=INSTALLED_DIR/mysql/data/mysqld.pid --socket=INSTALLED_DIR/mysql/tmp/mysql.sock --port=3306 bitnami 15106 0.0 0.0 11740 928 pts/0 S+ 20:10 0:00 grep --color=auto mysql

Is any of this part of my problem? Should I kill any of these processes?

Thanks,
Jesse

jsalmeron 2017-08-29 09:54:56 UTC #11

Hi,

This is strange. You previously mentioned that no process was using 3306 but there are actually mysjl processes running. Could you try executing this command?

sudo netstat -tulpn

Maybe the mysql process is running in another port. Could you confirm that these processes are still there even when running:

sudo /opt/bitnami/ctlscript.sh stop mysql

Best regards,

Javier J. Salmerón

Was my answer helpful? Click on

stoi2m1 2017-08-29 20:33:55 UTC #12

Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 127.0.0.1:21 0.0.0.0:* LISTEN 611/vsftpd tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 909/sshd tcp6 0 0 :::80 :::* LISTEN 1563/httpd.bin tcp6 0 0 :::22 :::* LISTEN 909/sshd tcp6 0 0 :::443 :::* LISTEN 1563/httpd.bin udp 0 0 0.0.0.0:68 0.0.0.0:* 547/dhclient udp 0 0 0.0.0.0:18745 0.0.0.0:* 547/dhclient udp6 0 0 :::2683 :::* 547/dhclient

Unmonitored mysql /opt/bitnami/mysql/scripts/ctl.sh : mysql not running

I ran this command again and only have 2 processes running
ps aux | grep mysql

Output:
mysql 12616 0.0 18.6 1003040 189252 ? Sl Aug22 2:52 /opt/bitnami/mysql/bin/mysqld.bin --defaults-file=/opt/bitnami/mysql/my.cnf --basedir=/opt/bitnami/mysql --datadir=/opt/bitnami/mysql/data --plugin-dir=/opt/bitnami/mysql/lib/plugin --user=mysql --skip-grant-tables --skip-networking --log-error=/opt/bitnami/mysql/data/ip-172-31-4-211.err --pid-file=/opt/bitnami/mysql/data/ip-172-31-4-211.pid --socket=/opt/bitnami/mysql/tmp/mysql.sock --port=3306 bitnami 19424 0.0 0.0 11740 932 pts/0 S+ 20:28 0:00 grep --color=auto mysql

Thanks,
Jesse

stoi2m1 2017-08-29 21:20:02 UTC #13

I was a bit impatient so I ran

sudo kill -9 12616

Then I ran

sudo /opt/bitnami/ctlscript.sh start mysql

and now

/opt/bitnami/mysql/scripts/ctl.sh : mysql started at port 3306 Monitored mysql

Ive checked my website and it's now back online.

Thanks for all of the help,
Jesse

jsalmeron 2017-08-30 14:08:00 UTC #14

Hi,

Thanks for letting us know. Glad to read that the issue is fixed Do not hesitate to write again if you find more issues.

Best regards,

Javier J. Salmerón

Was my answer helpful? Click on

jsalmeron 2017-10-25 11:34:17 UTC #15

Powered by Discourse, best viewed with JavaScript enabled

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

SugarCRM

Drupal

WordPress

Joomla!

Redmine