problem with mysql 5 install and configuration

[Érico]

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/f3f20a78/attachment.html>