白及

分享价值,记录点滴!

排序:
默认
按更新时间
按访问量

django Access denied for user 'Administrator'@'localhost'

从书上抄了以下两句执行时报题目所示错误 mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost'; mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';   执行...

2017-03-26 20:23:44

阅读数:458

评论数:0

CentOS安装MySQL时报Curses library not found解决

centos 6.5 64  CMakeErroratcmake/readline.cmake:83(MESSAGE):Curseslibrarynotfound.PleaseinstallappropriatepackageremoveCMakeCache.txtandre...

2016-05-27 19:43:26

阅读数:3958

评论数:0

configure: error: Cannot find libmysqlclient under /usr/local/mysql.

执行下面语句: ./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --with-mysql=/usr/local/mysql  --with-mysqli=/usr/local/mysql...

2016-03-21 16:17:33

阅读数:4218

评论数:1

ERROR: Error in Log_event::read_log_event()

使用mysqlbinlog恢复日志时返回如下报错 [root@localhost log]# mysqlbinlog mysql-bin.000003 mysql-bin.000004 --start-position=1206 > t.sql  ERROR: Error i...

2016-03-19 17:02:18

阅读数:1210

评论数:0

ERROR 1840 (HY000) at line 24: GTID_PURGED can only be set when GTID_EXECUTED is empty.

执行: [root@t1 ~]# mysql -uroot -pjsb  ailanni Warning: Using a password on the command line interface can be insecure. ERROR 1840 (HY000) at line ...

2016-03-19 12:49:55

阅读数:10014

评论数:0

Starting MySQL... ERROR! The server quit without updating PID file (/mydata/data/t1.pid).

测试环境: mysql 5.6.25 (适用5.1.73 5.1.65) 1 vim /etc/my.cnf pid-file=/mypid/t1.pid 今天在备份的时候,我测试把mysql-log.index删除之后报错如下: [root@t1 data]# /etc/init...

2016-03-19 10:12:37

阅读数:2009

评论数:0

cmake编译问题解决

2 安装cmake软件包 yum install cmake 3 create account of mysql groupadd mysql            useradd -g mysql mysql            autoreconf --force --inst...

2016-03-18 16:30:39

阅读数:56090

评论数:3

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (

mysql启动成功 service mysqld start  mysql is OK mysql登录错误 : [root@localhost ~]# mysql -uroot -p123456 ERROR 2002 (HY000): Can't connect to local...

2016-03-18 16:19:41

阅读数:527

评论数:0

centos下加入mysql环境变量

centos下加入mysql环境变量 命令行的时候每次都要进入mysql的目录/usr/local/mysql/bin太麻烦了,为了能在任何一个位置直接进入,设置一下环境变量即可 vi /etc/profile 加入export PATH=$PATH:/usr/l...

2016-03-18 15:56:31

阅读数:4446

评论数:0

innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2672

Warning: Using unique option prefix open_files instead of open_files_limit is deprecated and will be removed in a future release. Please use the full...

2016-03-17 14:51:03

阅读数:838

评论数:0

Error: Failed to connect to MySQL server: DBI connect(';

先看问题: [root@localhost ~]# innobackupex --user=root --password=131417 /backup InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Inno...

2016-03-17 14:48:10

阅读数:3308

评论数:0

warning The transaction log file is corrupted.

Remark Even if appealing using compress option has a constraint when preparing the backup, as clearly stated by Percona: Before you can prepa...

2016-03-16 17:46:24

阅读数:843

评论数:0

Starting MySQL. ERROR! The server quit without updating PID file

前台开启: [root@t1 x]# service mysqld start Starting MySQL. ERROR! The server quit without updating PID file (/mydata/data/t1.pid). 后台告警日志显示: err...

2016-03-16 17:39:37

阅读数:368

评论数:0

The total number of locks exceeds the lock table size错误(已纠正)

Mysql解决The total number of locks exceeds the lock table size错误  在操作mysql数据库表时出现以下错误。 网上google搜索相关问题,发现一位外国牛人这么解释: If you're run...

2016-03-16 09:52:27

阅读数:484

评论数:0

MySQL 5.5升级5.6 单实例操作

MySQL 5.5升级5.6 单实例 同类可参考: 环境:RHEL 6 mysql旧版本:mysql-5.5.28 mysql新版本:mysql-5.6.26 安装方式:源码编译 不习惯用rpm包来安装mysql,所以此处仍然使用...

2016-03-14 18:07:53

阅读数:332

评论数:0

升级mysql_upgrade 提示错误FATAL ERROR: Upgrade failed的原因

升级mysql_upgrade 提示错误FATAL ERROR: Upgrade failed的原因 2014年07月25日 10:33 by:老修--走失的镜头盖分类:网站技术 -> mysql 正文我来说两句 用mysql_upgrade 升级mysql的两种错误: ...

2016-03-14 17:48:02

阅读数:3087

评论数:0

ERROR: Upgrade faifailed bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost'

环境: centos 6.5  mysql 5.5.20 升级 5.6.25 报错: mysql升级报错: mysql.time_zone_transition_type                    OK mysql.user                           ...

2016-03-14 17:37:44

阅读数:1784

评论数:0

Starting MySQL.Manager of pid-file quit without updating file.[FAILED]

刚装完MySQL,启动时报如下错误: Starting MySQL.Manager of pid-file quit without updating file.[FAILED] 依次尝试了从谷姐找到的各种方法,发现只要执行如下MySQL初始化命令即可解决: 1 ...

2016-03-11 14:16:50

阅读数:231

评论数:0

bash: mysql: command not found

root@t2 ~]# mysql -u root -p123456 -bash: mysql: command not found 原因:这是由于系统默认会查找/usr/bin下的命令,如果这个命令不在这个目录下,当然会找不到命令,我们需要做的就是映射一个链接到/usr/bin目录下,相...

2016-03-11 12:31:28

阅读数:250

评论数:0

mysql起动报错The server quit without updating PID file /usr/local/mysql/data/

mysql起动报错The server quit without updating PID file (/usr/local/mysql/data/ 查看错误日志显示: mysqld_safe mysqld from pid file /usr/local/mysql/data/mysql.p...

2016-03-10 20:04:09

阅读数:17836

评论数:0

提示
确定要删除当前文章?
取消 删除
关闭
关闭