How to solve this issue in cpanel server Please use the full name instead

MySQL & MariaDB Other MySQL® Questions
1

Hello Everybody,
today we installed percona mysql on 1 server,

but when we restore any account from another server here on this server,

in mysql restoring

[TABLE=“width: 0, align: center”]
[TR]
Restoring MySQL databases… [/TR]
[TR]
[TD=“align: left”]Restoring database mobileus_bsu…
Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. …
Done
Restoring database mobileus_down…
Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. Done
Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. Database “cptmpdb_mobileus_Uu4IXXC_O2BN3ZMC” dropped Done
Done
Done[/TD]
[/TR]
[/TABLE]

[TABLE=“width: 0, align: center”]
[TR]
Restoring MySQL privs [/TR]
[TR]
[TD=“align: left”]Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead. Done[/TD]
[/TR]
[/TABLE]
[TABLE=“width: 0, align: center”]
[TR]
Reloading MySQL [/TR]
[TR]
[TD=“align: left”]Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.Done[/TD]
[/TR]
[/TABLE]

Everything working fine on this server but why this error is coming,

but in my previous Mysql server there is no error,

please confirm how to solve this issue

waiting for your reply

2

Hi,

Can you please check your my.cnf OR .my.cnf ? If you are using “pass” rather then “password” for client section OR anywhere else in restoring process then you can probably get these warnings.
i. e

[client]
user = root
pass = root

To avoid those warnings, you can do something like

[client]
user = root
password = root

Thanks.

3

Daer niljoshi,

Done

am still facing this issue.[/B]

4

Hi,

Can you provide command line for restoring databases and my.cnf if possible?
Can you also check if there is any .my.cnf file in your current dir from where you are restoring database OR in your home dir in Linux where pass is mentioned?

most of the time problem is that only. check this one [URL]http://www.miqrogroove.com/blog/2013/mysql-password-errors/[/URL]

Thanks.