Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FAIL Execute SQL / return code: 256 #476

Closed
emololftw opened this issue Jan 31, 2020 · 2 comments
Closed

FAIL Execute SQL / return code: 256 #476

emololftw opened this issue Jan 31, 2020 · 2 comments

Comments

@emololftw
Copy link

emololftw commented Jan 31, 2020

Hi!

i got 256 error when im trying run perl code. In first, im trying connect with root and not success. So im created user without password. Now when im trying to connect i got this one:


C:\xampp\mysql\bin>perl mysqltuner.pl --mysqladmin "mysqladmin.exe" --mysqlcmd "mysql.exe" --user klima --host 127.0.0.1
[--] * Windows OS(Win10) is not fully supported.

 >>  MySQLTuner 1.7.19 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[--] Performing tests on 127.0.0.1:3306
[OK] Logged in using credentials passed on the command line
'uname' is not recognized as an internal or external command,
operable program or batch file.
Use of uninitialized value $physical_memory in concatenation (.) or string at
        mysqltuner.pl line 488 (#1)
    (W uninitialized) An undefined value was used as if it were already
    defined.  It was interpreted as a "" or a 0, but maybe it was a mistake.
    To suppress this warning assign a defined value to your variables.

    To help you figure out what was undefined, perl will try to tell you
    the name of the variable (if any) that was undefined.  In some cases
    it cannot do this, so it also tells you what operation you used the
    undefined value in.  Note, however, that perl optimizes your program
    and the operation displayed in the warning may not necessarily appear
    literally in your program.  For example, "that $foo" is usually
    optimized into "that " . $foo, and the warning will refer to the
    concatenation (.) operator, even though there is no . in
    your program.

Use of uninitialized value $swap_memory in concatenation (.) or string at
        mysqltuner.pl line 489 (#1)
Use of uninitialized value $physical_memory in scalar chomp at mysqltuner.pl
        line 490 (#1)
Use of uninitialized value $swap_memory in scalar chomp at mysqltuner.pl line
        491 (#1)
The system cannot find the path specified.
[!!] failed to execute: SELECT VERSION()
[!!] FAIL Execute SQL / return code: 256
[!!] You probably did not get enough privileges for running MySQLTuner ..

My sql server is alive.
Server type: 10.1.40-MariaDB
OS: Windows Server 2016.
Privileges for klima: full

Im trying to find some solutions here and not working at all :/
Thanks for your time.

Edit:

my.ini

[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock
@Neurozone
Copy link

As said in the documentation:

*** UNSUPPORTED ENVIRONMENTS - NEED HELP FOR THAT :) ***

Windows is not supported at this time (Help wanted !!!!!)

@emololftw
Copy link
Author

As said in the documentation:

*** UNSUPPORTED ENVIRONMENTS - NEED HELP FOR THAT :) ***

Windows is not supported at this time (Help wanted !!!!!)

I wasnt sure about that, because CMD says:

[--] * Windows OS(Win10) is not fully supported.

Now i know its not supported.
Sorry for your time. Have a nice day.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants