problem with mysql 5 install and configuration

Érico ericomtx at gmail.com
Thu Jan 5 08:33:01 PST 2012


Hello !!

Can can I make a 100% reinstall ?

with :

1. $port uninstall  mysql5-server @5.1.60_0

2. $port clean mysql5-server @5.1.60_0

How can I make sure when uninstalling the _mysql id will be removed from my
system ?

I will proceed cleaning up the symb links , my.cnf and the socket file I
created

Thks&Regards

2012/1/5 Érico <ericomtx at gmail.com>

> Hi
>
> I am facing an issue installing both :
>
> mysql5-server @5.1.60_0
>
> mysql5 @5.1.60_0
>
> after have port installed both I run :
> sudo -u _mysql mysql_install_db5
>
> then I try :
> bash-3.2# mysqladmin5 -u root -p ping
> Enter password:
> mysqladmin5: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/opt/local/var/run/mysql5/
> mysqld.sock' (2)'
> Check that mysqld is running and that the socket:
> '/opt/local/var/run/mysql5/mysqld.sock' exists!
>
>
> searching on google I've got the following :
>
> 1. run the command:
> $ mysql_config5 --socket
> result => /opt/local/var/run/mysql5/mysqld.sock
>
>
> 2. add 2 symb links
> sudo ln -s /opt/local/var/run/mysql5/mysqld.sock /temp/mysql.sock
> sudo mkdir /var/mysql
> sudo ln -s /opt/local/var/run/mysql5/mysqld.sock /var/mysql/mysql.sock
>
>
> 3. once I start it after both links are create ... I get the following :
>
> bash-3.2# /opt/local/lib/mysql5/bin/mysqld_safe &
> [1] 18012
> bash-3.2# 120102 17:06:47 mysqld_safe Logging to
> '/opt/local/var/db/mysql5/Ericos-MacBook-Pro.local.err'.
> 120102 17:06:47 mysqld_safe Starting mysqld daemon with databases from
> /opt/local/var/db/mysql5
> 120102 17:06:53 mysqld_safe mysqld from pid file
> /opt/local/var/db/mysql5/Ericos-MacBook-Pro.local.pid ended
>
> for some reason is not allowing the process to start ... it kills it right
> after
>
> /opt/local/var/db/mysql5/Ericos-MacBook-Pro.local.err is empty ... nothing
> is written in it ...
>
> Is it mandatory to use :
> sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
>
> or is it only if I want mysql to load on startup
>
> also after the last bash statement I ran this :
> bash-3.2# ps aux | grep mysql
> root     77076   0.0  0.0  2435120    484 s000  R+    5:40PM   0:00.00
> grep mysql
> root     76948   0.0  0.0  2456132   1060   ??  Ss    5:38PM   0:00.00
> /opt/local/bin/daemondo --label=mysql5 --start-cmd
> /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ;
> --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper
> stop ; --restart-cmd
> /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ;
> --pid=none
>
>
>
> is there any specific content for the :
> /opt/local/var/run/mysql5/mysqld.sock  ?
>
> I was creating a empty file with :
> $ touch /opt/local/var/run/mysql5/mysqld.sock
>
> also I have edited the /opt/local/etc/mysql5/my.cnf file with the content
> :
>
> mysqld_safe]
> socket =/temp/mysql.sock
>
> [mysqld]
> socket = /temp/mysql.sock
>
>
> Any idea why the process is being killed ?
>
> Thks
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20120105/809b2b46/attachment.html>


More information about the macports-users mailing list