错误MySQL CentOS -启动MySQL找不到MySQL服务器

Question

我不能在mysql中进行任何操作：

root@server2 [/]# /etc/init.d/mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
root@server2 [/]# /etc/init.d/mysql start
Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/server2.myaddress.com.br.pid).
root@server2 [/]# /etc/init.d/mysql stop
MySQL server PID file could not be found!                  [FAILED]
root@server2 [/]# /etc/init.d/mysql restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/server2.myaddress.com.br.pid).
root@server2 [/]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

我的档案/etc/my.cnf：

root@server2 [~]# cat /etc/my.cnf
[mysqld]
user = mysql
skip-external-locking
key_buffer = 384M
max_allowed_packet=268435456
max_connections = 500
max_user_connections = 35
wait_timeout=40
connect_timeout=10
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
server-id       = 1
skip-innodb

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

在一些帖子中搜索，我发现一些程序可能持有mysql。按照已检查的命令执行：

root@server2 [~]# lsof | grep mysql
tailwatch 20718      root  mem       REG        3,5    206553    8922204 /usr/local/cpanel/3rdparty/perl/514/lib/perl5/cpanel_lib/i386-linux-64int/auto/DBD/mysql/mysql.so

yum -server

root@server2 [~]# yum info mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos.aol.com
 * extras: centos.chi.host-engine.com
 * updates: mirror.lug.udel.edu
Excluding Packages in global exclude list
Finished
Error: No matching Packages to list

其他信息..。

• 没有运行mysql的进程。
• CentOS第5.10版(最终)
• 我已经删除了扩展名为.err的文件，并再次尝试。但这不起作用。
• 当我试图在安全模式下启动mysql时，显然没有错误。但仍然不起作用，后续任何操作也不起作用。
• 我也尝试过将ib_logfile日志移动到mysql，创建新文件。失败的尝试。

登录/var/lib/mysql/server2.myaddress.com.br.err

140829 14:23:58 [Note] Plugin 'FEDERATED' is disabled.
140829 14:23:58 [Note] Plugin 'InnoDB' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140829 14:23:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140829 14:23:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140829 14:23:58 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140829 14:23:58 [Note] Server socket created on IP: '0.0.0.0'.
140829 14:23:58 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/proxies_priv.frm' (errno: 13)
140829 14:23:58 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/proxies_priv.frm' (errno: 13)
140829 14:23:58 mysqld_safe mysqld from pid file /var/lib/mysql/server2.myaddress.com.br.pid ended

Answer 1

这是一个新的mysql服务器还是一个现有的服务器？它似乎丢失了它的数据文件夹。配置中也没有定义数据文件夹，因此它将使用默认值。

如果尚未创建MySQL数据目录，则需要使用以下命令创建该目录：

mysql_install_db

Answer 2

errno: 13是被拒绝的权限，这意味着数据库文件存在，但是MySQL没有访问它们的权限。若要解决此问题，请修复权限和SELinux上下文。