===========
Install freebsd in mysql
===========
cd /usr/ports/databases/mysql50-server
make install clean
mysql_install_db –user=mysql
chown -R mysql /var/db/mysql/
chgrp -R mysql /var/db/mysql/
/usr/local/bin/mysqld_safe -user=mysql &
Note: If you encounter Command not found error, use command rehash to update OS path environment variables.
# The port installation will put a script file mysql-server.sh in /usr/local/etc/rc.d which will has capability to start MySQL server. To enable MySQL server to start automatically after every FreeBSD server reboot
, enter the following command in CLI:
echo ‘mysql_enable=”YES”‘ >> /etc/ rc.conf
# By default, MySQL default super user account …
sshd_config
edit the file inside /etc/sshd/sshd_config using your favorite editor.
sshd_config
# Authentication:
#LoginGraceTime 2m
#PermitRootLogin no
#StrictModes yes
#MaxAuthTries 6
to
# Authentication:
#LoginGraceTime 2m
PermitRootLogin yes
#StrictModes yes
#MaxAuthTries 6
now save the file sshd_config and reload ssh service.
root@bsd# /etc/rc.d/sshd reload
Reloading sshd config files.
How to build locate command database in FreeBSD?
If the database has not been built, locate command will show the following error message:
locate: database too small: /var/db/locate.database
You can build/update the database by running ‘locate.updatedb‘ script.
run:
$ /usr/libexec/locate.updatedb
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
shell> cd mysql-VERSION
shell> ./configure –prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysql_install_db –user=mysql
shell> chown -R root .
shell> chown -R mysql var
shell> bin/mysqld_safe –user=mysql &
—-
yum install ncurses-devel
yum install gcc gcc-c++
libxml2-devel
libxml2-utils
make clean
Follow this command by typing;
#./configure –prefix=/usr/local/mysql –localstatedir=/home/system/data/mysql –disable-maintainer-mode –with-mysqld-user=mysql –enable-large-files-without-debug (enter)
Sit back and wait for a while while configure does its thing, once the system returns the prompt …
