SEO

Hello everyone,

I am trying to install MySQL on a freebsd virtual server (a "jail")
and I'm falling at pretty much the first fence - if some kind soul
could take pity on me, review the following session and tell me what I
am doing wrong, I would be eternally grateful! Whatever it is, it's
driving me nuts!

Thanks

Bill
-----------------------------

$ su - root

jail0043# grep mysql /etc/passwd
mysql:*:88:88:MySQL Daemon:/nonexistent:/sbin/nologin
jail0043# grep mysql /etc/group
mysql:*:88:

jail0043# cd /usr/ports/databases/mysql51-server
jail0043# make install clean

jail0043# mysql_install_db

jail0043# chown -R mysql /var/db/mysql/
jail0043# chgrp -R mysql /var/db/mysql/

jail0043# grep mysql /etc/rc.conf
mysql_enable="YES"
# mysql_limits (bool): Set to "NO" by default.
# mysql_dbdir (str): Default to "/var/db/mysql"
# mysql_args (str): Custom additional arguments to be passed to
mysqld_safe (default empty).

jail0043# /usr/local/bin/mysqld_safe -user=mysql &
[1] 17146
jail0043# usage:
touch [-A [-][[hh]mm]SS] [-acfhm] [-r file] [-t [[CC]YY]MMDDhhmm[.SS]]
file ...
usage: chown [-fhv] [-R [-H | -L | -P]] owner[:group] file ...
chown [-fhv] [-R [-H | -L | -P]] :group file ...
080513 10:34:47 mysqld_safe Starting mysqld daemon with databases
from /var/db/mysql

jail0043# mysqladmin -u root password
'TopSecret' <------------------
Aaaarrrggghhh!!!!!!
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password:
NO)'

jail0043# ps aux
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME
COMMAND
-----(non-relevant processes omitted from list)-----
root 17146 0.0 0.0 5188 1460 p0 IJ 10:34AM 0:00.01 /bin/
sh /usr/local/bin/mysqld_safe -user=mysql
mysql 17182 0.0 0.9 60464 35604 p0 SJ 10:34AM 0:00.19 /usr/
local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --
user=mysql -us
root 17183 0.0 0.0 2556 824 p0 IJ 10:34AM 0:00.00 sed -
e s/^[0-9]\\{6\\} [0-9:]\\{8\\} *//
root 17184 0.0 0.0 2504 700 p0 IJ 10:34AM 0:00.00
logger -i -t mysqld -p daemon.error

jail0043# hostname
jail0043.vps.secretweb.net
jail0043# uname -a
FreeBSD jail0043.vps.secretweb.net 6.2-STABLE FreeBSD 6.2-STABLE #0:
Sat Aug 11 15:50:16 BST 2007 root@moa.secretweb.net:/usr/src/
sys.xxo/amd64/compile/JAIL amd64
jail0043# uname -n
jail0043.vps.secretweb.net

On Tue, 13 May 2008 12:17:50 +0200, <zeltus.bill@gmail.com> wrote:
> I am trying to install MySQL on a freebsd virtual server (a "jail")
> and I'm falling at pretty much the first fence - if some kind soul
> could take pity on me, review the following session and tell me what I
> am doing wrong, I would be eternally grateful! Whatever it is, it's
> driving me nuts!

> jail0043# mysqladmin -u root password
> 'TopSecret' <------------------
> Aaaarrrggghhh!!!!!!
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password:
> NO)'

mysqladmin -uroot -pTopSecret

mysqladmin -?:
....
-p, --password[=name]
-u, --user=name User for login if not current user.
....
--
Rik Wasmus
[SPAM] Now temporarily looking for some smaller PHP/MySQL projects/work to
fund a self developed bigger project, mail me at rik at rwasmus.nl. [/SPAM]