mysql55 to 57 の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• mysql55 to 57 へ行く。
• mysql55 to 57 の差分を削除

#author("2019-02-06T09:17:22+09:00","default:kuji","kuji")
#author("2019-02-06T09:20:41+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified　&lastmod;
----
*mysql55 to 57 [#a078a175]


 # portinstall databases/mysql57-server


 # pkg delete openldap-client-2.4.47
 Updating database digests format: 100%
 Checking integrity... done (0 conflicting)
 Deinstallation has been requested for the following 3 packages (of 0 packages in the universe):
 
 Installed packages to be REMOVED:
        openldap-client-2.4.47
        php71-ldap-7.1.26_1
        php71-extensions-1.0
 
 Number of packages to be removed: 3
 
 The operation will free 6 MiB.
 
 Proceed with deinstalling packages? [y/N]:


  1043  8:07    portinstall databases/mysql57-server
  1044  8:54    portinstall php71-ldap-7.1.26_1
  1045  8:55    portinstall php71-extensions-1.0



Stopping mysql.
Waiting for PIDS: 96166.
Starting mysql.
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
root@hotshot:/usr/home/db # /usr/local/etc/rc.d/mysql-server restart
mysql not running? (check /var/db/mysql/hotshot.smb.net.pid).
Starting mysql.

起動しないので、

/usr/local/etc/mysql/my.cnf

コメントアウトと編集

 #lower_case_table_names          = 1
 lower_case_table_names          = 0
 
 #innodb_data_file_path           = ibdata1:128M:autoextend


 mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
 Checking if update is needed.
 Checking server version.
 Running queries to upgrade MySQL server.
 mysql_upgrade: [ERROR] 1146: Table 'mysql.slave_relay_log_info' doesn't exist

----
Total access &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);