HTTPS
AMH 社区首页
AMH社区 - 开放自由有价值的社区
|
|
|---|---|
|
lll124 |
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分)
2014-02-23 01:05:35 1
|
|
Captain |
自己修改了root密码吗？需要到/Amysql/config.php这个文件按新密码更新一下
回复
2014-02-23 01:39:54 2
|
|
lll124 |
没有修改密码
回复
2014-02-23 10:20:33 3
|
|
lll124 |
重新 卸载 重新安装 就好了
回复
2014-02-23 11:31:54 4
|
|
Captain |
引用: lll124 发表于 2014-2-23 11:31  重新 卸载 重新安装 就好了 那可能是mysql出错了
回复
2014-02-24 00:45:36 5
|
|
7jdg |
不要用localhost用127.0.0.1试试
回复
2014-03-03 00:51:52 6
|
|
dreamkite |
遇到相同问题 支持
解决方法： 卸载 重新安装 然后然后就好了
回复
2014-03-10 17:18:32 7
|
|
8966092 |
不用重装的，直接输入：/etc/init.d/amh-start 应该就可以了
回复
2014-03-21 13:23:17 8
|
|
zwh99 |
引用: Captain 发表于 2014-2-23 01:39 自己修改了root密码吗？需要到/Amysql/config.php这个文件按新密码更新一下 /Amysql/config.php 这个路径我找不到，我是自己修改的密码
回复
2015-01-13 23:12:00 9
|
|
72135 |
引用: zwh99 发表于 2015-1-13 23:12 /Amysql/config.php 这个路径我找不到，我是自己修改的密码 /usr/local/amh-5.0/web/Amysql/ 我是雷锋
回复
2015-01-13 23:15:41 10
|
[综合话题]
[Amysql-Notice] Access denied for user 'root'@'localhost' (using password: Y...
