#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