mysql 好好的突然出现了问题,在网上看了很多种解决方案也没解决了。自己弄了一上午,也没弄好。
今天晚上看了一下自己的 my.cnf文件是空的,原来是mysql在新版中去掉了默认配置文件my.cnf如果需要可以手动创建。
可以通过命令: mysql --verbose --help | grep my.cnf
找到文件 :sudo vim /etc/my.cnf
写入内容:
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
default-character-set=utf8
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
character-set-server=utf8
init_connect='SET NAMES utf8
port = 3306
socket