problems running mysql_install_db5

Bradley Giesbrecht pixilla at
Thu Mar 17 14:22:44 PDT 2011

On Mar 17, 2011, at 1:17 PM, David Gentry wrote:

> Bradley,
> Thank you for your response.  I am responding to your request that I  
> run 3 commands:
> $ /opt/local/lib/mysql5/bin/my_print_defaults client mysql mysqld
> --port=3306
> --socket=__PREFIX/var/run/mysqld/mysqld.sock


> --skip-innodb
> --user=mysql
> --pid-file=__PREFIX/var/run/mysqld/


> --socket=__PREFIX/var/run/mysqld/mysqld.sock


> --port=3306
> --log=__PREFIX/var/log/mysql/mysql.log


> --basedir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64


> --datadir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data


> --language=__PREFIX/share/mysql/english


> --skip-locking
> --set-variable=key_buffer=16M
> --set-variable=max_allowed_packet=1M
> --set-variable=thread_stack=128K
> --enable-named-pipe
> --connect_timeout=3

Did you replace the actual "prefix" with "__PREFIX" or is that the  
unaltered output?
"__PREFIX" is wrong. These paths should have the same prefix as your  
MacPorts install.
should be

> $ ls -la /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf  
> ~/.my.cnf
> ls: /Users/davidgentry/.my.cnf: No such file or directory
> ls: /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf: Not a  
> directory

There are spaces missing after each my.cnf. Try this:
$ /opt/local/lib/mysql5/bin/my_print_defaults | grep my.cnf | xargs ls  

We need to clean up and start over. Mysql is actually an easy install  
so if you clean it up well we can have you up and running quickly.

$ sudo port unload mysql5-server
$ sudo port uninstall mysql5-server
$ sudo port uninstall mysql5

Below we will move things out of the way. You can delete them if there  
is not data to worry about preserving.
$ sudo mv /usr/local /usr/local_moved
$ sudo mv /etc/my.cnf /etc/my.cnf_moved
$ sudo mv /etc/mysql /etc/mysql_moved
$ sudo mv /opt/local/var/db/mysql5 /opt/local/var/db/mysql5_moved

$ sudo port install mysql5-server
$ sudo -u _mysql mysql_install_db5
$ sudo port load mysql5-server

Note about next command: press enter at password prompt.
$ mysql5 -u root -p
mysql> show databases;
mysql> exit;

Now create your root password if you like.
$ mysqladmin5 -p -u root password 'new-password'

If any of the above steps fail, stop there and report to the list.

Bradley Giesbrecht (pixilla)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the macports-users mailing list