mysql 禁用 socket_Mysql的.在unix socket上绑定:权限被拒绝

无法启动

mysql:

130408 11:31:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

/usr/libexec/mysqld: Table 'plugin' is read only

130408 11:31:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

130408 11:31:22 InnoDB: Initializing buffer pool, size = 8.0M

130408 11:31:22 InnoDB: Completed initialization of buffer pool

130408 11:31:23 InnoDB: Started; log sequence number 0 19514977

130408 11:31:23 [ERROR] Can't start server : Bind on unix socket: Permission denied

130408 11:31:23 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?

130408 11:31:23 [ERROR] Aborting

130408 11:31:23 InnoDB: Starting shutdown...

130408 11:31:28 InnoDB: Shutdown completed; log sequence number 0 19514977

130408 11:31:28 [Note] /usr/libexec/mysqld: Shutdown complete

130408 11:31:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

另一个mysql不是runnig:

[root@triton667 etc]# ps ax | grep mysql

9195 pts/1 S+ 0:00 grep mysql

my.cnf文件:

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

tmpdir=/tmp

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

max_allowed_packet=256M

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

“/ tmp”和“/ var / lib / mysql”的权限是777 /

有什么建议?

UPD1:

[root@triton667 etc]# mysql_upgrade

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Running 'mysqlcheck with default connection arguments

mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) trying to connect

FATAL ERROR: Upgrade failed

UPD2:

plugin.MYD,plugin.MYI和plugin.frm存在于/ var / lib / mysql / mysql /中.

端口3306上没有运行任何东西.

mysql.sock不存在.我试图自己创建它,但重新启动后它被删除了.

mount(所有rw):

[root@triton667 mysql]# mount

/dev/md1 on / type ext4 (rw,noatime,usrjquota=aquota.user,grpjquota=aquota.group,jqfmt=vfsv0)

proc on /proc type proc (rw)

sysfs on /sys type sysfs (rw)

devpts on /dev/pts type devpts (rw,gid=5,mode=620)

tmpfs on /dev/shm type tmpfs (rw)

/dev/md0 on /boot type ext2 (rw)

none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)

sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)

nfsd on /proc/fs/nfsd type nfsd (rw)

今天我尝试在子域上克隆我的网站时出现此问题.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值