AMH开源社区

AMH社区 - 开放自由有价值的社区

[分享帖] [Amysql-Notice] Access denied for user 'root'@'localhost' (using password: Y...

lll124
铁牌会员
63.00 价值分

7,850 次阅读   17 张回复   lll124 发表于 2014-02-23 01:05:35
错误信息:
[Amysql-Notice] Access denied for user 'root'@'localhost' (using password: YES) Mysql链接出错,请配置/Amysql/config.php文件。#

AY140222231316611522Z.err
错误信息如下:
140223 00:00:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140223 0:00:29 [Note] Plugin 'InnoDB' is disabled.
140223 0:00:29 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140223 0:00:29 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140223 0:00:29 [Note] Server socket created on IP: '0.0.0.0'.
140223 0:00:29 [Note] Event Scheduler: Loaded 0 events
140223 0:00:29 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution

Status information:

Current dir: /usr/local/mysql/data/
Running threads: 0 Stack size: 262144
Current locks:
lock: 0x1e1dc60:

lock: 0x1de63b0:

lock: 0x1ddb790:

lock: 0x1dcf320:

lock: 0x1dbe0f0:

lock: 0x1db7f10:

lock: 0x1db2ad0:

lock: 0x1dac590:

lock: 0x1da3f60:

lock: 0xf4d500:

lock: 0xf4da40:

lock: 0xf4db00:

lock: 0xf4dbc0:

lock: 0xf4d5c0:

lock: 0xf4d680:

lock: 0xf4d440:

lock: 0xf4d2c0:

lock: 0xf4d380:

lock: 0xf4dc80:

lock: 0xf4d740:

lock: 0xf4d980:

lock: 0xf4d8c0:

lock: 0xf4d800:

lock: 0xf4d080:

lock: 0xf4d140:

lock: 0xf4d200:


Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 4
not flushed: 0
w_requests: 21
writes: 4
r_requests: 13
reads: 4


handler status:
read_key: 2
read_next: 0
read_rnd 0
read_first: 5
write: 1
delete 7
update: 1

Table status:
Opened tables: 33
Open tables: 26
Open files: 20
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 897024
Number of free chunks: 28
Number of fastbin blocks: 0
Number of mmapped regions: 3
Space in mmapped regions: 17833984
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 727616
Total free space: 169408
Top-most, releasable space: 121536
Estimated memory (with thread stack): 18731008



Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked

Event scheduler status:
State : INITIALIZED
Thread id : 0
LLA : n/a:0
LUA : n/a:0
WOC : NO
Workers : 0
Executed : 0
Data locked: NO

Event queue status:
Element count : 0
Data locked : NO
Attempting lock : NO
LLA : init_queue:139
LUA : init_queue:149
WOC : NO
Next activation : never

Status information:

Current dir: /usr/local/mysql/data/
Running threads: 0 Stack size: 262144
Current locks:
lock: 0xf4d500:

lock: 0xf4da40:

lock: 0xf4db00:

lock: 0xf4dbc0:

lock: 0xf4d5c0:

lock: 0xf4d680:

lock: 0xf4d440:

lock: 0xf4d2c0:

lock: 0xf4d380:

lock: 0xf4dc80:

lock: 0xf4d740:

lock: 0xf4d980:

lock: 0xf4d8c0:

lock: 0xf4d800:

lock: 0xf4d080:

lock: 0xf4d140:

lock: 0xf4d200:


Key caches:
default
Buffer_size: 16777216
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 4
not flushed: 0
w_requests: 21
writes: 4
r_requests: 13
reads: 4


handler status:
read_key: 2
read_next: 0
read_rnd 0
read_first: 7
write: 1
delete 7
update: 1

Table status:
Opened tables: 33
Open tables: 0
Open files: 2
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 0
Next alarm time: 0

Memory status:
Non-mmapped space allocated from system: 897024
Number of free chunks: 41
Number of fastbin blocks: 0
Number of mmapped regions: 3
Space in mmapped regions: 17833984
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 275264
Total free space: 621760
Top-most, releasable space: 163904
Estimated memory (with thread stack): 18731008



Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked

Event scheduler status:
State : INITIALIZED
Thread id : 0
LLA : n/a:0
LUA : n/a:0
WOC : NO
Workers : 0
Executed : 0
Data locked: NO

Event queue status:
Element count : 0
Data locked : NO
Attempting lock : NO
LLA : init_queue:139
LUA : init_queue:149
WOC : NO
Next activation : never
140223 0:17:20 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

140223 0:17:20 [Note] Event Scheduler: Purging the queue. 0 events
140223 0:17:20 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

140223 00:17:20 mysqld_safe mysqld from pid file /usr/local/mysql/data/AY140222231316611522Z.pid ended
140223 00:17:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140223 0:17:23 [Note] Plugin 'InnoDB' is disabled.
140223 0:17:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140223 0:17:24 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140223 0:17:24 [Note] Server socket created on IP: '0.0.0.0'.
140223 0:17:24 [Note] Event Scheduler: Loaded 0 events
140223 0:17:24 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
140223 0:25:59 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

140223 0:25:59 [Note] Event Scheduler: Purging the queue. 0 events
140223 0:25:59 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

140223 00:25:59 mysqld_safe mysqld from pid file /usr/local/mysql/data/AY140222231316611522Z.pid ended
140223 00:26:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140223 0:26:01 [Note] Plugin 'InnoDB' is disabled.
140223 0:26:01 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140223 0:26:01 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140223 0:26:01 [Note] Server socket created on IP: '0.0.0.0'.
140223 0:26:01 [Note] Event Scheduler: Loaded 0 events
140223 0:26:01 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
140223 00:26:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140223 0:26:33 [Note] Plugin 'InnoDB' is disabled.
140223 0:26:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140223 0:26:33 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140223 0:26:33 [Note] Server socket created on IP: '0.0.0.0'.
140223 0:26:33 [Note] Event Scheduler: Loaded 0 events
140223 0:26:33 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
140223 0:34:03 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

140223 0:34:03 [Note] Event Scheduler: Purging the queue. 0 events
140223 0:34:03 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

140223 00:34:03 mysqld_safe mysqld from pid file /usr/local/mysql/data/AY140222231316611522Z.pid ended
140223 00:34:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140223 0:34:04 [Note] Plugin 'InnoDB' is disabled.
140223 0:34:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140223 0:34:04 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140223 0:34:04 [Note] Server socket created on IP: '0.0.0.0'.
140223 0:34:04 [Note] Event Scheduler: Loaded 0 events
140223 0:34:04 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution

评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
2014-02-23 01:05:35 1

Captain
金牌会员
6928.40 价值分

自己修改了root密码吗?需要到/Amysql/config.php这个文件按新密码更新一下
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-23 01:39:54 2

lll124
铁牌会员
63.00 价值分

没有修改密码
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-23 10:20:33 3

lll124
铁牌会员
63.00 价值分

重新 卸载 重新安装 就好了
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-23 11:31:54 4

Captain
金牌会员
6928.40 价值分

引用:
lll124 发表于 2014-2-23 11:31
重新 卸载 重新安装 就好了


那可能是mysql出错了
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-02-24 00:45:36 5

7jdg
铁牌会员
12.00 价值分

不要用localhost用127.0.0.1试试
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-03-03 00:51:52 6

dreamkite
铜牌会员
766.00 价值分

遇到相同问题 支持
解决方法:
卸载 重新安装 然后然后就好了
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-03-10 17:18:32 7

8966092
铁牌会员
21.00 价值分

不用重装的,直接输入:/etc/init.d/amh-start 应该就可以了
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2014-03-21 13:23:17 8

zwh99
铁牌会员
188.00 价值分

引用:
Captain 发表于 2014-2-23 01:39
自己修改了root密码吗?需要到/Amysql/config.php这个文件按新密码更新一下


/Amysql/config.php 这个路径我找不到,我是自己修改的密码
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2015-01-13 23:12:00 9

72135
金牌会员
5474.03 价值分

引用:
zwh99 发表于 2015-1-13 23:12
/Amysql/config.php 这个路径我找不到,我是自己修改的密码


/usr/local/amh-5.0/web/Amysql/
我是雷锋
评价: 这篇分享有价值吗?  没有 (0分)   有, 感谢 (0分)
回复  2015-01-13 23:15:41 10
 1 2 >  (总2页)
AMH社区列表
旅客不可参与帖子, 请您先登录
用户服务中心