mysql删除数据库报错Error dropping database解决方案

不知道大家碰到过没有过在mysql里面删除一个数据库删不掉，在这里给大家一个简单粗暴的方案

首先使用命令

[root@htsp21 ~]# find / -name "my.cnf"
/etc/my.cnf

 找到mysql的配置文件，

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names = 1

找到这个datadir这个目录：这个目录是所建的表，数据库，都会放到这里；

进入到这个目录，ls查看一下

[root@htsp21 mysql]# ls
auto.cnf   ib_buffer_pool  ibdata1  ib_logfile0  ib_logfile1  ibtmp1  mysql  mysql.sock  mysql.sock.lock  performance_schema  sys

发现是我们建的数据库名以及一些其它信息，所以如果我们碰到上述问题的时候，直接rm -rf 数据库名，删掉就OK了