解决mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

本文解决了一个常见的MySQL服务器启动问题,原因是/var/lib/mysql目录的访问权限设置不正确。通过使用chown命令更改所有者和组为mysql:mysql,然后重新启动服务器,成功解决了问题,并自动生成了mysql.sock文件。
原因是,/var/lib/mysql 的访问权限问题。

shell> chown -R mysql:mysql /var/lib/mysql

接着启动服务器

shell> /etc/init.d/mysql start

服务器正常启动后察看 /var/lib/mysql 自动生成mysql.sock文件。

困扰2天的问题终于得以解决了。不过这样做会不会有安全问题呢?
 
[root@node3 bin]# ls ibd2sdi my_print_defaults mysqld mysql_migrate_keyring mysql_upgrade innochecksum mysql mysqld-debug mysqlpump perror lz4_decompress mysqladmin mysqld_multi mysql_secure_installation zlib_decompress myisamchk mysqlbinlog mysqld_safe mysqlshow myisam_ftdump mysqlcheck mysqldump mysqlslap myisamlog mysql_config mysqldumpslow mysql_ssl_rsa_setup myisampack mysql_config_editor mysqlimport mysql_tzinfo_to_sql [root@node3 bin]# ./mysqld --initialize --console --lower-case-table-names=1 ./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.11' not found (required by ./mysqld) ./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by ./mysqld) ./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.22' not found (required by ./mysqld) ./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by ./mysqld) ./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by ./mysqld) ./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by ./mysqld) ./mysqld: /lib64/libm.so.6: version `GLIBC_2.27' not found (required by ./mysqld) ./mysqld: /lib64/libc.so.6: version `GLIBC_2.28' not found (required by ./mysqld) ./mysqld: /lib64/libc.so.6: version `GLIBC_2.25' not found (required by /usr/local/mysql-8.1.0/bin/../lib/private/libcrypto.so.3) ./mysqld: /lib64/libc.so.6: version `GLIBC_2.28' not found (required by /usr/local/mysql-8.1.0/bin/../lib/private/libprotobuf-lite.so.3.19.4) ./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /usr/local/mysql-8.1.0/bin/../lib/private/libprotobuf-lite.so.3.19.4) ./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /usr/local/mysql-8.1.0/bin/../lib/private/libprotobuf-lite.so.3.19.4) ./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /usr/local/mysql-8.1.0/bin/../lib/private/libprotobuf-lite.so.3.19.4) ./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /usr/local/mysql-8.1.0/bin/../lib/private/libprotobuf-lite.so.3.19.4)
最新发布
08-28
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值