The mysql root account seems to be messed up.

two questions, when logging in, typing mysql-u root-p correctly jumps to the password line, but you can"t type the password on the keyboard. You can"t log in with a password, but you can log in directly by typing mysql. Is this the wrong place? I have been searching the Internet for a long time, and some people say that I may have messed up root users. What should I do? QAQ

clipboard.png

this is the user table I checked after I opened and logged in. Have I changed it?-_-- sharp

after being reminded by the following kind-hearted people, the reason is that I am not clear about the following reasons: entering a password under the
1.linux command line will display neither characters nor alternative symbols, for example, most of the time. That is, nothing will be displayed when entering the password. As long as you type it correctly, you can enter. (by Lyux)
2 by hitting enter. Quit without refreshing in time.
3. Remedy safe_MySQLd-- skip-grant-tables-log in again without a password and update your password the way you adopt the answer, and then you"ll be fine. Orz

Java mysql linux centos
Mar.02,2021

I just installed a clean MySQL,user table myself. Looks like you added two records that host is'%'. 

+------+----------+----------------------+
| user | password | host                 |
+------+----------+----------------------+
| root |          | localhost            |
| root |          | vm\_238\_239\_centos |
| root |          | 127.0.0.1            |
| root |          | ::1                  |
|      |          | localhost            |
|      |          | vm\_238\_239\_centos |
+------+----------+----------------------+

if you can't log in with a password, you can reset the password: 

  
 is just a guess. Your problem may be simply because you don't know the fact that entering a password under the 
 linux command line will display neither characters nor alternative symbols such as    . That is, nothing will be displayed when entering the password. But you can just type it. As long as you type it correctly, you can enter by hitting enter.

Previous: Fis3 packing problem

Next: How to modify vue element el-tree defaultExpandedKeys dynamically?

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-1b31807-2bd91.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-1b31807-2bd91.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?