I can`t create users in mysql 5.6

Discussion in 'Installation and Configuration of Parallels Desktop' started by MarcC2, Nov 6, 2015.

  1. MarcC2

    MarcC2 Bit poster

    Messages:
    1
    Hi all, I have since yesterday afternoon with a problem that is driving me crazy, no matter how I look I can not find the solution. Is this:

    On a server with CentOS 6 had installed MySQL version 5.1, but I need the 5.6, so, I installed smoothly on the server, but when I want to add a database, tells me that you can not create the user and me shows this error:

    Error: Failed to connect to database server: Unknown column 'plugin' in 'mysql.user'

    I think the problem is that somehow uses version 5.6 but with tables 5.1

    If you execute SELECT version () on the console shows me

    + ----------- +
    | version () |
    + ----------- +
    | 5.6.27 |
    + ----------- +
    1 row in set (0.00 sec)

    However, with this instruction depending on the number of columns to return, is the version of MySQL that is running

    SELECT COUNT (1) FROM column_count INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_SCHEMA = 'mysql' AND table_name = 'user';

    If you get 43, MySQL 5.6
    If you get 42, MySQL 5.5
    If you get 39, MySQL 5.1
    If you get 37, MySQL 5.0

    And the result is
    + -------------- +
    | column_count |
    + -------------- +
    | 39 |
    + -------------- +
    1 row in set (0.00 sec)

    I can not create users per console shows me the same error.

    Any help, track or suggestion, be grateful, and not to do.

    Thank you very much in advance.
     

Share This Page