MySQL独立

Question

我已经使用二进制安装程序在我的MAC上安装了MySQL 5.5.27。我能够使用/Library/StartupItems/MySQLCOM/MySQLCOM start运行mysql服务器。但我无法运行mysqld的独立选项。我得到以下错误：

120821 17:28:03 [Note] Plugin 'FEDERATED' is disabled.
bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
120821 17:28:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120821 17:28:03 InnoDB: The InnoDB memory heap is disabled
120821 17:28:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120821 17:28:03 InnoDB: Compressed tables use zlib 1.2.3
120821 17:28:03 InnoDB: Initializing buffer pool, size = 128.0M
120821 17:28:03 InnoDB: Completed initialization of buffer pool
120821 17:28:04  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

你能帮我管理一下mysqld --独立的吗？

Answer 1

正如它所说的，首先运行“./mysql_ -u -p”来创建frm文件。如果您无法创建它，请尝试以超级用户的身份运行脚本。然后运行"./mysqld -u "，以防万一也是超级用户。

希望这能有所帮助

Answer 2

要在Mac w/o上运行mysqld“启动项”，请在Terminal.app中执行以下命令

sudo su -
nohup /usr/local/mysql/bin/mysqld_safe &