installing mysql using pkgin

[vajonam]

obelix:56:/usr/local#pkgin install mysql-server

reading local summary...

processing local summary...

updating database: 100%

calculating dependencies... done.

nothing to upgrade.

1 packages to be installed: mysql-server-5.6.20 (0B to download, 287M to install)

proceed ? [Y/n] y

downloading packages...

installing packages...

installing mysql-server-5.6.20...

===========================================================================

This package has SMF support.  You may use svcadm(1M) to 'enable', 'disable'

or 'restart' services.  To enable the instance(s) for this package, run:

        /usr/sbin/svcadm enable svc:/pkgsrc/mysql:default

Use svcs(1) to check on service status.  See smf(5) for more information.

===========================================================================

===========================================================================

$NetBSD: MESSAGE,v 1.1 2013/02/13 21:00:09 adam Exp $

After the tables are set up and the MySQL server is running,

please remember to set a password for the MySQL root user!

This is done by running both:

  /opt/local/bin/mysqladmin -u root -p password 'new-password'

  /opt/local/bin/mysqladmin -h `hostname` -u root -p password 'new-password'

The "Enter password:" prompt is asking for the existing password.

As there is no existing password, just press the Return key.

There is a script distributed with MySQL that can help you lock down

an installation.  This script has been installed to

  /opt/local/bin/mysql_secure_installation.

Please see the manual and the MySQL web site for more instructions.

===========================================================================

pkg_install warnings: 0, errors: 0

reading local summary...

processing local summary...

updating database: 100%

marking mysql-server-5.6.20 as non auto-removable

However I find the number of the files have a (zero) size

I am running this on a virtualbox while I figure out how to do all the upgrade and fiddly bits. 

obelix:66:/usr/local#ls -l /opt/local/bin/mysql* 

-rwxr-xr-x   1 root     root     3622280 Jan 13  2015 /opt/local/bin/mysql*

-rwxr-xr-x   1 root     root     4009360 Jan 13  2015 /opt/local/bin/mysql_client_test*

-rwxr-xr-x   1 root     root     15397048 Jan 13  2015 /opt/local/bin/mysql_client_test_embedded*

-rwxr-xr-x   1 root     root        6817 Jan 13  2015 /opt/local/bin/mysql_config*

-rwxr-xr-x   1 root     root     2599424 Aug 13 18:21 /opt/local/bin/mysql_config_editor*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_convert_table_format*

-rwxr-xr-x   1 root     root     14991112 Jan 13  2015 /opt/local/bin/mysql_embedded*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_find_rows*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_fix_extensions*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_install_db*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_plugin*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_secure_installation*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_setpermission*

-rwxr-xr-x   1 root     root     3283768 Jan 13  2015 /opt/local/bin/mysql_tzinfo_to_sql*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_upgrade*

-rwxr-xr-x   1 root     root     3330896 Jan 13  2015 /opt/local/bin/mysql_waitpid*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysql_zap*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlaccess*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlaccess.conf*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqladmin*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlbinlog*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlbug*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlcheck*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqld_multi*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqld_safe*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqldump*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqldumpslow*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlhotcopy*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlimport*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlshow*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqlslap*

-rwxr-xr-x   1 root     root           0 Aug 13 18:21 /opt/local/bin/mysqltest*

-rwxr-xr-x   1 root     root     15117888 Jan 13  2015 /opt/local/bin/mysqltest_embedded*

Any ideas as to my all these are 0 size? 

[vajonam]

Also i think this is no longer valid.

http://bit.ly/mysql-setup

for the mysql manual setup can you please update that dropbox link?