...stating what is wrong.
root@mysql:/usr/local # service mysql-server start
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
Messages:
Jun 29 14:56:13 mysql pkg-static: cyrus-sasl-2.1.26_13 installed
Jun 29 14:56:45 mysql pkg-static: openldap-sasl-client-2.4.46...
I installed mysql-server in a jail (running FreeBSD 11.0-RELEASE) with:
pkg install mysql80-server-8.0.2_1
When I try to start it:
service mysql-server start
The following is returned:
WARNING:failedprecmdroutineformysql
A google search tells me others have experienced this issue...
...log end --
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
I noted the first line above, so I tried running mysqld --initialize, but I get this:
root@mysql:/ # /usr/local/libexec/mysqld --initialize...
...message again related to precre.
root@FBSD:/ # service mysql-server start
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
root@FBSD:/ # cat /etc/rc.conf
clear_tmp_enable="YES"
syslogd_flags="-ss"
hostname="FBSD"
ifconfig_re0="DHCP"
ifconfig_re0_ipv6="inet6...
did as directed... then rebooted... command as follows
root@FBSD:~ # service mysql-server start
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
...zfs_enable="YES"
dbus_enable="YES"
hald_enable="YES"
root@FBSD:~ # service mysql-server onestart
/etc/rc.conf: mysql-server_enable=YES: not found
/etc/rc.conf: mysql-server_enable=YES: not found
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
still no joy wtf is...
...$ service mysql-server start OR
$ /usr/local/etc/rc.d/mysql-server start
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
$ service mysql-server status
mysql is not running.
$ service mysql-server stop
mysql not running? (check /var/db/mysql/freebsd11.1.pid).
$ sudo...
...at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
At first I thought is was something wrong with the package from my own repo but then I've tried the one from FreeBSD's repo and I have the same...
...course, to /etc/rc.conf:
mysql_enable="YES"
$ service mysql-server start/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
What? It used to work in the past months...
Looking at: /var/db/mysql/, ..owned by mysql and totally empty.
Looking at...
I follow your instructions, but this error still comes out:
% sudo service mysql-server start
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
...mysql_enable=yes
mysql_enable: -> yes
$ sudo service mysql-server start
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
And I search by google and someone said the /usr/local/etc/rc.d/mysql-server file have to be modified. The line eval $mysql_install_db...
...what I do, every single MySQL version for FreeBSD end with this error:
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
So I went for mariadb. I did not bother hunting down any files because it ended with the same error as MySQL.
WARNING:failedprecmdroutinefor...
...root@w:/var/db # service mysql-server start
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
Freshly created /var/db/mysql is empty. No detailed log gets generated.
When I run
root@w:/usr/home# /usr/local/bin/mysqld_safe
2016-05-16T03:54:08.6NZ mysqld_safe...
...This time, starting mysql56-server immediately gave the precmd error:
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
Making the change you suggested to /usr/local/etc/rc.d/mysql-server, and running it without sudo, confirms your comments:
$ service mysql-server...
Thanks, I tried your suggestion and after starting mysql, got the error (which I didn't have before):
WARNING:failedprecmdroutineformysql
It seems pretty obvious to me, at least, that mysql isn't being configured on install, and because there are no examples installed as I have found in...
I have only just installed FreeBSD (latest stable release) and am trying to set up a hosting server using Wordpress. The prerequisites are (L)AMP.
Apache seems to have been successfully installed, as does PHP, both using ports, but I'm stuck trying to get the MySQL server working. I have...
Is that really all there is to it or could there be more on the next line?
The reason I'm asking is because I'm slightly familiar with this type of error; it usually works in the form of: "failed ... routineformysql. <Cause of error>".
Two things come to mind. As you mentioned yourself MySQL...
...start
I get the following error in /var/log/messages:
/usr/local/etc/rc.d/mysql-server:WARNING:failedprecmdroutineformysql
So I have a bit of a catch 22 here :e I need to run mysql_upgrade but in order to do that the MySQL service needs to be running first. Any ideas? I had a look...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.