clvn的博客_MySQL

解决Mysql "is marked as crashed and should be repaired"的故障

在查看数据库的出错日志时，看到以下错误信息151103 8:43:33 [ERROR] /alidata/server/mysql/libexec/mysqld: Table './mould_2012/web_members' is marked as crashed and should be repaired151103 8:43:33 [Warning] Check

MySQL

原创 2015-11-03 09:00:26 1307 阅读

MySQL报'Access denied for user 'root'@'localhost' (using password: NO)'错误的解决

当在命令提示符下执行该命令时，报下列错误[root@clvn]# mysqladmin -u root password "sorry"mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using password: NO)'解决办法：[root

报错

MariaDB

原创 2015-05-21 21:26:46 10000+阅读 1点赞 2评论

MySQL字符集的设置

查看MySQL数据库当前设置的字符集mysql> SHOW VARIABLES LIKE 'character%';+--------------------------+----------------------------+| Variable_name

MySQL

字符集

设置字符集

原创 2015-03-13 19:48:35 1188 阅读

mysql客户端登录时报mysql: relocation error错误

在安装了xtrabackup后，再用下列命令登录时报下列错误[root@localhost ~]# mysql -u root -pmysql: relocation error: mysql: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time refer

mysql

libmysqlclient_16

客户端登录报错

原创 2015-03-13 13:15:32 10000+阅读 1点赞 1收藏

在搭建mysql-mmm环境时报错

在monitor启动后执行mmm_contorl show时显示下列信息ERROR: Can't connect to monitor daemon!解决思路：修改配置文件将debug=0改为debug=1然后重新启动mysql-mmm-monitorDEBUG mysql(db2) = 'ERROR: Connect error (host = 10.10.1.100:3306, user =

mysql-mmm

原创 2014-12-08 08:58:40 1218 阅读

启动amoeba时报错解决方法

在启动amoeba时报下列错误[root@amoeba-x86v-app01 ~]# /usr/local/amoeba-mysql-3.0.5-RC/bin/launcherJava HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=16m; support was removed in 8.0Java HotSpot(

amoeba

原创 2014-10-29 14:27:52 6260 阅读

MySQL启动时报Plugin 'InnoDB' registration as a STORAGE ENGINE failed.错误

当更改了MySQL参数后，重新启动MySQL数据库，查看日志发现以下错误信息141029 2:23:37 [ERROR] Plugin 'InnoDB' init function returned error.141029 2:23:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.解决办

MySQL

原创 2014-10-28 18:41:18 10000+阅读

MySQL登录时报ERROR 1045 (28000): Access denied for user 的解决方法

在进行mysql登录时报下列错误[root@mdb1 ~]# mysql -u mmm_agent -h 10.10.1.33 -pEnter password: ERROR 1045 (28000): Access denied for user 'mmm_agent'@'mdb1.clvn.com.cn' (using password: YES)用root用户登录mysql，查看usre表信

MySQL

登陆时报

原创 2014-09-18 21:41:37 1624 阅读

解决mysql在ubuntu安装出错

root@VM-83-49-ubuntu:~# apt-get install mysql-serverReading package lists... DoneBuilding dependency treeReading state information... DoneThe following packages were automatically installed and are no

mysql

ubuntu

原创 2014-08-18 16:00:04 10000+阅读

Mysql数据库常用操作

1.备份数据库[root@bj-db-x86v-app01 ~]# mysqldump -h 192.168.0.8 -uroot -p'123456' user >user.sql2.查看mysql数据库字符集设置mysql> show variables like 'character_set_%';+--------------------------+-

mysql

数据库

操作

原创 2014-06-24 18:58:10 889 阅读

Mysql数据库出现many connection errors错误的解决

在上班的时间发现opensips服务器连接上不去了，查看错误日志时报下列错误Jun 24 10:23:26 bj-opensips-x86v-app01 /sbin/opensips[7115]: ERROR:db_mysql:db_mysql_connect: driver error(1129): Host 'bj-opensips-x86v-app01.clvn.com.cn'

mysql

数据库

报错

原创 2014-06-24 10:40:09 2547 阅读

mysql报ERROR 2003错误的解决

在创建opensips数据库时，mysql报下列错误root@opensips.clvn.com.cn:/usr/local/opensips/sbin# ./opensipsdbctl createMySQL password for root: INFO: test server charsetERROR 2003 (HY000): Can't connect to MySQL server

报错

ERROR 2003

原创 2014-06-11 11:23:20 5699 阅读

当执行mysqladmin时报'Host' is not allowed to connect to this MySQL server'的解决

当执行mysqladmin时报下列错误解决方法：

mysql

报时

原创精选 2014-06-11 08:23:09 2022 阅读

MySQL忘记root密码后的处理

在用root用户登录mysql时发现密码错了[root@gk ~]# mysql -u root -pEnter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)解决方法1.停止mysqld服务[root@gk ~]# service mysqld stop停止

MySQL

root

原创 2014-06-07 22:30:25 923 阅读

在Mysql下查看给某个用户授予什么样的权限

mysql> show grants for zabbix@192.168.0.8;+-----------------------------------------------------------------------------+| Grants for zabbix@192.168.0.8 &nb

mysql

原创 2014-05-24 13:10:50 1494 阅读

解决MySQL远程登录时出现ERROR 1130错误问题

在用mysql进行远程连接时出现下列错误[root@openfire ~]# mysql -u root -h mysql.clvn.com.cn -pEnter password: ERROR 1130 (HY000): Host '192.168.0.15'&nbs

ERROR

1130

原创 2014-05-13 10:10:08 1091 阅读

解决MySQL初始化时发生Could not find ./bin/my_print_defaults的错误

在执行初始化Mysql数据库时出现下列错误[root@mysqld1 scripts]# ./mysql_install_db --user=mysql --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld

Could not find ./bin

原创 2014-05-10 06:31:58 10000+阅读

Mysql中ERROR 2002 (HY000)错误的解决

在登录Mysql时出现下列错误[root@mysqld1 bin]# ./mysql -u root -pEnter password: ERROR 2002 (HY000): Can't connect to local MySQL server&

ERROR 2002 (HY000)

原创 2014-05-09 23:56:48 2795 阅读

解决mysql启动时报The server quit without updating PID file 的错误

在启动mysql时报下列错误[root@mysqld2 ~]# service mysql.server startStarting MySQL......................................The server quit without updating PID&nbs

mysql

The server quit with

原创 2014-05-09 22:15:26 10000+阅读

配置Mysql Cluster时出错Unable to connect with connect string: nodeid=0,localhost:1186问题的解决

在执行 /etc/init.d/ndbd --initial出现下列错误[root@ndbd1 ~]# /etc/init.d/ndbd --initialUnable to connect with connect string: nodeid=0,localhost:1186Retry

mysql cluster

Unable to connect wi

localhost:1186

原创 2014-05-09 21:54:11 6360 阅读

官方博客	全部文章	热门标签	班级博客
了解我们	网站地图	意见反馈

鸿蒙开发者社区	51CTO学堂
51CTO	软考资讯

51CTO博客

云人生

解决Mysql "is marked as crashed and should be repaired"的故障

MySQL报'Access denied for user 'root'@'localhost' (using password: NO)'错误的解决

MySQL字符集的设置

mysql客户端登录时报mysql: relocation error错误

在搭建mysql-mmm环境时报错

启动amoeba时报错解决方法

MySQL启动时报Plugin 'InnoDB' registration as a STORAGE ENGINE failed.错误

MySQL登录时报ERROR 1045 (28000): Access denied for user 的解决方法

解决mysql在ubuntu安装出错

Mysql数据库常用操作

Mysql数据库出现many connection errors错误的解决

mysql报ERROR 2003错误的解决

当执行mysqladmin时报'Host' is not allowed to connect to this MySQL server'的解决

MySQL忘记root密码后的处理

在Mysql下查看给某个用户授予什么样的权限

解决MySQL远程登录时出现ERROR 1130错误问题

解决MySQL初始化时发生Could not find ./bin/my_print_defaults的错误

Mysql中ERROR 2002 (HY000)错误的解决

解决mysql启动时报The server quit without updating PID file 的错误

配置Mysql Cluster时出错Unable to connect with connect string: nodeid=0,localhost:1186问题的解决