While executing the script "./mysqlsec" you're asked to enter a new password. You need this new password here. Otherwise the password should be empty.
Please enter the following command:
svcs -l mysql
I assume the output contains a row like "logfile /var/svc/log/pkgsrc-mysql:default.log".
Now enter the command
cat <logfile>
(replace <logfile> with your logfile's location; in the example above it is "/var/svc/log/pkgsrc-mysql:default.log", so the resulting command would be "cat /var/svc/log/pkgsrc-mysql:default.log")
Please post the displayed output here.
cat <logfile> gives this output:
Monitor-Extension: Command Log interface.pl 894# cat /var/svc/log/pkgsrc-mysql:default.log
p1
main, /_lib/interface.pl, line 898
exe: cat /var/svc/log/pkgsrc-mysql:default.log
[ Jul 9 02:17:16 Disabled. ]
[ Jul 9 02:17:16 Rereading configuration. ]
[ Jul 9 02:17:16 Rereading configuration. ]
[ Jul 9 02:17:16 Rereading configuration. ]
[ Jul 9 02:21:54 Enabled. ]
[ Jul 9 02:21:54 Executing start method ("/opt/local/lib/svc/method/mysqld start"). ]
[ Jul 9 02:21:54 Method "start" exited with status 0. ]
2015-07-09 02:21:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[ Jul 10 07:40:00 Stopping because service disabled. ]
[ Jul 10 07:40:00 Executing stop method ("/opt/local/lib/svc/method/mysqld stop"). ]
[ Jul 10 07:40:00 Method "stop" exited with status 0. ]
[ Jul 10 07:41:51 Enabled. ]
[ Jul 10 07:41:51 Executing start method ("/opt/local/lib/svc/method/mysqld start"). ]
[ Jul 10 07:41:51 svc.startd could not set context for method: ]
[ Jul 10 07:41:51 chdir: No such file or directory ("/var/mysql") ]
[ Jul 10 07:41:51 Method "start" exited with status 96. ]
[ Jul 11 04:06:58 Leaving maintenance because disable requested. ]
[ Jul 11 04:06:58 Disabled. ]
[ Jul 11 04:07:00 Enabled. ]
[ Jul 11 04:07:00 Executing start method ("/opt/local/lib/svc/method/mysqld start"). ]
[ Jul 11 04:07:00 svc.startd could not set context for method: ]
[ Jul 11 04:07:00 chdir: No such file or directory ("/var/mysql") ]
[ Jul 11 04:07:00 Method "start" exited with status 96. ]
[ Jul 11 04:10:01 Leaving maintenance because disable requested. ]
[ Jul 11 04:10:01 Disabled. ]
[ Jul 11 04:10:03 Enabled. ]
[ Jul 11 04:10:03 Executing start method ("/opt/local/lib/svc/method/mysqld start"). ]
[ Jul 11 04:10:03 svc.startd could not set context for method: ]
[ Jul 11 04:10:03 chdir: No such file or directory ("/var/mysql") ]
[ Jul 11 04:10:03 Method "start" exited with status 96. ]