Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have installed MySQL 5.5.27 on my MAC using the binary installer. I am able to run the mysql server with /Library/StartupItems/MySQLCOM/MySQLCOM start. But I am not able to run the mysqld with standalone option. I get the following error:

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.

Could you please help me to run the mysqld --standalone ?

share|improve this question

migrated from stackoverflow.com Aug 22 '12 at 10:55

This question came from our site for professional and enthusiast programmers.

2 Answers 2

As it is saying, run "./mysql_upgrade -u -p" first to create the frm file. If you're not able to create it, try running the script as superuser. Then run "./mysqld -u ", in case as superuser too.

Hope this helps

share|improve this answer
    
Hi Valerio, Thanks for your help. I have tried: bin/mysql_upgrade -u root -p. It goes thro' all the checks and finally end up with an error:Could not create the upgrade info file '/usr/local/mysql/data/mysql_upgrade_info' in the MySQL Servers datadir, errno: 13. Could please help me to fix this? –  user1256397 Aug 21 '12 at 22:11
    
did you also try to gain your superuser privileges running sudo ./mysql_upgrade -u root -p? Your error resides in restricted permissions, running the script as superuser will make you pass over those restrictions. Or alternatively you could set different permissions to that folder, so that you can make operation even without superuser privileges –  Valerio Marcellino Aug 21 '12 at 22:20
    
Thanks again. Now I am able to run the sudo bin/mysqld -u root after the upgrade. But it stuck at:Version: '5.5.27' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) for a long time. Is this normal? –  user1256397 Aug 21 '12 at 22:51
    
It means that the service has started. By default it will automatically close after something like 28800 seconds of inactivity. Run ./mysqld --verbose --help for more informations. To manually stop mysqld I think you have to run ./mysqladmin -u root -p shutdown –  Valerio Marcellino Aug 21 '12 at 23:14

To run mysqld on Mac w/o the "startup item", execute the following in Terminal.app

sudo su -
nohup /usr/local/mysql/bin/mysqld_safe &
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.