mysql will not start on portal and nothing is written to the .err file
Article ID: 262890
Updated On:
Products
Issue/Introduction
How to add debug to a failed mysql install.
mysql will not start and no logging is happening.
These steps will generate debug logs for mysql startup.
Environment
Release : 22.2
Resolution
In MySql/bin/mysqld_safe, edit the file and
add set -x to top of the file on line after #!/bin/sh
duplicate this line and comment out the original (line 176):
cmd="$cmd > /dev/null 2>&1"
On new copy, do:
cmd="$cmd > /tmp/mysqld.log 2>&1"
In MySql/support-files/mysql.server, edit the file and:
add set -x to top of the file on line after #!/bin/sh
duplicate this line and comment out the original (line 266):
$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &
On new copy, do:
$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/tmp/mysql.server.log &
Review
/tmp/mysql.server.log
&
/tmp/mysqld.log
Additional Information
I suggest making a backup of the files before editing, so that you can revert to the originals to shut off debug
cp MySql/bin/mysqld_safe MySql/bin/mysqld_safe.original
cp MySql/support-files/mysql.server MySql/support-files/mysql.server.original
Feedback
