rehash
#复制配置文件(#服务器内存4G,但是与apache在一起):
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 &
#修改mysql root密码:
/usr/local/bin/mysqladmin -u root password 'newpasswd'
#测试:
mysql -u root -p
mysql> show databases;
#启动/重启/停止mysqld
/usr/local/etc/rc.d/mysql-server start (等于/usr/local/bin/mysqld_safe -user=mysql &)
/usr/local/etc/rc.d/mysql-server restart
/usr/local/etc/rc.d/mysql-server stop
# end