安装mysql的方法

安装mysql的方法

#cd /usr/ports/databases/mysql5l1-server
#make WITH_CHARSET=gbk WITH_XCHARSET=all WITH_PROC_SCOPE_PTH=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes SKIP_DNS_CHECK=yes WITHOUT_INNODB=yes install clean
#rehashrehashrehash
#cp /usr/local/share/mysql/my-large.cnf /etc/my.cnf

#设置随机启动：
vi /etc/rc.conf
mysql_enable="YES"

#初始化：
/usr/local/bin/mysql_install_db --user=mysql
#更改数据库权限（若所有者不是mysql）：
chown -R mysql /var/db/mysql/
#立即启动：
/usr/local/bin/mysqld_safe -user=mysql &
修改密码
#/usr/local/bin/mysqladmin -u root password newpasswd
就好了，
#mysql -u root 进入看看，
#show databases
#mysqladmin shutdown 关掉mysql,并退出
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

mysql的默认安装路径是：/var/db/mysql

如果要更改为/usr/local/mysql可按下面的步骤操作：

# /usr/local/etc/rc.d/mysql-server.sh stop

# cd /var/db
# mv mysql /usr/local/
# ln -s /usr/local/mysql mysql

# cd /usr/local
# chown -R mysql:mysql mysql

# /usr/local/etc/rc.d/mysql-server.sh start