mysql常见报错有哪些？Mysql 配置文件中utf8的设置：

[client]
#password = your_password
port = 3306
socket = /date/mysql/mysql.sock
default-character-set=utf8
# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /date/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 4M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU’s*2 for thread_concurrency
thread_concurrency = 8
default-character-set=utf8

查看mysql二进制日志
Mysqlbin -uroot -plinux mysql-bin.000001
mysqlbinlog: unknown variable ‘default-character-set=utf8′
当出现了以上的错误时，解决的办法：
vi /etc/my.cnf
#password = your_password
port = 3306
socket = /date/mysql/mysql.sock
#default-character-set=utf8
然后保存！
注意：当查看完二进制日志后，一定要把它再修改回去！
1、service mysql start
Starting MySQL/etc/init.d/mysql: line 151: kill: (3695) – No such process
可能是selinux没有关闭所造成的
可能是二进制日志被删除，解决办法如下：
rm -rf mysql-bin.index
service mysql start
service mysql start
Starting MySQL……Manager of pid-file quit without updati[FAILED]
1)可有是配置文件中socket没有设置好
vi /etc/my.cnf
[client]
…..
socket = /tmp/mysql.sock
…..
[mysqld]
…..
socket = /tmp/mysql.sock
…..
将socket所在位置修改一下，注意：这个目录一定要可写！
可能是配置文件中key_buffer 设置过大，同时查看free -m 剩余多少！
vi /etc/my.cnf
……
key_buffer = 5M (当内存很少的时候才会出现2这个问题)
mysql -p
ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES)
这是因为你输入的密码错误！
mysqladmin -uroot password ‘cc’
error: ‘Access denied for user ‘root’@'localhost’ (using password: NO)’
这是因为你以前设置过了密码！
解决办法：
mysqladmin -uroot -plinux password ‘cc’

Mysqlbinlog报错
mysqlbinlog: unknown variable ‘default_character_set=utf8′
[root@slaveDB var]# mysqlbinlog slaveDB-relay-bin.000109
mysqlbinlog: unknown variable ‘default_character_set=utf8′

无法读取LOG文件,加入–no-defaults参数就可以了.
#mysqlbinlog –no-defaults -uroot -plinux mysql-bin.000011