MAMP:MySQL无法打开 [英] MAMP : Mysql won't turn on

问题描述

我的Mamp mysql服务器无法打开.我尝试执行/Applications/MAMP/bin/startMysql.sh，但这给了我这个错误:

My mamp mysql server won't turn on. I tried executing /Applications/MAMP/bin/startMysql.sh but that gave me this error :

101110 05:50:31 mysqld_safe登录到 "/Applications/MAMP/logs/mysql_error_log.err".

101110 05:50:31 mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error_log.err'.

101110 05:50:32 mysqld_safe使用以下数据库中的数据库启动mysqld守护程序 /Applications/MAMP/db/mysql

101110 05:50:32 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql

101110 05:50:32 pid文件中的mysqld_safe mysqld /Applications/MAMP/tmp/mysql/mysql.pid已结束

101110 05:50:32 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

/Applications/MAMP/logs/mysql_error_log.err:

/Applications/MAMP/logs/mysql_error_log.err :

InnoDB: http://dev. mysql.com/doc/refman/5.1/en/operating-system-error-codes.html

InnoDB:无法打开或创建数据文件.

InnoDB: Could not open or create data files.

InnoDB:如果您尝试添加新的数据文件，但在此处失败，

InnoDB: If you tried to add new data files, and it failed here,

InnoDB:您现在应该在my.cnf中编辑innodb_data_file_path

InnoDB: you should now edit innodb_data_file_path in my.cnf back

InnoDB:恢复原样，并删除InnoDB创建的新ibdata文件

InnoDB: to what it was, and remove the new ibdata files InnoDB created

InnoDB:这次尝试失败. InnoDB只写了那些充满了

InnoDB: in this failed attempt. InnoDB only wrote those files full of

InnoDB:零，但尚未以任何方式使用它们.但是要小心:做 不是

InnoDB: zeros, but did not yet use them in any way. But be careful: do not

InnoDB:删除包含您的宝贵数据的旧数据文件！

InnoDB: remove old data files which contain your precious data!

101110 5:53:08 [错误]插件'InnoDB'初始化函数返回错误.

101110 5:53:08 [ERROR] Plugin 'InnoDB' init function returned error.

101110 5:53:08 [错误]插件'InnoDB'注册为存储 引擎失败.

101110 5:53:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

101110 5:53:08 [错误]无法启动服务器:在TCP/IP端口上绑定: 地址已被使用

101110 5:53:08 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use

101110 5:53:08 [错误]您是否已经有另一个mysqld服务器 在3306端口上运行?

101110 5:53:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?

101110 5:53:08 [错误]中止

101110 5:53:08 [ERROR] Aborting

101110 5:53:08 [警告]强制关闭2个插件

101110 5:53:08 [Warning] Forcing shutdown of 2 plugins

101110 5:53:08 [注意]/Applications/MAMP/Library/libexec/mysqld: 关闭完成

101110 5:53:08 [Note] /Applications/MAMP/Library/libexec/mysqld: Shutdown complete

101110 05:53:08 pid文件中的mysqld_safe mysqld /Applications/MAMP/tmp/mysql/mysql.pid已结束

101110 05:53:08 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

推荐答案

我很高兴为您修复自身；)

Well I'm glad for you it fixed itself on its own ;)

从错误文件的外观来看，您似乎已经在运行一个MySQL实例...不确定在Mac上是否可以运行，但是您可以尝试:

From the look of your error file, it looks like you already had an instance of MySQL running... Not sure if this works on a mac, but you could try :

pidof mysqld

如果输出的是某些(一个或多个数字)，则说明MySQL正在运行.如果输出为空，则为空.

If this outputs something (one or several numbers), then MySQL is running. If the output is empty, then it is not.

这篇关于MAMP:MySQL无法打开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！