mysql的问题

Question

mysql或mysql_secure_installation

ERROR 1045 (28000): Access denied for user 'pc123'@'localhost' (using password: NO)

米舍尔德

[Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 15173
[Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
[Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
[ERROR] [MY-013276] [Server] Failed to set datadir to '/var/lib/mysql/' (OS errno: 13 - Permission denied)
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.

我刚安装了mysql，有什么问题吗？

Answer 1

你试过

mysql (without any parameter)

这是第一个错误-错误(使用密码:否)将被抛出。

第一次

mysql -u root -p

并给根密码输入。然后

create database db1;
create user user1@localhost identified by 'user1pwd';
grant all on db1.* to user1@localhost;

下一次你要通过

mysql -u user1 -p

并且只能访问db1。

(请注意:如果pc123是您的系统用户，并且您也喜欢将这个用户名用于mysql，请将user1替换为pc123)。