Unable to create the new database user

DarkDragon

Member
Joined
Jan 6, 2006
Messages
328
Reaction score
0
Anyone know how to fix this?

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

DarkDragon

Member
Joined
Jan 6, 2006
Messages
328
Reaction score
0
mysqluser.png
[/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

Arch-Supremacy Member
Joined
Apr 15, 2010
Messages
13,547
Reaction score
1,301
mysqluser.png
[/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

Member
Joined
Jan 6, 2006
Messages
328
Reaction score
0
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
 
Important Forum Advisory Note
This forum is moderated by volunteer moderators who will react only to members' feedback on posts. Moderators are not employees or representatives of HWZ Forums. Forum members and moderators are responsible for their own posts. Please refer to our Community Guidelines and Standards and Terms and Conditions for more information.
Top