我算服了bsd了,mysql竟然是这样装好的!!??

yiqingxiao

# ./scripts/mysql_install_db --user=mysql #初试化表并且规定用mysql用户来访问  
没初始化数据库吧..

coastw

error log:

070204 20:36:27  mysqld started
070204 20:36:27  InnoDB: Started; log sequence number 0 43655
070204 20:36:27 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
070204 20:36:27 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070204 20:36:27 [ERROR] Aborting

070204 20:36:27  InnoDB: Starting shutdown...
070204 20:36:30  InnoDB: Shutdown completed; log sequence number 0 43655
070204 20:36:30 [Note] /usr/local/libexec/mysqld: Shutdown complete

070204 20:36:30  mysqld ended

coastw

mysql_install_db 和 mysql_install_db --user=mysql 没什么不同吧

目前/var/db/mysql的目录权限是
server# ls -dl /var/db/mysql
drwx------  4 mysql  mysql  1024 Feb  4 20:52 /var/db/mysql

[ 本帖最后由 coastw 于 2007-2-4 20:58 编辑 ]

jacky_hui

应该很简单的

coastw

简单？这问题都折磨我一个礼拜了。再这么下去我就准备放弃Freebsd了

yiqingxiao

这么简单的事情被你搞的这么复杂..真是无语
http://fanqiang.chinaunix.net/system/bsd/2005-08-26/3534.shtml
你干脆全部删除了重新弄过好了.
省的到时出错又不知道因为什么.了..如果实在玩不来..先在vm中熟悉一下
参考上面的非常详细的说明..搞不定...........那就.......

coastw

原帖由 yiqingxiao 于 2007-2-4 22:04 发表
这么简单的事情被你搞的这么复杂..真是无语
http://fanqiang.chinaunix.net/system/bsd/2005-08-26/3534.shtml
你干脆全部删除了重新弄过好了.
省的到时出错又不知道因为什么.了..如果实在玩不来.. ...

完全按照你的步骤做：最后

server# /usr/local/mysql/bin/mysqld_safe --user=mysql &
[1] 48521
server# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/server.qa.com.pid
070204 23:43:03  mysqld ended


疯了我！

coastw

drwxr-xr-x   2 root  wheel  2048 Feb  4 22:55 bin
drwxr-xr-x   4 root  wheel   512 Feb  4 04:12 etc
drwxr-xr-x   3 root  wheel   512 Feb  3 23:07 include
drwxr-xr-x   2 root  wheel   512 Feb  4 22:55 info
drwxr-xr-x   6 root  wheel  1024 Feb  3 23:07 lib
drwxr-xr-x   6 root  wheel   512 Feb  3 20:56 libdata
drwxr-xr-x   2 root  wheel   512 Feb  4 22:55 libexec
drwxr-xr-x  28 root  wheel   512 Feb  4 04:12 man
drwxr-xr-x  12 root  mysql   512 Feb  4 23:40 mysql
drwxr-xr-x   2 root  wheel   512 Feb  3 21:08 sbin
drwxr-xr-x  19 root  wheel   512 Feb  3 23:07 share
drwxr-xr-x   2 root  wheel   512 Feb  4 04:12 www
server# /usr/local/mysql/bin/mysqld_safe --user=root &
[1] 48593
server# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/server.qa.com.pid
070204 23:54:42  mysqld ended


[1]    Done                          /usr/local/mysql/bin/mysqld_safe --user=root



server# /usr/local/mysql/bin/mysqld_safe --user=mysql &
[1] 48631
server# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/server.qa.com.pid
070204 23:55:54  mysqld ended