MySQL报错记录


记录日常使用过程中MySQL出现报错及解决方法.

Table ‘performance_schema.session_variables’ doesn’t exist

出现在mysql版本更新后,

mysql_upgrade -u root -p –force

systemctl restart mysqld

No directory, logging in with HOME=/

usermod -d /var/lib/mysql/ mysql#第一步
chown -R mysql:mysql /var/lib/mysql#第三步

Don’t know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load (Mac)

bundle config --local build.mysql2 "--with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include"