OpenBSD3.7下如何安装mysql

titansword2000

转到BSD下不久，很多东西都不会，望各位详细指教。

HonestQiao

和free没有多大区别的啊

llzqq

# pkg_add http://ftp.it.net.au/OpenBSD/3.6/packages/i386/mysql-server-4.0.23p1.tgz

剑心通明

看那些文章，OpenBSD下好像pkg_add的比较多些吧，ports安装很慢？

titansword2000

我在安装完后没法启动server。请会的兄弟些详细些了。

剑心通明

http://bbs.chinaunix.net/forum/viewtopic.php?t=390936&show_type=old

hongzjx

下个二进制分发包回来手动安装吧,就一两分钟就搞定了

像把刀子

Install Mysql Package

Code:

# pkg_add mysql-client-3.23.55.tgz # pkg_add p5-DBI-1.30.tgz # pkg_add p5-DBD-Msql-Mysql-1.22.19.tgz # pkg_add mysql-server-3.23.55.tgz



Add this to the end of the start up script /etc/rc.local. It will activate MySql on startup.
Code:

# vi /etc/rc.local rm -R /var/www/var/run/mysql mkdir -p /var/www/var/run/mysql /usr/local/bin/mysqld_safe --user=mysql -log & sleep 10 ln /var/run/mysql/mysql.sock /var/www/var/run/mysql/mysql.sock


( Sleep 10 is to make sure there is enough time for mysql.sock to be created)
I know there are slicker ways of doing this. But, the above method seems to give me the least amount of problems.
Add the following to /etc/rc.conf or create it in a new file /etc/rc.conf.local. This will start your sftp, apache server, and start your Mysql. If you set MySql to know, it will not run the script to turn on mysql in rc.local. ( If you do not want Apache to be chroot, then change httpd_flags to read httpd_flags=¨-DSSL¨ )
Code:

# vi /etc/rc.conf.local httpd_flags="-DSSL" shlib_dirs="$shlib_dirs /usr/local/lib/mysql"



Now since I don¡¦t like rebooting we are going do this. Start MySql and Change the password for root. Then copy MySql default setup file.

Code:

# /usr/local/bin/safe_mysqld & # /usr/local/bin/mysqladmin -u root password 'new password'


Reboot computer
THIS SECTION ONLY APPLIES IF YOU CANNOT CONNECT TO MySQL using mysql -h 127.0.0.1 -u root -p , and you need to connect from 127.0.0.1. If that is the case, MySql is not allowing local loop back look up. Here is a fix ( thnx to alex lee for the help on this)
Code:

# mysql -uroot -p mysql>; use mysql; mysql>; INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES('127.0.0.1','root',PASSWORD('New password') ,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); mysql>; FLUSH PRIVILEGES; mysql>; select host, user, select_priv, grant_priv, password from user;

完整的web等安装地址可以参考这里
http://www.bsdforums.org/forums/showthread.php?t=9986&page=3&pp=15

titansword2000

谢谢各位兄弟的回答！不过可能是由于中Win的毒太深的缘故，很多东西还要时间慢慢来摸索。顺便给BSD版的版主提个小意见，不知可否？这段时间一直在看OB，其一发现里面的水帖太多，其二这里大多是FB，能否请些加入2个OB和NB版主进来对我们这些新手进行一些指导，毕竟它们几个系统之间还是有很多东西不一样的，对新手会有很多好处的吧。希望各位别扔砖头。扔鸡蛋我就不管了

剑心通明

水贴目前我正在尽可能控制，OB和rainren大哥挺厉害的，我也希望有高手来指点大家，可没人愿意啊