![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
CONTENTS
Lastmodified 2019-02-06 (水) 09:20:41
# 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 804：本日 1：昨日 1
