hns - 日記自動生成システム - Version 2.19.9

先月 2019年02月 来月
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28
Namazu for hns による簡易全文検索
詳しくは 詳細指定/ヘルプを参照して下さい
検索式:

2019年02月16日() 旧暦 [n年日記] [更新:"2004/08/09 23:43:33"]

#1 sudo pkgin install mysql-server

examplehp@makoto 14:48:19/190217(/export/backup)% sudo pkgin install mysql-server
reading local summary...
processing local summary...
pkg_summary.bz2                                                                                                                                     100% 3106KB 194.1KB/s   00:16    
calculating dependencies...done.

5 packages to refresh:
  icu-63.1nb1 perl-5.28.1 mysql-client-5.7.24nb2 lz4-1.8.3 editline-3.1.20150325

1 package to upgrade:
  boost-libs-1.69.0

1 package to install:
  mysql-server-5.7.24nb1

5 to refresh, 1 to upgrade, 1 to install
73M to download, 433M to install

proceed ? [Y/n] y
icu-63.1nb1.tgz                                                                                                                                     100%   16MB   2.0MB/s   00:08    
perl-5.28.1.tgz                                                                                                                                     100%   11MB   2.2MB/s   00:05    
mysql-client-5.7.24nb2.tgz                                                                                                                          100% 2171KB   1.1MB/s   00:02    
lz4-1.8.3.tgz                                                                                                                                       100%   97KB  96.8KB/s   00:01    
editline-3.1.20150325.tgz                                                                                                                           100%  123KB 123.1KB/s   00:00    
boost-libs-1.69.0.tgz                                                                                                                               100% 4646KB   1.5MB/s   00:03    
mysql-server-5.7.24nb1.tgz                                                                                                                          100%   40MB   2.3MB/s   00:17    
refreshing icu-63.1nb1...
refreshing perl-5.28.1...
refreshing mysql-client-5.7.24nb2...
refreshing lz4-1.8.3...
refreshing editline-3.1.20150325...
pkg_install warnings: 0, errors: 0
upgrading boost-libs-1.69.0...
pkg_install warnings: 0, errors: 0
installing mysql-server-5.7.24nb1...
===========================================================================
$NetBSD: MESSAGE,v 1.1 2016/09/16 06:49:12 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:

  /usr/pkg/bin/mysqladmin -u root -p password 'new-password'
  /usr/pkg/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

  /usr/pkg/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...
marking mysql-server-5.7.24nb1 as non auto-removable
exampleh@makoto 14:50:45/190217(/export/backup)% 

log:

cat /var/log/mysqld.log

pkg_info -D mysql-server:

examplehp@makoto 15:03:41/190217(/export/backup)% pkg_info -D mysql-server
Information for mysql-server-5.7.24nb1:

Install notice:
===========================================================================
$NetBSD: MESSAGE,v 1.1 2016/09/16 06:49:12 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:

  /usr/pkg/bin/mysqladmin -u root -p password 'new-password'
  /usr/pkg/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

  /usr/pkg/bin/mysql_secure_installation.

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

===========================================================================
examplehp@makoto 15:51:39/190217(/export/backup)% history
   43  sudo vi /usr/pkg/etc/my.cnf
   44  sudo mysqld -u root -p
   45  sudo vi /usr/pkg/etc/my.cnf
   46  sudo mysqld -u root -p
   47  mkdir /tmp/mysql
   48  sudo chown mysql /tmp/mysql/
   49  sudo mysqld -u root -p
   50  sudo mkdir /var/mysql/tmp
   51  sudo chown mysql  /var/mysql/tmp
   52  sudo mysqld -u root -p
   53  ls -l /var/mysql/iblog/
   54  mkdir /var/mysql/iblog
   55  sudo mkdir /var/mysql/iblog
   56  sudo chown mysql /var/mysql/iblog
   57  sudo mysqld -u root -p
   58  sudo mysqld -u root
  1. sudo mysqld -u root
    
    と入力すると起動する
  2. /usr/pkg/etc/my.cnf の次の行を有効にする (## の文字を消す)
    ## skip-grant-tables
    
  3. sudo mysqld -u root
    
    で起動する
  4. 次のように入力する
    mysql -u root
    use mysql;
    
    
    UPDATE user SET authentication_string=password('  ') WHERE user='root';
    
    flush privileges;
    
    quit
    
    項目 の一時変更を元に戻す
  5. 1194769      4 -rw-r-----    1 root              mysql                   303 Feb 17 16:07 /var/mysql/ib_buffer_pool
    1218011  98400 -rw-r-----    1 root              mysql              50331648 Feb 17 15:50 /var/mysql/iblog/ib_logfile1
    examplehp$ sudo chown mysql /var/mysql/ib_buffer_pool
    examplehp$ sudo chown mysql /var/mysql/iblog/ib_logfile1
    
    examplehp$ sudo /etc/rc.d/mysqld start
    Starting mysqld.
    examplehp$ ps ax|grep mysql
     7371 ?     Ss     0:00.08 sh -c logger -t nbmysqld_safe 
    10188 ?     S      0:00.00 logger -t nbmysqld_safe 
    20232 ?     Ss     0:00.08 /bin/sh /usr/pkg/bin/mysqld_safe --user=mysql --datadir=/var/mysql --pid-file=/var/mysql/.pid 
    22494 ?     Sl     0:00.54 /usr/pkg/sbin/mysqld --basedir=/usr/pkg --datadir=/var/mysql --plugin-dir=/usr/pkg/lib/mysql/plugin --
    10865 pts/1 O+     0:00.00 grep mysql 
    



最近の日記
2024年03月10日
停電 (瞬電)
2024年03月03日
the second try on bare-metal
useradd
2024年02月29日
opendkim and senmail
2024年01月24日
chat/iam 0.0.8
2024年01月21日
uselocale vs setlocale (textproc/R-readxl)
以上、1 日分です。
タイトル一覧
カテゴリ分類
Powered by hns-2.19.9, HyperNikkiSystem Project

Count.cgi (since 2000/02/05)