Mysql cannot set password

No matter what password you set, it doesn"t work. You can enter any password when you log in.
View and display in mysql as follows:

< table > < thead > < tr > < th > MariaDB [mysql] > select authentication_string from user; < / th > < / tr > < / thead > < tbody > < tr > < td > authentication_string < / td > < / tr > < tr > < td > < / td > < / tr > < / tbody > < / table >

1 row in set (0.00 sec)

< table > < thead > < tr > < th > MariaDB [mysql] > select user from user; < / th > < / tr > < / thead > < tbody > < tr > < td > user < / td > < / tr > < tr > < td > root < / td > < / tr > < / tbody > < / table >

1 row in set (0.00 sec)

< table > < thead > < tr > < th > MariaDB [mysql] > select host from user; < / th > < / tr > < / thead > < tbody > < tr > < td > host < / td > < / tr > < tr > < td > localhost < / td > < / tr > < / tbody > < / table >

1 row in set (0.00 sec)

Mysql ubuntu
Jun.02,2021

do you add skip-grant-tables to the my.cnf file and skip the password to log in
(it seems to be my.ini under window)

solved, there is a problem with mysql password authentication.
select Host,User,plugin from mysql.user where User='root';

at this time, you will find that plugin (encryption method) is unix_socket,

update mysql.user set plugin='mysql_native_password';-sharp reset encryption

update mysql.user set password=PASSWORD ("newpassword") where User='root';-sharp set new password

flush privileges;-sharp refresh permission information

then you can use

normally.

try setting password in administrator mode

Previous: How does js generate folders according to the path?

Next: To find a way to realize the animation effect of scrolling at the front end.

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3891e-2c11e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3891e-2c11e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?