![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
CONTENTS
Lastmodified 2016-07-29 (金) 06:26:59
# /usr/local/etc/rc.d/mysql-server start ←デーモンを起動します # /usr/local/etc/rc.d/mysql-server restart ←デーモンを再起動します # /usr/local/etc/rc.d/mysql-server stop ←デーモンを停止します
************************************************************************ Remember to run mysql_upgrade the first time you start the MySQL server after an upgrade from an earlier version. ************************************************************************
# mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
BB3.phpbb_acl_groups OK
BB3.phpbb_acl_options OK
BB3.phpbb_acl_roles OK
BB3.phpbb_acl_roles_data OK
BB3.phpbb_acl_users OK
BB3.phpbb_attachments OK
BB3.phpbb_banlist OK
BB3.phpbb_bbcodes OK
BB3.phpbb_bookmarks OK
BB3.phpbb_bots OK
BB3.phpbb_config OK
: : :
phpmyadmin.pma_designer_coords OK
phpmyadmin.pma_history OK
phpmyadmin.pma_pdf_pages OK
phpmyadmin.pma_relation OK
phpmyadmin.pma_table_coords OK
phpmyadmin.pma_table_info OK
phpmyadmin.pma_tracking OK
phpmyadmin.pma_userconfig OK
Running 'mysql_fix_privilege_tables'...
OK
root@piano2nd:/var/db/mysql_dist #
http://syamanaka.com/mysql-data-backup-mysqldump/
#/bin/sh! setenv PAGER cat && \ /usr/sbin/freebsd-update fetch && \ /usr/sbin/freebsd-update install ; \ /usr/sbin/portsnap fetch update && \ /usr/local/sbin/portversion -vl'<' && \ /usr/sbin/pkg audit -F /usr/local/bin/mysql_upgrade -u root -pPASSWORD ←半角開けないで詰めて記述
Total access 1804：本日 1：昨日 1
