| Posted by yuriko, 09-12-2011, 01:50 PM | | Hello experts,
I need some help please. For some reason I'm unable to run mysqltuner. This is the error I'm receiving,
ERROR 1142 (42000) at line 1: SELECT command denied to user 'root'@'localhost' for table 'user'
[OK] All database users have passwords assigned
Illegal division by zero at ./mysqltuner.pl line 594, <> line 2 (#1)
(F) You tried to divide a number by 0. Either something was wrong in
your logic, or you need to put a conditional in to guard against
meaningless input.
Uncaught exception from user code:
Illegal division by zero at ./mysqltuner.pl line 594, <> line 2.
at ./mysqltuner.pl line 593
main::calculations() called at ./mysqltuner.pl line 938
Any help would be appreciated.
Thank you.
|
| Posted by Mambug, 09-12-2011, 02:06 PM | | Looks like your providing the wrong password, or the user you are providing does not have full mysql root privileges.
|
| Posted by streaky81, 09-12-2011, 04:11 PM | | Well it's root@localhost so I'm guessing the root user is actually screwed up in some way...
|
| Posted by yuriko, 09-12-2011, 05:11 PM | | Tried another user, same thing
ERROR 1142 (42000) at line 1: SELECT command denied to user 'user'@'localhost' for table 'user'
[OK] All database users have passwords assigned
Illegal division by zero at ./mysqltuner.pl line 594, <> line 2 (#1)
(F) You tried to divide a number by 0. Either something was wrong in
your logic, or you need to put a conditional in to guard against
meaningless input.
Uncaught exception from user code:
Illegal division by zero at ./mysqltuner.pl line 594, <> line 2.
at ./mysqltuner.pl line 593
main::calculations() called at ./mysqltuner.pl line 938
|
| Posted by yuriko, 09-12-2011, 05:14 PM | | Wrong pass word would give this error,
[!!] Attempted to use login credentials, but they were invalid.
I'm using root user so I guess it has full privileges.
|
| Posted by Mambug, 09-12-2011, 05:15 PM | | The issue is with the user account not having permission/access to the tables in question.
Make sure that the user account your using has the right privileges.
|
| Posted by yuriko, 09-12-2011, 10:52 PM | | I think you are right, it's the privileges problem, not sure how the privs got removed.
|
| Posted by mattmackman, 12-28-2011, 04:00 AM | | change the mysql password and try again
|
|
 Add to Favourites
 Print this Article
|
