mysql
追光天使
这个作者很懒,什么都没留下…
展开
-
eclipse导入项目时报错:Multiple annotations found at this line: - String cannot be resolved to a type解决方法
eclipse导入项目的步骤:步骤一:项目的导入打开eclipse,在Project Explorer空白处,鼠标右键,选择import->import…->General->Existing Projects into Workspace(点击next),select root directory中选择你的项目, 然后点击Finish。项目就导入进来了。步骤二:项目的依赖解决(jsp+servlet+mysql开发的javaweb项目)导入后,很多jsp上有❌有报错!打开jsp原创 2021-08-08 21:31:38 · 5012 阅读 · 1 评论 -
Java项目远程连接报错“useUnicode=true&characterEncoding=UTF-8&verifyServerCertificate=false&useSSL=false”
java控制台报错:com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2cc03c1 – Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acq原创 2021-08-08 20:53:56 · 1177 阅读 · 0 评论 -
ubuntu MYSQL 配置文件位置
ubuntu 16.10 MYSQL配置文件位置:/etc/mysql/mysql.conf.d/mysqld.cnfubuntu 14.04 MYSQL配置文件位置:/etc/mysql/my.cnf原创 2021-08-08 19:37:56 · 2402 阅读 · 0 评论 -
多次连接mysql失败被锁,“Host ‘xx‘ is blocked because of many connection errors; unblock with ‘mysqladmin ...“
Host “xxx.xxx.xx.xx” is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’"?当连接错误次数过多时,mysql会禁止客户机连接,这个时候有两个办法解决:1.使用mysqladmin flush-hosts命令清除缓存,命令执行方法如下:命令行或终端:mysqladmin -u root -p flush-hosts接着输入root账号密码即可2.修改mysq原创 2021-08-08 19:24:17 · 1219 阅读 · 0 评论 -
在Ubuntu Desktop上安装mysqlworkbench,遇到“ Could not get lock /var/lib/dpkg/lock-frontend - open”的问题及解决方案?
先决条件在继续本教程之前,请确保以具有 sudo 权限的用户身份登录。在 Ubuntu 上安装 MySQL Workbench在 Ubuntu 上安装 MySQL Workbench 是一个非常简单的过程。更新软件包索引并安装 MySQL Workbench 软件包:sudo apt updatesudo apt install mysql-workbench...原创 2021-08-08 10:06:49 · 133 阅读 · 0 评论 -
本地远程连接Ubuntu16.04下安装mysql和mysqlworkbench
1.首先安装mysql-server和mysql-client,libmysqlclient-dev;sudo apt-get install mysql-serversudo apt install mysql-clientsudo apt install libmysqlclient-dev2.测试是否安装成功sudo netstat -tap | grep mysql3.进入mysql服务:mysql -uroot -p密码可以进入说明mysql服务启动了mysql>exit;原创 2021-08-07 10:46:15 · 147 阅读 · 0 评论 -
Failed:Incorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89‘ for column ‘name‘ at row 1
mysql> insert into student(uid,uname,uhobby) values(1,‘张三’,‘足球’);**ERROR 1366 (HY000): Incorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89’ for column ‘name’ at row 1**解决办法:**在创建数据表时,设置引擎为InnoDB,设置字符集为utf-8,核对为utf8_general_ci。参考链接:https://blog.csdn.n原创 2021-07-17 12:57:42 · 370 阅读 · 0 评论 -
Ubuntu16.04.7上安装MySQL教程详解
一、安装MySQL1、使用以下命令即可进行mysql安装,注意安装前先更新一下软件源以获得最新版本:$ sudo apt-get update #更新软件源$ sudo apt-get install mysql-server #安装mysql上述命令会安装以下包:apparmormysql-client-5.7mysql-commonmysql-servermysql-server-5.7mysql-server-core-5.7因此无需再安装mysql-client等。安装过程转载 2021-04-17 13:05:32 · 239 阅读 · 0 评论