ORACLE PASSWORD FOR SYS AND SYSTEM: 650d4f293b8fb05e
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
次のメッセージが表示されたらOK。
#########################
DATABASE IS READY TO USE!
#########################
コンテナに入り、簡単な動作確認
docker exec-it--user root my-oracle bash -p
コンテナ内部
bash-4.2# su oracle
[oracle@hostname /]$ sqlplus SYSTEM/650d4f293b8fb05e
SQL*Plus: Release 18.0.0.0.0 - Production on Fri May 29 12:45:51 2020
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Last Successful login time: Thu May 28 2020 12:54:45 +00:00
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL> select table_name from all_table
省略
SQL> exit
Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
[oracle@hostname /]$ exit
exit
exit
bash-4.2# exit
[db2inst1@hostname ~]$ db2 -t(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 11.5.0.0
You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 =>bind sample.bnd
For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.
To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
For more detailed help, refer to the Online Reference Manual.
db2 => connect to testdb;
Database Connection Information
Database server = DB2/LINUXX8664 11.5.0.0
SQL authorization ID = DB2INST1
Local database alias= TESTDB
db2 =>select
db2 (cont.)=> tabname
db2 (cont.)=> from
db2 (cont.)=> syscat.tables;
省略
db2 => quit;
DB20000I The QUIT command completed successfully.
[db2inst1@hostname ~]$ exit
docker run -it--name my-mysql -eMYSQL_ROOT_PASSWORD=mysql -d mysql:latest
コンテナ起動状況を確認
docker logs -f my-mysql
次のメッセージが表示されたらOK。
/usr/sbin/mysqld: ready for connections. Version: '8.0.20' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
コンテナに入り、簡単な動作確認
docker exec-it--user root my-mysql bash -p
コンテナ内部
root@hostname:/# mysql -u root -h localhost -p
Enter password: mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.20 MySQL Community Server - GPL
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
mysql> SELECT table_catalog,table_schema,table_name,table_type FROM information_schema.tables;
省略
mysql> exit
Bye
root@hostname:/# exit
Build PHP 7 User Registration (Signup) Form with MySQL
Learn how to create a basic PHP 7 user registration system, add PHP validation in registration form, securely hash password and store the user information in the MySQL database.
mysql>GRANT ALL PRIVILEGES ON dbname.* TO dbuser@'localhost' IDENTIFIED BY 'dbpassword';
既に、ユーザーを作成している場合などは上記の作成を分けることもできます。
(データベースユーザー作成)
mysql> CREATE USER dbuser@localhost IDENTIFIED BY 'dbpassword';
(データベースに対するユーザーのアクセス権限付与)
mysql> GRANT ALL PRIVILEGES ON dbname.* TO dbuser@'localhost;
#!/bin/bashset-e# Remove a potentially pre-existing server.pid for Rails.rm-f /myapp/tmp/pids/server.pid
# Then exec the container's main process (what's set as CMD in the Dockerfile).exec"$@"
docker-compose.yml
version:'3'services:db:container_name:dbimage:mysql:8.0environment:MYSQL_ROOT_PASSWORD:password#3307にしているのは筆者の環境では3306がpc自体のMySQLで使われているためです。3306:3306の方がいいかもです。ports:-'3307:3306'command:--default-authentication-plugin=mysql_native_passwordvolumes:-mysql-data:/var/lib/mysqlback:container_name:backbuild:back/command:bash -c "rm -f tmp/pids/server.pid && bundle exec rails s -p 3000 -b '0.0.0.0'"volumes:-./back:/myappports:-"3000:3000"depends_on:-dbstdin_open:truetty:truecommand:bundle exec rails server -b 0.0.0.0front:container_name:frontbuild:front/command:yarn devvolumes:-./front:/myappports:-8080:3000#depends_onでbackコンテナへのリンクを張っています。depends_on:-backvolumes:mysql-data:driver:local
