摘要：项目中已经存在 mysql-connector-java-5.1.7-bin.jar 但是运行还是提示“java.lang.ClassNotFoundException: com.mysql.jdbc.Driver”解决方法：将mysql-connector-java-5.1.7-bin.jar拷贝... 阅读全文

摘要：use mysqlmysql> select host, user from user;将相应用户数据表中的host字段改成'%'；update user set host='%' where user='root';ERROR 1062 (23000): Duplicate entry '%-ro... 阅读全文

摘要：# service mysqld stop# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &# mysql -u root mysqlmysql> UPDATE user SET Password=PASSWORD(... 阅读全文

摘要：mysql中文显示乱码或者问号是因为选用的编码不对或者编码不一致造成的，最简单的方法就是修改mysql的配置文件my.cnf。在[mydqld]和[client]段加入default-character-set=utf8(有的版本不支持default-character-set=utf8，用char... 阅读全文

摘要：找到 /opt/lampp/phpmyadmin/config.inc.php文件修改下面配置这是原配置#$cfg['Servers'][$i]['auth_type'] = 'config';修改为如下$cfg['Servers'][$i]['auth_type'] = 'cookie'; 阅读全文

摘要：错误提示如下：New XAMPP security concept:Access to the requested object is only available from the local network.This setting can be configured in the file "... 阅读全文

摘要：找到\mysql\bin下面的my.ini中mysqld项目后添加innodb_force_recovery = 1 阅读全文

摘要：mysql -u root -pmysql;use mysql;mysql;select 'host' from user where user='root';mysql;update user set host = '%' where user ='root';mysql;flush privil... 阅读全文