http://bbs.bsdlover.cn/thread-1260-1-1.html
我的运行环境:
OS: FreeBSD 7.0
IP:192.168.1.200
domain:demo.kysf.net
1、按照安装mysql章节步骤安装MySQL:
# cd /usr/ports/databases/mysql50-server
# make -D BUILD_OPTIMIZED install clean
# rehash
2、配置MySQL:
# mysql_install_db --user=mysql
# mysqld_safe &
# mysqladmin -u root password 'localpassword'
# mysqladmin -u root -h host.example.com password 'remotepassword'
# cp /usr/local/share/mysql/my-medium.cnf /var/db/mysql/my.cnf
3、添加为开机启动:
# ee /etc/rc.conf
mysql_enable="YES"
4、重启MySQL生效:
# /usr/local/etc/rc.d/mysql-server restart
5、测试:
# mysqlshow -p
能看到:
+--------------------+
| Databases |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
除了第2步中设置远程访问MySQL帐号不成功外,其它步骤都成功。
# mysqladmin -u root -h host.example.com password 'remotepassword' (未成功)
后来 tecer 说我的安装不正确,我就想卸载MySQL重新安装,于是我搜索论坛卸载mysql(卸载的帖子:http://bbs.chinaunix.net/viewthread.php?tid=524049)
pkg_delete mysql-server-5.0.51a
然后我按照 tecer 说的安装MySQL:(http://bbs.chinaunix.net/thread-1169568-1-2.html)
cd /usr/ports/databases/mysql50-server
make install clean
make WITH_CHARSET=utf8 WITH_COLLECTION=utf8_general_ci WITH_XCHARSET=all WITH_PROC_SCOPE_PTH=yes WITHOUT_INNODB=yes SKIP_DNS_CHECK=yes
初始化
mysql_install_db --user=mysql
chown -R mysql:mysql /var/db/mysql
修改密 ***
mysql安装后密 *** 默认是空
/usr/local/bin/mysqladmin -uroot -p -password "123"
/usr/local/bin/mysqld_safe & 启动mysql
cp /usr/local/share/mysql/my-small.cnf /usr/local/etc/my.cnf
ee /etc/rc.conf mysql_enable="YES"
备份
mysqldump -uroot -p --opt dbname > /home/xx
导入
mysql -uroot -p dbname < dbname.sql
结果出错,并且连mysql都无法启动,错误信息见下图。

会员注册
会员登录
个人空间