Troubleshooting of MySQLTuner: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
|||
| Line 13: | Line 13: | ||
Solution: | Solution: | ||
# Download the installation file of Cygwin from [https://cygwin.com/install.html Cygwin Installation] | # Download the installation file {{kbd | key=<nowiki>setup-x86_64.exe</nowiki>}} of Cygwin from [https://cygwin.com/install.html Cygwin Installation] | ||
# Open the console window | # Open the console window | ||
# To install the packages: perl_manpages, perl_pods<ref>[https://stackoverflow.com/questions/36393757/how-do-i-use-diagnostics-for-perl-on-cygwin cpan - How do I 'use diagnostics' for Perl on Cygwin? - Stack Overflow]</ref>. Keyin {{kbd | key=<nowiki>setup-x86_64.exe -q -P "perl_manpages,perl_pods"</nowiki>}} | # To install the packages: perl_manpages, perl_pods<ref>[https://stackoverflow.com/questions/36393757/how-do-i-use-diagnostics-for-perl-on-cygwin cpan - How do I 'use diagnostics' for Perl on Cygwin? - Stack Overflow]</ref>. Keyin {{kbd | key=<nowiki>setup-x86_64.exe -q -P "perl_manpages,perl_pods"</nowiki>}} | ||
| Line 20: | Line 20: | ||
* Windows 2008 R2 standard | * Windows 2008 R2 standard | ||
* CYGWIN_NT-6.1 Win2008R2-0-0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin (information returned from {{kbd | key=<nowiki>uname -a</nowiki>}}) | * CYGWIN_NT-6.1 Win2008R2-0-0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin (information returned from {{kbd | key=<nowiki>uname -a</nowiki>}}) | ||
== How to resolve: Attempted to use login credentials, but they were invalid. == | == How to resolve: Attempted to use login credentials, but they were invalid. == | ||
Revision as of 11:51, 27 January 2018
"MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability."[1]
How to resolve: couldn't find diagnostic data
Condition:
$ perl mysqltuner.pl couldn't find diagnostic data in /usr/share/perl5/5.26/pods/perldiag.pod /usr/local/lib/perl5/site_perl/5.26/x86_64-cygwin-threads /usr/local/share/perl5/site_perl/5.26 /usr/lib/perl5/vendor_perl/5.26/x86_64-cygwin-threads /usr/share/perl5/vendor_perl/5.26 /usr/lib/perl5/5.26/x86_64-cygwin-threads /usr/share/perl5/5.26 mysqltuner.pl at /usr/share/perl5/5.26/diagnostics.pm line 259, <POD_DIAG> line 711. Compilation failed in require at mysqltuner.pl line 45. BEGIN failed--compilation aborted at mysqltuner.pl line 45.
Solution:
- Download the installation file setup-x86_64.exe of Cygwin from Cygwin Installation
- Open the console window
- To install the packages: perl_manpages, perl_pods[2]. Keyin setup-x86_64.exe -q -P "perl_manpages,perl_pods"
Environment:
- Windows 2008 R2 standard
- CYGWIN_NT-6.1 Win2008R2-0-0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin (information returned from uname -a)
How to resolve: Attempted to use login credentials, but they were invalid.
Condition:
$ perl mysqltuner.pl >> MySQLTuner 1.7.5 - Major Hayden <[email protected]> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: [!!] Attempted to use login credentials, but they were invalid.
Solution:
- Specify the host parameter to command line e.g. perl mysqltuner.pl --host 127.0.0.1
- Check the typo of mysql account and password
references
Troubleshooting of ...
- PHP, cUrl, Python, selenium, HTTP status code errors
- Database: SQL syntax debug, MySQL errors, MySQLTuner errors or PostgreSQL errors
- HTML/Javascript: Troubleshooting of javascript, XPath
- Software: Mediawiki, Docker, FTP problems, online conference software
- Test connectivity for the web service, Web Ping, Network problem, Web user behavior, Web scrape troubleshooting
Template