Mysql 问题

【mysql table 'lpa.table' doesn`t exist ”,】
------------------------------------------

删除 mysql文件夹下  
/usr/local/mysql/data/mysql/ibdata1  和 /usr/local/mysql/data/mysql/lpa 下的xxx.frm文件  

设置Mysql大小写不区分
用ROOT登录，修改/etc/my.cnf
在[mysqld]下加入一行：lower_case_table_names=1.


java.sql.SQLException: null, message from server: "Host '192.168.1.10' is not allowed to connect to this MySQL server"
------------------------------------------------------------------------

2. 授权法。例如，你想myuser使用mypassword从任何主机连接到mysql服务器的话。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;