Bug 116531
| Summary: | mysql-server 'mysqld' service script fails to correctly start | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Rafael Rivera Jr <vortexreality2050> |
| Component: | mysql | Assignee: | Tom Lane <tgl> |
| Status: | CLOSED DUPLICATE | QA Contact: | |
| Severity: | low | Docs Contact: | |
| Priority: | medium | ||
| Version: | 1 | CC: | hhorak |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | i586 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2006-02-21 19:01:31 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
We have experienced this problem too. I had seen this reported in the past and the fix we used was this... edit /etc/init.d/mysqld locate the two mysqladmin ping commands. change them to mysqladmin -ujoefoo ping Using the bogus user will allow the ping and there is no chance of exposing the root password with this method. Hopefully we'll see a fix as I have no idea of the real quality of this patch. *** This bug has been marked as a duplicate of 108779 *** Changed to 'CLOSED' state since 'RESOLVED' has been deprecated. |
From Bugzilla Helper: User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) Description of problem: The service script uses '/usr/bin/mysqladmin' to 'ping' the mysql server, however when the server is properly password protected, the 'mysqld is alive' string is unable to be returned. Instead, this is returned: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' A quickfix was to include the -p<password> argument on lines 42 & 48, however this poses security issues. Version-Release number of selected component (if applicable): mysql-server-3.23.58-4 How reproducible: Always Steps to Reproduce: 1. service mysqld start 2. Apply password for 'root' user in mysql 3. service mysqld stop 4. service mysqld start (will 'appear' to fail now) 5. Verify mysqld is running anyway (ps -aux|grep mysql) Actual Results: Service script notes that starting of the service was unsuccessful. [FAILED] Expected Results: Service script should note [OK]. Additional info: