设为首页收藏本站
查看: 116|回复: 0

[PHP] 配置MySQL服务的自启动

[复制链接]

论坛元老

Rank: 6Rank: 6

积分
34274
主题
17031
UID
1347
M币
67
贡献
17176

  • 发表于 2018-7-3 18:49:00 | 显示全部楼层 |阅读模式
    [root@Oracle9i mysql]# cp support-files/mysql.server /etc/init.d/mysql[root@oracle9i mysql]# chmod +x /etc/init.d/mysql[

      [root@Oracle9i mysql]# cp support-files/mysql.server /etc/init.d/mysql
    [root@oracle9i mysql]# chmod +x /etc/init.d/mysql
    [root@oracle9i etc]# chkconfig --list mysql
    service mysql supports chkconfig, but is not referenced in any runlevel (run 'chkconfig --add mysql')
    [root@oracle9i etc]# chkconfig --add mysql 345 on
    chkconfig version 1.3.13.5.EL4 - Copyright (C) 1997-2000 Red Hat, Inc.
    This may be freely redistributed under the terms of the GNU Public License.
    usage: chkconfig --list [name]
    chkconfig --add
    chkconfig --del
    chkconfig [--level ]  
    [root@oracle9i etc]# chkconfig --add mysql
    [root@oracle9i etc]# chkconfig --list mysql
    mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
    重启机器,测试:
    [root@oracle9i mysql]# reboot
    Broadcast message from root (pts/1) (Wed Mar 2 15:44:42 2011):
    The system is going down for reboot NOW!
    重启后,发现mysql数据库已经自动启动起来
    [root@oracle9i ~]# ps -ef | grep mysql
    root 5508 1 0 15:46 ? 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/oracle9i.pid
    mysql 5761 5508 0 15:46 ? 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/oracle9i.err --pid-file=/usr/local/mysql/data/oracle9i.pid --socket=/tmp/mysql.sock --port=3306
    root 6749 6716 0 15:47 pts/0 00:00:00 grep mysql
    [root@oracle9i ~]# mysql -e "select host from db" mysql
    +------+
    | host |
    +------+
    | % |
    | % |
    +------+
    [root@oracle9i ~]# mysql -e "show database" mysql
    ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1
    [root@oracle9i ~]# mysql -e "select host,db,user from db" mysql
    +------+---------+------+
    | host | db | user |
    +------+---------+------+
    | % | test | |
    | % | test\_% | |
    +------+---------+------+

    回复

    使用道具 举报

    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    在我站开通SVIP可同时获得17个站点VIP资源 立即登录 立即注册
    快速回复 返回顶部 返回列表