mysql
Jessica0811
这个作者很懒,什么都没留下…
展开
-
python3 使用 mysql, 以及向 mysql 批量插入数据
import MySQLdbdef conn(): db = MySQLdb.connect(host='xxxxxx', user='xxxx', passwd='xxxx', port=3306, charset='utf8') db.select_db('xxxx') cursor = db.cursor() return cursor, dbdef ...原创 2020-03-23 23:01:52 · 566 阅读 · 0 评论 -
安装mysql8 linux
下载地址下载 (https://dev.mysql.com/downloads/repo/yum/)安装步骤安装mysqlmysql80-community-release-el7-3.noarch.rpm rpm -ivh mysql80-community-release-el7-3.noarch.rpm yum updateyum install mysql-server...原创 2020-02-13 00:20:04 · 127 阅读 · 0 评论 -
安装 mysqlclient==1.3.12 报错:OSError: mysql_config not found
安装 mysqlclient==1.3.12 报错:OSError: mysql_config not foundCollecting mysqlclient==1.3.12 Using cached mysqlclient-1.3.12.tar.gz (89 kB) ERROR: Command errored out with exit status 1: comman...原创 2020-02-13 09:08:05 · 1173 阅读 · 0 评论 -
mysql 常用命令
mysql 创建用户CREATE USER '用户名'@'%' IDENTIFIED BY '你的密码';mysql 给用户赋予权限GRANT ALL PRIVILEGES ON *.* TO '用户'@'%' WITH GRANT OPTION;mysql 删除信息delete from 表 where 字段=值;导入用户数据到指定的表mysql -uroot 指定的表 &l...原创 2020-02-13 13:06:42 · 102 阅读 · 0 评论 -
Can't start server: can't create PID file: Permission denied
mysql 启动报错,查看日志显示如下信息2020-02-13T04:23:32.099241Z 0 [ERROR] [MY-010119] [Server] Aborting2020-02-13T04:23:33.228204Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19...原创 2020-02-13 14:26:00 · 3693 阅读 · 2 评论 -
mysql 排错
Navicat 连接 MySQL 错误 2003 - Can’t connect to MySQL server on x.x.x.x (61 “Connection refused”)linux 安装好 mysql 后服务器可以登陆,但客户端连接报错防火墙没有关闭systemctl stop firewalldsystemctl disable firewalldERROR 129...原创 2020-02-13 13:01:31 · 165 阅读 · 0 评论