This guide is to install MySql n freebsd
In Freebsd Give this command
chown -R mysql /var/db/mysql/
chgrp -R mysql /var/db/mysql/
Open /etc and go to rc.conf
Add this the the bottom
reboot
When loged back in
Then give the command
And you have installed MySql
In Freebsd Give this command
PHP Code:
cd /usr/ports/databases/mysql50-server/
make install WITH_XCHARSET=all clean
PHP Code:
/usr/local/bin/mysql_install_db
chgrp -R mysql /var/db/mysql/
PHP Code:
/usr/local/bin/mysqld_safe –user=mysql &
PHP Code:
/usr/local/bin/mysqladmin -u root password yourpassword
Add this the the bottom
PHP Code:
mysql_enable="YES"
When loged back in
PHP Code:
mysql -p
PHP Code:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY 'your_password' WITH GRANT OPTION;
PHP Code:
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost'
IDENTIFIED BY 'mt2!@#' WITH GRANT OPTION;
PHP Code:
quit
