[MacPorts] #28772: mysql_install_db5 works without '--user=_mysql' option, but mysql.user table not populated
MacPorts
noreply at macports.org
Thu Mar 17 08:56:40 PDT 2011
#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 pixilla@…):
Replying to [comment:7 knightcode1@…]:
> I also downloaded the binary mysql package from mysql.com. I have its
server up and running, but I had to run it from my user account and change
the ownership of its 'data' directory accordingly.
This could conflict with your MacPorts mysql install. I recommend
uninstalling this binary mysql package, delete or move /usr/local if it
exists and delete or move /etc/my.cnf if it exists.
> Maybe there's something I'm just not understanding about how to set this
up with another user account. Should I just create another account in the
System Preferences?
No, the "_mysql" user account should already exist.
{{{
$ dscl localhost -list /Local/Default/Users
$ dscl localhost -read /Local/Default/Users/_mysql
}}}
You should be able to start mysql5-server with:
{{{
$ sudo port load mysql5-server
}}}
Looks like the mysql root user exists and has a blank password. Add "-p"
and hit enter "empty password" when prompted for a password.
{{{
$ mysqladmin5 -p -u root password 'new-password'
}}}
--
Ticket URL: <https://trac.macports.org/ticket/28772#comment:8>
MacPorts <http://www.macports.org/>
Ports system for Mac OS
More information about the macports-tickets
mailing list