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.

Ask you a question about python crawler and big data.
my graduation project is to do a system to climb the Douban website, and my classmate s graduation project is big data s topic. Our teacher Bishu asked me to use a crawler to store the data, and then make an interface to transmit the data to my classma...

Mysql ubuntu linux python

Mar.03,2021
Ubuntu scheduled task cannot back up mysql, backup files are empty
-sharp! bin bash file_name2=`date +%Y%m%d%H%M%S` mkdir home sql_bak user_bak $file_name2 chmod 7777 home sql_bak user_bak $file_name2 -sharp-sharp-sharp-sharp arr_string=(users payrecord_fruitcoin yamirecord vipexam_record stream_order io...

Mysql ubuntu linux shell

Mar.04,2021
Linux Ubuntu automatically backs up the mysql script on a regular basis, and there is no problem with the content in the script.
I wrote a sh script on linux. When I used the command to execute the script, the execution was successful. A normal sql file is generated in the path I wrote. mysql account password is in the configuration file. script content: -sharp! bin bash mys...

Mysql ubuntu linux

Mar.09,2021
Cannot install gdbm for python3.5?
pythonconmmandnotfound.pygdbm ...

Javascript linux mysql ubuntu python

Mar.10,2021
Ubuntu18 Desktop version installation flask-mysqldb compilation failed
1. I am using the Ubuntu18.04 desktop version now. A compilation error occurred during learning flask-mysqldb. 2. Before asking this question, Baidu Google numerous, but not my feelings, specially to ask netizens for help. 3.Failed building wheel for ...

Mysql ubuntu linux flask python

Jul.16,2021
Linux server, error after installing pdo_mysql extension
after I install the pdo_mysql extension, I link with tp and report an error from time to time : ( Undefined class constant MYSQL_ATTR_INIT_COMMAND wrong location but after a while it returned to normal, and after a while it was out of touch, and...

Mysql ubuntu php

Jan.26,2022
What is the reason for the failure to start MySQL after the ubuntu server restarts?
it was fine before rebooting, but after rebooting, it will never be able to start again root@iZuf6acp86oa3jizjzwaqdZ:~-sharp service mysql start Job for mysql.service failed because the control process exited with error code. See "systemctl status...

Php sql mysql ubuntu linux

Feb.25,2022
Mobile Websocket failed to use connection and reported ProtocolException error
the development of mobile app during the recent winter vacation requires Websocket to receive messages pushed in the background I use RxWebSocket to connect there s nothing wrong with writing a small demo with ws: echo.websocket.org , but replacing...

Mysql ubuntu java android

May.09,2022