403
回編集
「Xserver VPSでDebianサーバ構築/Wikiサーバ設定」の版間の差分
ナビゲーションに移動
検索に移動
→設定
(→概要) |
(→設定) |
||
|
= 設定 =
== DB ==
<nowiki>
create a NEW mysql user (new_mysql_user):
$ sudo mysql -u root -p
Enter password: Enter password of mysql root user (if you have not configured password it will be blank, so just press enter)
mysql> CREATE USER 'new_mysql_user'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED';
create a NEW mysql database my_wiki:
$ sudo mysql -u root -p
mysql> CREATE DATABASE my_wiki;
mysql> use my_wiki;
Database changed
GRANT the NEW mysql user access to the NEW created mysql database my_wiki:
mysql> GRANT ALL ON my_wiki.* TO 'new_mysql_user'@'localhost';
Query OK, 0 rows affected (0.01 sec)
mysql> quit;
</nowiki>
| |||