Metin2 Installing mysql on FreeBSD

[GT_Rambo]

Installing mysql on FreeBSD.

# Updates the pkg archive.

pkg update -f

# mysql installs client and server.

pkg install mysql56-client mysql56-server

# Create password database.

pwd_mkdb -p /etc/master.passwd

# Grant permissions to the mysql folder.

chown -R mysql /var/db/mysql/
chgrp -R mysql /var/db/mysql/

# To activate the automatic mysql service when starting the system.

echo 'mysql_enable="YES"' >> /etc/rc.conf

# run mysql server.

service mysql-server start

# Changing the root password.

mysqladmin -uroot -p password
Enter password: <leave the line blank here.>
New password: <enter your new password.>
Confirm new password: <confirm to enter your new password.>

# Opening the root account to other ip addresses.
# xxx : it's your password.

mysql -p
CREATE USER 'root'@'%' IDENTIFIED BY 'xxx';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
flush privileges;
quit;

 

[cjmt2]

ee /etc/sysctl.conf
security.bsd.see_other_uids=0
security.bsd.see_other_gids=0
security.bsd.see_jail_proc=0
security.bsd.unprivileged_read_msgbuf=0
security.bsd.unprivileged_proc_debug=0
kern.randompid=1

Just for minimal security