root mysql - Not enough privilege to view server status.


  • | 1132 points

    Hi, I getting this problem when I want to view database statistic

    0_1472111156792_Capture.JPG

    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?


  • administrators
    | 62340 points

    @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.


  • | 1132 points

    Ok great. Thanks for informative response!


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.