problems running mysql_install_db5

[Bradley Giesbrecht]

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  
>> ~/.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 -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  
> 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'


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.

--
Brad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20110318/00156122/attachment.html>