problem with mysql 5 install and configuration

[Érico]

Hi

I am able to start the service :

$ sudo -u _mysql mysqld_safe5

~ ericomtx$ ps aux | grep mysql
_mysql     800   0.0  0.4  2519304  17852 s002  S+    3:27PM   0:00.10
/opt/local/libexec/mysqld --basedir=/opt/local
--datadir=/opt/local/var/db/mysql5
--log-error=/opt/local/var/db/mysql5/Ericos-MacBook-Pro.local.err
--pid-file=/opt/local/var/db/mysql5/Ericos-MacBook-Pro.local.pid
_mysql     759   0.0  0.0  2435544    864 s002  S+    3:27PM   0:00.02
/bin/sh /opt/local/bin/mysqld_safe5
ericomtx   823   0.0  0.0  2426928    336 s003  R+    3:31PM   0:00.00 grep
mysql

And I am able to ping :

Ericos-MacBook-Pro:~ ericomtx$ mysqladmin5 -u root -p ping
Enter password:
mysqld is alive


But I am not able to connect to it

what is the command to use ? and what would be the id ? root or_mysql or
both ?

there is a standard db named mysql , correct ?

Regards
Érico


2012/1/8 Ryan Schmidt <ryandesign at macports.org>

> On Jan 8, 2012, at 13:54, Érico wrote:
>
> > 6. the problem is my id ... if I try to start with it with this alias in
> my .profile :
> > alias mysqlstart='sudo /opt/local/bin/mysqld_safe5 &'
>
> You do not need any such alias. There should be no need to routinely
> manually start mysqld. Once everything is working, let launchd start it for
> you ("sudo port load mysql5-server"). Until everything is working, you can
> manually start mysqld_safe5.
>
>
> > I run $mysqlstart:
> > ericomtx$ mysqlstart
> > [1] 315
> > ericomtx$ ps aux | grep mysql
> > root       315 100.0  0.0  2436236   1668 s000  R     5:40PM   0:03.51
> sudo /opt/local/bin/mysqld_safe5
> > ericomtx   317   0.0  0.0  2435120    536 s000  R+    5:40PM   0:00.00
> grep mysql
>
> You're supposed to start it as the _mysql user, not as the root user.
>
> sudo -u _mysql mysqld_safe5
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20120117/8b15cbc7/attachment.html>