root mysql - Not enough privilege to view server status.
-
Hi, I getting this problem when I want to view database statistic
D:\laragon\www Thu 08/25/2016 15:41:56.48 λ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 34 Server version: 5.7.13-log MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show grants; +---------------------------------------------------------------------+ | Grants for root@localhost | +---------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | +---------------------------------------------------------------------+ 2 rows in set (0.00 sec)Can you help me?
-
@krip: The 5.7.13 bundled with Laragon is using the same mysql database schema with MariaDB 10.1 for easily to switch between them.
If you insist on using 5.7.13, you can run mysql_upgrade to have full features (pros: you will not switch to other MySQL fork easily anymore)
If you don't use JSON type, please consider to use MariaDB for performance and compatibility.
-
Ok great. Thanks for informative response!
1132 points