Can't login phpmyadmin and mysql_upgrade error 2003

  • | 396 points


    I can't login to phpmyadmin.

    With mysql-5.1.72-win32 with "root" as login and password I get this error:

    alt text

    With "root" as login and no password I can access phpmyadmin and the setting menu but as soon as I click on something else I'm automatically disconnected.

    AllowNoPassword in is setted on True.

    I get the same errors with mysql-5.1.73-win32.

    I also have this message from Laragon:

    alt text

    Here is what I get in mysqld.log

    201105 22:42:56 [Note] Plugin 'FEDERATED' is disabled.
    C:\Users\user\LaragonServerPortable\bin\mysql\mysql-5.1.73-win32\bin\mysqld: Table 'mysql.plugin' doesn't exist
    201105 22:42:56 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    201105 22:42:56 InnoDB: Initializing buffer pool, size = 8.0M
    201105 22:42:56 InnoDB: Completed initialization of buffer pool
    201105 22:42:56 InnoDB: Started; log sequence number 0 44233
    201105 22:42:56 [ERROR] C:\Users\user\LaragonServerPortable\bin\mysql\mysql-5.1.73-win32\bin\mysqld: unknown variable 'explicit_defaults_for_timestamp=1'
    201105 22:42:56 [ERROR] Aborting

    When I do a mysql_upgrade I get an error 2003

    Running 'mysqlcheck' with connection arguments: "--port=3306" "--socket=/tmp/mysql.sock"
    Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect
    FATAL ERROR: Upgrade failed

    EDIT: I only get these errors with the portable version, when I install the complete version it's running well.

Log in to reply

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