freebsd-version: 11.1-RELEASE
mysql version: 5.6.38
I have a script the requires mysql, cron_create_tables.pl:
I am unable to start mysql.
I spent an entire week at home trying to get this to work and still no success.
Here are some of the things I've done/tried:
I added mysql_enable="YES" to /etc/rc.conf
mysql version: 5.6.38
I have a script the requires mysql, cron_create_tables.pl:
Code:
#!/usr/local/bin/perl -w --
use DBI;
use strict;
my $dbh = DBI->connect('DBI:mysql:mymud', 'mymud', '') or die "unable to connect to MyMUD database";
...
$ perl cron_create_tables.pl
Code:
DBI connect('starmud','starmud',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at cron_create_tables.pl line 7.
unable to connect to StarMUD database at cron_create_tables.pl line 7.
I am unable to start mysql.
I spent an entire week at home trying to get this to work and still no success.
Here are some of the things I've done/tried:
I added mysql_enable="YES" to /etc/rc.conf
$ mysql
Code:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
$ service mysql-server start
OR $ /usr/local/etc/rc.d/mysql-server start
Code:
/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql
$ service mysql-server status
Code:
mysql is not running.
$ service mysql-server stop
Code:
mysql not running? (check /var/db/mysql/freebsd11.1.pid).
$ sudo more /root/.mysql_secret
Code:
# Password set for user 'root@localhost' at 2017-11-11 13:53:12
V=o%;*&bU)jo
Last edited by a moderator: