BUG:Port cant execute mysqld_safe

[naruto97d@…]

I cant execute mysqld_safe after i run mysql_install_db without sudo permission.

[ryandesign (Ryan Carsten Schmidt)]

I couldn't tell from your message: which did you run without sudo -- mysqld_safe or mysql_install_db? As far as I know, you should run both commands with sudo -- the former should run as root while the latter should run as the mysql user -- so I'm not surprised you're running into trouble if you don't do this.

Your patch just changes a "mkdir" into a "mkdir -p", which would create intermediate directories. I do not see how this would relate to your permissions issues. However, this may be a useful patch generally, which you should feel free to file in the ​MySQL issue tracker.

[(none)]

Milestone Port Bugs deleted

[naruto97d@…]

Replying to ryandesign@…:

I couldn't tell from your message: which did you run without sudo -- mysqld_safe or mysql_install_db? As far as I know, you should run both commands with sudo -- the former should run as root while the latter should run as the mysql user -- so I'm not surprised you're running into trouble if you don't do this.

Your patch just changes a "mkdir" into a "mkdir -p", which would create intermediate directories. I do not see how this would relate to your permissions issues. However, this may be a useful patch generally, which you should feel free to file in the ​MySQL issue tracker.

sry i didnt tell the thing clearly. It was, when i execute the first step mysql_install_db,i forgot to do it with sudo permission,but i can do it,and tells nothing wrong.but when i execute the 2nd step:mysqld_safe,it'll always tells that cant do it,it didnt create all file and dirs correctly, especially sub dir. so i need to mkdir. i hope it can be much better and make sub dir automaticly. so i change it from mkdir to mkdir -p.

[ryandesign (Ryan Carsten Schmidt)]

I'm not going to do anything with this in MacPorts. The port behaves correctly if you use the correct setup procedure. If you feel your change is useful, then it would be useful generally, and not just for MacPorts users, so you should send it to the developers of MySQL.