Return to how_to_install_a_mysql_server.mdwn CVS log

Up to [NetBSD Developer Wiki] / wikisrc / pkgsrc

dos2unix

Installing a MySQL Server is easy. 

The fastest way is to install the Binary Package. This is only recommended, if you wish to use your server as a stand alone mysql server, without any other server software like a webserver. If you wish to use Apache and PHP please read the article: [[How to install a LAMP Server]]. 


It has the mysql-client as a dependency, which have to be installed first. 
    
    # pkg_add -v mysql-client
    # pkg_add -v mysql-server
    

If you decide to install via pkgsrc, because of a newer version, just enter: 
    
    # cd /usr/pkgsrc/databases/mysql5-server/
    # make install clean
    

It will automatically compile the client and the server. 

That's it... almost. Now copy the rc.d script into /etc/rc.d/: 
    
    # cp /usr/pkg/share/examples/rc.d/mysqld /etc/rc.d/
    

and start the MySQL server via the NetBSD's [rc.d(8)](http://netbsd.gw.com/cgi-bin/man-cgi?rc.d+8+NetBSD-current) framework. Only one modification is needed to [rc.conf(5)](http://netbsd.gw.com/cgi-bin/man-cgi?rc.conf+5+NetBSD-current): 
    

# echo "mysqld=yes" >> /etc/rc.conf
    

If you want to copy the rc.d scripts automatically with pkgsrc, you can use: 
    
    PKG_RCD_SCRIPTS=YES 
    

into mk.conf(5). 

If mysql is not starting up, you may need to create and set permissions on the /var/mysql directory and setup the default mysql db: 
    
    # mkdir /var/mysql
    # mysql_install_db
    # chown -R mysql:mysql /var/mysql
    

If you need information about the MySQL server package, use the following: 
    
    # pkg_info mysql-server
    

Have fun. 

##  See also 

  * [[pkgsrc/How_to_install_a_LAMP_Server]]