数据库配置

2022-02-25 2022-12-11 约 223 字预计阅读 1 分钟 - 次阅读

警告

本文最后更新于 2022-12-11，文中内容可能已过时。

mysql数据库

1
sudo vim /etc/mysql/my.cnf

1
2
[mysqld]
skip-grant-tables

1
sudo service mysql restart

1
2
3
mysql -u root
use mysql;
update user set password=password("test@123") where user="root";

看mysql忘记密码的第一步

1
2
3
4
flush privileges;
alter user 'root'@'localhost' identified by 'test@123';
flush privileges;
commit;

1
CREATE DATABASE IF NOT EXISTS nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

1
sudo vim /etc/mysql/my.cnf

1
2
[mysqld]
bind-address=0.0.0.0

1
2
3
4
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
# 所有的数据库都可以在外网访问
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%';
FLUSH PRIVILEGES;