elitepvpers - [METIN2]Released Install MySQL (English Tut by Hany)

Hello , Today I gonna show you how to install mysql for your server ...
First you should open putty and login to your server , now follow these steps..

1-

PHP Code:


		
			
cd /usr/ports/databases/mysql50-server/

PHP Code:


		
			
make install WITH_XCHARSET=all clean

PHP Code:


		
			
/usr/local/bin/mysql_install_db

PHP Code:


		
			
chown -R mysql /var/db/mysql/

PHP Code:


		
			
chgrp -R mysql /var/db/mysql/

PHP Code:


		
			
/usr/local/bin/mysqld_safe &#8211;user=mysql &

PHP Code:


		
			
/usr/local/bin/mysqladmin -u root password newpassword

NOTE : newpassword = your password , so put the password you want instead of newpassword

PHP Code:


		
			
mysql_enable = "YES"

in the rc.conf file so that mysql starts during system start.

PHP Code:


		
			
mysql -p
It's gonna ask you for password like this , Enter Password : here you enter the password that you used at 7th step

10-

PHP Code:


		
			
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'[ENTER]
IDENTIFIED BY 'here u write the pw u used at 7th step too..' WITH GRANT OPTION;

11-

PHP Code:


		
			
quit

Give thanks if helped ! , Tutorial by [SA]Hany - RocksMT2 & Metin2Union Owner.