problems running mysql_install_db5
pixilla at macports.org
Fri Mar 18 05:35:55 PDT 2011
On Mar 17, 2011, at 2:22 PM, Bradley Giesbrecht wrote:
>> $ ls -la /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/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
> There are spaces missing after each my.cnf. Try this:
> $ /opt/local/lib/mysql5/bin/my_print_defaults | grep my.cnf | xargs
> ls -l
> 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
> $ 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'
I had a mysql conf file at ~/.my.cnf with a username and password
declaration. After removing this file the -p above was no longer.
The mysql5 port and mysql in general behave as advertised.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the macports-users