MySQL in a Jail

[unkis17]

Just learning about jails now and I am curious as to running full MySQL in a Jail. I want to run MySQL so I can centralize my database used by XBMC. I am running N4F Embedded and this seems like the proper way to go about it rather then trying to hack in MySQL from some of the other posts I have read

Can anyone shed some light on this?

Thank you,
Unkis

[fsbruva]

What do you want to do? If you mean install a SQL server, just look into a howto for installing to FreeBSD. You will basically be installing it inside a normal, vanilla copy of FreeBSD.

[sandule]

Can someone post a HowTo for this? For a Mysql and phpMyAdmin setup?

[fsbruva]

Can someone post a HowTo for this? For a Mysql and phpMyAdmin setup?

?????????????????????????

Lots already have:
http://caffetine.org/freebsd-amp.php

http://www.freebsdmadeeasy.com/tutorial ... reebsd.php
http://www.freebsdmadeeasy.com/tutorial ... reebsd.php

http://www.iceflatline.com/2011/11/how- ... n-freebsd/

Google search phrase: "mysql phpadmin freebsd" <-- So easy, even fsbruva can do it!!!

[alexey123]

I'll install mysql on jail today, and I'll write howto

Ouups!
PHP not want install from ports for Appache. Message is

{standard input}: Assembler messages:
{standard input}:2066: Warning: end of file not at end of a line; newline inserted
{standard input}:3442: Error: no such instruction: `su'
cc: Internal error: Killed: 9 (program cc1)
Please submit a full bug report.
See <URL:http://gcc.gnu.org/bugs.html> for instructions.
*** [ext/date/lib/parse_date.lo] Error code 1
1 error
*** [do-build] Error code 1

Stop in /usr/ports/lang/php5.
*** [install] Error code 1

Stop in /usr/ports/lang/php5.

When I try install php as package, I not receive module for appache
++++++++++++++++++++++++++++++++++++
But for mysql server need only create database and user, and my steps for instal mysql55 are

Code: Select all

pkg_add -r mysql55-server
rehash
cd /usr/local
mysql_install_db
chown -R mysql:mysql /usr/local/data/
mysqld_safe &

I add mysql_enable="YES" to /etc/rc.conf
When server started I define password as

/usr/local/bin/mysqladmin -u root -h localhost password <my-password>

I start mysql with

Code: Select all

/usr/local/etc/rc.d/mysql-server restart

For manipulate with users and databases I use webmin in this time.

Code: Select all

pkg_add -r webmin

Add webmin_enable="YES" to /etc/rc.conf and run install script

Code: Select all

/usr/local/lib/webmin/setup.sh

Script ask me some questions, I define password and use SSL. For start webmin I type

Code: Select all

/usr/local/etc/rc.d/webmin restart

and I have access to my databases, after webmin install database modules.