mysql安装完怎么配置

[mysqld]
# 设置MySQL服务器的基本参数
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket = /tmp/mysql.sock
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

# 设置最大连接数
max_connections = 200

# 设置日志文件路径
log-error=/var/log/mysql/error.log
slow_query_log_file=/var/log/mysql/slow-query.log
long_query_time=2

mysql -u root -p

CREATE DATABASE mydatabase;

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';
GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';
FLUSH PRIVILEGES;

-- 删除匿名用户
DELETE FROM mysql.user WHERE User='';

-- 禁止root远程登录
UPDATE mysql.user SET Host='localhost' WHERE User='root';

-- 刷新权限
FLUSH PRIVILEGES;

-- 设置密码策略
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword';
FLUSH PRIVILEGES;

sudo systemctl start mysqld

sudo systemctl stop mysqld

sudo systemctl status mysqld