编译完成mysql,之后把这个相应的权限给改了
下面这几句很重要
(这个顺序也很重要,一定不要颠倒)
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chown -R mysql /usr/local/mysql/var/
chown -R mysql /usr/local/mysql/var/.
chown -R mysql /usr/local/mysql/var/mysql
chown -R mysql /usr/local/mysql/var/mysql/
chgrp -R mysql /usr/local/mysql
cp ../support-files/my-medium.cnf /etc/my.cnf
vi /etc/ld.so.conf
/usr/local/mysql/lib/mysql
/usr/local/lib
保存。
载入库:
/sbin/ldconfig -v
cp mysql.server /etc/rc.d/init.d/mysqld
cd /etc/rc.d/init.d/
vi mysqld
找到
$bindir/mysqld_safe --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &
wait_for_pid created $!; return_value=$?
改为:
$bindir/mysqld_safe --user=root --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &
wait_for_pid created $!; return_value=$?
之后:
service mysqld start
service mysqld restart 就可以了。
最后是在启动机器的时候也启动服务
我们的机器是在rulevel 3 所以只加level 3就可以了
chkconfig --level 3 mysqld on
这样就不要在rc.local里面加/usr/local/mysql/bin/mysqld-safe --user=mysql & 了
可以这样启动或者重启或者关闭mysql
service mysqld start
service mysqld restart
service mysqld stop
——————————————————————
over
下面这几句很重要
(这个顺序也很重要,一定不要颠倒)
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chown -R mysql /usr/local/mysql/var/
chown -R mysql /usr/local/mysql/var/.
chown -R mysql /usr/local/mysql/var/mysql
chown -R mysql /usr/local/mysql/var/mysql/
chgrp -R mysql /usr/local/mysql
cp ../support-files/my-medium.cnf /etc/my.cnf
vi /etc/ld.so.conf
/usr/local/mysql/lib/mysql
/usr/local/lib
保存。
载入库:
/sbin/ldconfig -v
cp mysql.server /etc/rc.d/init.d/mysqld
cd /etc/rc.d/init.d/
vi mysqld
找到
$bindir/mysqld_safe --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &
wait_for_pid created $!; return_value=$?
改为:
$bindir/mysqld_safe --user=root --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &
wait_for_pid created $!; return_value=$?
之后:
service mysqld start
service mysqld restart 就可以了。
最后是在启动机器的时候也启动服务
我们的机器是在rulevel 3 所以只加level 3就可以了
chkconfig --level 3 mysqld on
这样就不要在rc.local里面加/usr/local/mysql/bin/mysqld-safe --user=mysql & 了
可以这样启动或者重启或者关闭mysql
service mysqld start
service mysqld restart
service mysqld stop
——————————————————————
over