$ ssh-keygen -f ~/temp/ljflxxglpt.pem Generating public/private rsa key pair. Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /home/gmy/temp/ljflxxglpt.pem. Your public key has been saved in /home/gmy/temp/ljflxxglpt.pub. The key fingerprint is: 7a:9c:b2:9c:8e:4e:f4:af:de:70:77:b9:52:fd:44:97 personalid The key's randomart image is: +--[ RSA 2048]----+ | | | | | .| | Eo| | . S . ..| | . . o . ... .| | . = = ..o o | | . o X ... . .| | .ooB.o .. | +-----------------+
$ yum install postgresql-server $ yum install postgresql-devel $ service postgresql initdb $ chkconfig postgresql on $ sudo -u postgres psql postgres=# \password postgres postgres=# CREATE USER lettoo_base_api WITH PASSWORD 'password'; postgres=# CREATE DATABASE lettoo_base_api OWNER lettoo_base_api; postgres=# GRANT ALL PRIVILEGES ON DATABASE lettoo_base_api to lettoo_base_api; postgres=# \du postgres=# \q $ exit $ vi /var/lib/pgsql/data/pg_hba.conf local all all peer > local all all md5 $ systemctl restart postgresql.service $ psql -U lettoo_base_api -d lettoo_base_api
(7) 创建mysql数据库
1 2 3 4 5
mysql> DROP DATABASE ljflxxglpt; mysql> CREATE DATABASE ljflxxglpt CHARACTER SET utf8; mysql> GRANT ALL PRIVILEGES ON ljflxxglpt.* TO "ljflxxglpt"@"%" IDENTIFIED BY "password"; mysql> FLUSH PRIVILEGES; mysql> EXIT;