- 追加された行はこの色です。
- 削除された行はこの色です。
#author("2019-02-06T08:05:40+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]);