Error 1045 Zabbix
Contents |
HCL Search Reviews Search ISOs Go to Page... LinuxQuestions.org > Forums > Linux Forums > Linux - Server Mysql --- Access denied for error 1045 (28000): access denied for user @'localhost' (using password: no user 'test'@'localhost' User Name Remember Me? Password Linux - Server This forum
Access Denied For User ''@'localhost' (using Password Yes)
is for the discussion of Linux Software used in a server related context. Notices Welcome to LinuxQuestions.org, a friendly mysql list users and active Linux Community. You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced mysql add user search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today! Note that registered members see fewer ads, and ContentLink is completely disabled once you log in. Are you new to LinuxQuestions.org? Visit the following links: Site Howto | Site FAQ | Sitemap | Register Now If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here. Having a problem logging in? Please visit this page to clear all LQ-related cookies. Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own. Click Here to receive this Complete Guide absolutely free. Page 1 of 2 1 2 > Search this Thread 07-31-2008, 10:35 AM #1 permalac Member Registered: Jul 2007 Location: Barcelona Posts
to Milestone Percona Monitoring Plugins Edit Fix Released Medium Unassigned Edit Percona Monitoring Plugins 1.1.4 You need to log in to change this bug's status. Affecting: Percona Monitoring Plugins Filed here by: Pavel A. When: 2014-04-21 Confirmed: 2014-07-11 Started work: 2014-07-11 Completed: 2014-07-21 Target Distribution Baltix BOSS Juju Charms Collection Elbuntu Guadalinex Guadalinex Edu Kiwi Linux nUbuntu PLD Linux Tilix tuXlab Ubuntu Ubuntu Linaro Evaluation Build Ubuntu RTM Package (Find…) Project (Find…) Status http://www.linuxquestions.org/questions/linux-server-73/mysql-access-denied-for-user-'test'@'localhost'-659526/ Importance Milestone Fix Released Medium Percona Monitoring Plugins 1.1.4 Assigned to Nobody Me Comment on this change (optional) Email me about changes to this bug report Also affects project (?) Also affects distribution/package Nominate for series Bug Description I've just noticed running slave check fails for me(debian wheezy, percona 5.5, zabbix 2.2.3 from repos). zabbix_agentd.log https://bugs.launchpad.net/bugs/1310723 reports: ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO). That's inspite there are all checks like ok. Quick digging into revealed that it fails at running slave check: if [ "$ITEM" = "running-slave" ]; then # Check for running slave RES=`mysql -e 'SHOW SLAVE STATUS\G' | egrep '(Slave_IO_Running|Slave_SQL_Running):' | awk -F: '{print $2}' | tr '\n' ','` I would proposed to fix like ITEM=$1 HOST=localhost + HOME=/var/lib/zabbix DIR=`dirname $0` RES=`${HOME} mysql -e 'SHOW SLAVE STATUS\G' | egrep '(Slave_IO_Running|Slave_SQL_Running):' | awk -F: '{print $2}' | tr '\n' ','` That works here. Tags: zabbix Edit Tag help Roman Vynar (roman-vynar) wrote on 2014-07-10: #1 On Debian/Ubuntu, zabbix home dir is /var/run/zabbix instead of /var/lib/zabbix like it is on Redhat/Centos. The documentation http://www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html#installation-instructions was corrected at some point of time in the past, to create ~zabbix/.my.cnf instead of previous /var/lib/zabbix/.my.cnf. So if you place your .my.cnf under ~zabbix/ no matter what's the actual dir is, it should work. Changed in pe
communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow http://askubuntu.com/questions/448404/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y the company Business Learn more about hiring developers or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ERROR 1045 (28000): Access denied for error 1045 user 'root'@'localhost' (using password: YES) up vote 1 down vote favorite 3 I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode. Now that therapeutic explanation is done, I have installed MySql Server and MariaDb 10 from the Ubuntu repositories on Ubuntu 12.04 LTS and access denied for input the root password when it is installing[When the pink screen appears and prompts for the root password] and the installation goes through as smoothly as a knife through butter. Now the real frustration begins in either of the below 2 scenarios: When I enter the sudo /usr/bin/mysql_secure_installation command nd am prompted to enter the root password or 2.When I enter the mysql -u root -p command and am prompted for the password. Please I really need help on this - I have lost count of the number of times I have had to uninstall and reinstall either MySQL or MariaDb because this pain in neck erf an error. server permissions password mysql root share|improve this question asked Apr 16 '14 at 6:39 chetwynd2014 26115 Hi Jobin, I have tried the first command:mysqladmin -u root -pcurrentpassword password 'newpassword' but the system just hangs.Is there a limit to the number of characters we can use as a password coz mine is over 100 characters long.I didnt have any issues when setting the password so I dont see why that should be an issue now.Thanks. –chetwynd2014 Apr 16 '14 at 7:48 I think I may have figured out the issue - It has to do with the long password.I think that this should reported as a bug to M