On 29/08/06, Matthew Peltzer <[EMAIL PROTECTED]> wrote:
>
> I just recently installed OpenBSD 3.9 and installed mysql client &
> sever via pkg_add. I also added the following lines to rc.local:
>
> > if [ X"${mysqld_flags}" != X"NO" ]; then
> > if [ -x /usr/local/bin/mysqld_safe ]; then
> > echo -n ' mysqld'; /usr/local/bin/mysqld_safe
> ${mysqld_flags} &
> > fi
> > fi
>
> and this one to rc.conf.local:
>
> > mysql_flags=
>
>
> I've since noticed (initiated by phpMyAdmin reporting there were no
> databases installed, not even the default ones) that there are two
> mysql process running:
>
> > ps -ax | grep mysql
> 17392 ?? I 0:01.63 /usr/local/libexec/mysqld
> --basedir=/usr/local --datadir=/var/mysql --user=_mysql --pid-f
> 13452 C0- I 0:00.14 /bin/sh /usr/local/bin/mysqld_safe
>
>
> I had a similar setup on OpenBSD 3.8 some time ago, but did not have
> this issue. Is this simply a difference between the two versions?
> Can I remove the lines from rc.*local? Where does that first mysqld
> process get started from?
>
> --
> -- Matthew Peltzer
> -- [EMAIL PROTECTED]
>
>
This looks fine to me. You should have both these running:
$ ps -ax | grep mysql
19930 p0- I 0:00.06 /bin/sh /usr/local/bin/mysqld_safe --user=_mysql
--log --open-files-limit=256
26809 p0- I 81:48.46 /usr/local/libexec/mysqld --basedir=/usr/local
--datadir=/var/mysql --user=_mysql --pid-file=
Try connecting to the db with the mysql client and running "show databases":
$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1456 to server version: 5.0.21-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mm |
| mysql |
| test |
| wordpress |
+--------------------+
5 rows in set (0.03 sec)
mysql>
