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

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.

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