Unable to create the new database user

[DarkDragon]

Anyone know how to fix this?

Error: Connection to the database server failed: Unknown column 'plugin' in 'mysql.user'

 

[davidktw]

Anyone know how to fix this?

Error: Connection to the database server failed: Unknown column 'plugin' in 'mysql.user'

Show us what is the command you issue to create the user.

 

[davidktw]

Seriously is google that hard?

http://serverfault.com/questions/66...ng-from-old-style-passwords-and-mysql-upgrade

 

[DarkDragon]

[/URL][/IMG]

I was trying to create the database via the Plesk 12 Linux.
To add new database user then it will appear the error message as per image.

 

[davidktw]

[/URL][/IMG]

I was trying to create the database via the Plesk 12 Linux.
To add new database user then it will appear the error message as per image.

You could be using MySQL DB later than or equal to 5.7.2 ?

Read this http://serverfault.com/questions/66...ng-from-old-style-passwords-and-mysql-upgrade

You may need to upgrade your database files using mysql_upgrade

Backup your mysql datafiles before you proceed.

Use the command line, not the Plesk UI interface.

 

[DarkDragon]

Seriously is google that hard?

http://serverfault.com/questions/66...ng-from-old-style-passwords-and-mysql-upgrade

I have tried it but it does not working.

 

[DarkDragon]

You could be using MySQL DB later than or equal to 5.7.2 ?

Read this http://serverfault.com/questions/66...ng-from-old-style-passwords-and-mysql-upgrade

You may need to upgrade your database files using mysql_upgrade

Backup your mysql datafiles before you proceed.

Use the command line, not the Plesk UI interface.

It is MySQL version 5.6

I have nothing to backup our mysql data files.

I am using the Putty to access the linux server and tried the command line below:
[root@xxx ~]# mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed

 

[DarkDragon]

Resolve this issue. Closed case. Thanks