Not the answer you need?
Register and ask your own question!

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

saqibnptsaqibnpt EntrantCurrent User Role Beginner
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



Restoring MySQL databases....

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





Restoring MySQL privs

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




Reloading MySQL

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




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

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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.
  • saqibnptsaqibnpt Entrant Current User Role Beginner
    Daer niljoshi,




    Done

    am still facing this issue.[/B]
  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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 http://www.miqrogroove.com/blog/2013/mysql-password-errors/

    Thanks.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.