Installing and configuring Mysql server on Freebsd

Go to the /usr folder cd /usr and then extract updates portsnap fetch extract then go to mysql client folder in ports(the version may change on your ports version and updates) /usr/ports/databases/mysql56-client then issue the command to install client make install clean and then navigate to the server folder cd /usr/ports/databases/mysql56-server then install it make

Installing MySQL on FreeBSD

Go to the installation folder cd /usr/ports/databases/mysql56-server carry out the installation command make install clean After a long run of installation edit the below file nano /etc/rc.conf add this line and save&exit mysql_enable="YES" start the server /usr/local/etc/rc.d/mysql-server start Set the root password mysqladmin -u root password "YOUR-PASSWORD-GOES-HERE" connect to your server mysql -u root -p

Enabling root remote ssh login on Freebsd

Using username "root". Access denied Using keyboard-interactive authentication. Password for root@Freebsd10: Access denied nano /etc/ssh/sshd_config find the "#PermitRootLogin no" line or you can use ctrl + w and enter the line then remove # and change no to yes then ctrl+o and ctrl+x to exit restart sshd deamon by entering "/etc/rc.d/sshd restart" Performing sanity check