#28772: mysql_install_db5 works without '--user=_mysql' option, but mysql.user
table not populated
-----------------------------------+----------------------------------------
Reporter: knightcode1@… | Owner: ryandesign@…
Type: defect | Status: new
Priority: Normal | Milestone:
Component: ports | Version: 1.9.2
Keywords: | Port: mysql5
-----------------------------------+----------------------------------------
Comment(by knightcode1@…):
I have the binary package at /Applications/mysql-5.5.9-osx10.6-x86/, and
it seems to be self contained there. The unix socket and data folders are
all created in separate folders. I don't have a /etc/my.conf, and
/usr/local/ contains some other files whose purpose is definitely
unrelated.
I tried the StackOverflow link from the previous comment but using
'_mysql' as the user and group instead. mysql_install_db --user=_mysql'
didn't complain. I ran the server using 'sudo /opt/local/bin/mysqld_safe5
--user=_mysql &' and got access denied with a subsequent 'sudo
/opt/local/bin/mysqladmin5 -u root -p'. Restarting the server with --skip-
grant-tables, I found that the mysql.user table is still empty.
--
Ticket URL: <https://trac.macports.org/ticket/28772#comment:11>
MacPorts <http://www.macports.org/>
Ports system for Mac OS