mysql数据库无法连接请教各位大侠如何解决
求教各位大侠![1045] Access denied for user 'root'@'localhost' (using password: YES) 1028:20101123:223510.228 Starting Zabbix Server. Zabbix 1.8.3 (revision 13928) .
1028:20101123:223510.228 **** Enabled features ****
1028:20101123:223510.228 SNMP monitoring: YES
1028:20101123:223510.228 IPMI monitoring: NO
YES 1028:20101123:223510.228 WEB monitoring:
1028:20101123:223510.228 Jabber notifications: YES
1028:20101123:223510.228 ODBC: NO
1028:20101123:223510.228 SSH2 support: NO
1028:20101123:223510.228 IPv6 support: NO
1028:20101123:223510.228 ************************** 1028:20101123:223510.240 [Z3001] Connection to database 'zabbix' failed: [1045 ] Access denied for user 'root'@'localhost' (using password: YES) 数据库如下:
shell#mysql -uroot -p
password:
mysql>user mysql;
mysql> select host,user,password from user;
+-----------+--------+-------------------------------------------+ | host | user | password |
+-----------+--------+-------------------------------------------+ | localhost | root | *F00B78436E89EDBE88F52F781EFDA84C2C8782E4 | | east.com | root | *F00B78436E89EDBE88F52F781EFDA84C2C8782E4 | | 127.0.0.1 | root | *F00B78436E89EDBE88F52F781EFDA84C2C8782E4 | | localhost | | |
| east.com | | |
| localhost | zabbix | *F00B78436E89EDBE88F52F781EFDA84C2C8782E4 | | loaclhost | root | *F00B78436E89EDBE88F52F781EFDA84C2C8782E4 | +-----------+--------+-------------------------------------------+ 7 rows in set (0.00 sec)
mysql> use zabbix
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_zabbix |
+-----------------------+
| acknowledges |
| actions |
| alerts |
| applications |
| auditlog |
| auditlog_details |
| autoreg_host |
| conditions |
| config |
| dchecks | | dhosts | | drules | | dservices | | escalations | | events | | expressions |
| functions | | globalmacro | | graph_theme | | graphs | | graphs_items | | groups | | help_items | | history | | history_log | | history_str | | history_str_sync | | history_sync | | history_text | | history_uint | | history_uint_sync | | hostmacro | | hosts | | hosts_groups | | hosts_profiles | | hosts_profiles_ext | | hosts_templates | | housekeeper | | httpstep | | httpstepitem | | httptest | | httptestitem | | ids | | images | | items | | items_applications | | maintenances | | maintenances_groups | | maintenances_hosts | | maintenances_windows | | mappings | | media | | media_type | | node_cksum | | nodes |
| opconditions | | operations | | opmediatypes | | profiles | | proxy_autoreg_host | | proxy_dhistory |
| proxy_history | | regexps | | rights | | screens |
| screens_items | | scripts | | service_alarms | | services | | services_links | | services_times | | sessions | | slides | | slideshows | | sysmaps | | sysmaps_elements | | sysmaps_link_triggers | | sysmaps_links | | timeperiods | | trends | | trends_uint | | trigger_depends | | triggers | | user_history | | users |
| users_groups | | usrgrp | | valuemaps | +-----------------------+ 88 rows in set (0.13 sec)
mysql> select userid,name,surname,passwd from users;
+--------+---------+---------------+----------------------------------+
| userid | name | surname | passwd |
+--------+---------+---------------+----------------------------------+
| 1 | Zabbix | Administrator | 5fce1b3e34b520afeffb37ce08c7cd66 |
| 2 | Default | User | d41d8cd98f00b204e9800998ecf8427e |
+--------+---------+---------------+----------------------------------+
2 rows in set (0.00 sec)
本文档为【mysql数据库无法连接请教各位大侠如何解决】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑,
图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。