I can`t create users in mysql 5.6

MarcC2

Bit poster
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.
 
Back
Top