problem with mysql 5 install and configuration

[Érico]

Hi Ryan

It worked with the set :
mysql5 @5.1.60_0 (active)
mysql5-server @5.1.60_0 (active)
php5 @5.3.8_1+apache2 (active)
php5-mysql @5.3.8_0+mysqlnd (active)
phpmyadmin @3.4.9_0 (active)


1. I copied back /opt/local/etc/LaunchDaemons/org.macports.mysql5 for
/Library/LaunchDaemons

2. restarted the OS

3. ran : mysql5 -uroot -p


4. But I had also to edit the  /opt/local/etc/mysql5/my.cnf with :
[mysqld_safe]
socket =/opt/local/var/run/mysql5/mysqld.sock

[mysqld]
socket = /opt/local/var/run/mysql5/mysqld.sock

[mysqld5]
socket = /opt/local/var/run/mysql5/mysqld.sock

...

to use phpmyadmin I did configuration in /opt/local/etc/php.ini :
mysql.default_socket = /opt/local/var/run/mysql5/mysqld.sock
mysqli.default_socket = /opt/local/var/run/mysql5/mysqld.sock
pdo_mysql.default_socket = /opt/local/var/run/mysql5/mysqld.sock

now all the environment is set ...

Thks&Regards
Érico



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

>
> On Jan 17, 2012, at 12:52, Érico wrote:
>
> > both work in command line :
> >
> > step 1 => $ mysql5 -u root --socket=/opt/local/var/run/mysql5/mysqld.sock
>
> You should not need to inform it where the socket is. It should already
> know. Unless you changed it in your my.cnf.
>
>
> > step 2 => $ mysql5 -u root -p
> >
> > I am trying now to use phpmyadmin on it and I am getting the following :
> >
> > Error
> > #2002 - The server is not responding (or the local MySQL server's socket
> is not correctly configured)
>
> If you are using phpmyadmin installed by MacPorts, along with MacPorts
> apache2, php5 and php5-mysql, and php5-mysql's default variant +mysqlnd,
> did you follow the instructions the php5-mysql port printed when it was
> installed?
>
> --->  Computing dependencies for php5-mysql
> --->  Fetching php5-mysql
> --->  Verifying checksum(s) for php5-mysql
> --->  Extracting php5-mysql
> --->  Configuring php5-mysql
> --->  Building php5-mysql
> --->  Staging php5-mysql into destroot
> --->  Installing php5-mysql @5.3.9_0+mysqlnd
> To use mysqlnd with a local MySQL server, edit /opt/local/etc/php5/php.ini
> and set
> mysql.default_socket, mysqli.default_socket and pdo_mysql.default_socket
> to /opt/local/var/run/mysql5/mysqld.sock
> --->  Activating php5-mysql @5.3.9_0+mysqlnd
> --->  Cleaning php5-mysql
>
>
> > do I need to set some other parameter on :
> > sudo -u _mysql mysqld_safe5 &
> >
> > ?
> >
> > before running step 1 or 2 ....
>
> I don't think so. But now that you have the MySQL server starting
> properly, you should no longer be using mysqld_safe5 directly; instead, run
> "sudo port load mysql5-server" to let launchd manage starting the server
> for you.
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20120118/4b68e010/attachment.html>