大数据随记 —— MySQL 只能远程登录，不能本地登录

[root@master ~]# mysql -uroot -p123456
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

mysql> use mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

[root@master ~]# mysqld
220811  9:21:48 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

220811  9:21:48 [ERROR] Aborting

220811  9:21:48 [Note] mysqld: Shutdown complete

[root@node1 sbin]# mysqld --user=root restart
220811  8:46:42 [Note] Plugin 'FEDERATED' is disabled.
220811  8:46:42  InnoDB: Initializing buffer pool, size = 8.0M
220811  8:46:42  InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
220811  8:46:42  InnoDB: Retrying to lock the first data file

mysql> grant all privileges on *.* to root@'localhost' identified by '123456';
mysql> flush privileges;