> "nice: permission denied".
The problem was fixed by installing the latest version of mysql.
Now I have a perfercly running MySQL on freevsd-redhat7 server.
Here's my automated "mysqladdon" script to be incorporated in the skel and
to be run from root on the virtual:
---------
#!/bin/sh
MYSQL_BASE=/var/lib/mysql
echo "Adding mysql to this server".
mkdir $MYSQL_BASE
useradd -d $MYSQL_BASE mysql
/usr/bin/mysql_install_db
chown -R mysql.mysql $MYSQL_BASE
/usr/bin/mysqladmin -u root -h `hostname` password 'Put a good password
here'
echo "Done."
----------
This is what I have in rc.vsd to start the server (very similar to the faq):
# Start MySQL server
if [ "${mysql_enable}" = "YES" ]; then
if [ -d "/var/lib/mysql" ]; then
echo -n 'starting mysql server: '
su - mysql -c "/usr/bin/safe_mysqld --bind-address=`hostname -i`" &
echo 'mysql'
fi
fi
And this is in the rc.conf file (same as the faq):
#MYSQL
mysql_enable="YES"
Now the last problem:
Why MySQL is not started on reboot of the hosting server (apache is
started)?
Why is works if I do
vsboot --stop
vsboot --start???
Arent the scripts supposed to be the same?
Dave