MySQL 설치
chown -R mysql:mysql data/
chmod -R 700 data/
ll
total 324K
-rwx------ 1 mysql mysql 587 Mar 24 2020 README
-rwx------ 1 mysql mysql 269K Mar 24 2020 LICENSE
drwx------ 3 mysql mysql 4.0K Dec 9 13:38 include
drwx------ 4 mysql mysql 4.0K Dec 9 13:38 man
drwx------ 2 mysql mysql 4.0K Dec 9 13:38 bin
drwx------ 5 mysql mysql 4.0K Dec 9 13:38 lib
drwx------ 2 mysql mysql 4.0K Dec 9 13:38 support-files
drwx------ 28 mysql mysql 4.0K Dec 9 13:38 share
drwx------ 2 mysql mysql 4.0K Dec 9 13:38 docs
-rwx------ 1 mysql mysql 11K Dec 9 15:26 mysql.server
-rwx------ 1 mysql mysql 2.3K Dec 9 16:41 my.cnf
drwx------ 2 mysql mysql 4.0K Dec 9 16:42 data
./bin/mysqld --defaults-file=/home/db/mysql/my.cnf --initialize --user=mysql
2020-12-09T16:42:55.644879+09:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-12-09T16:42:55.645079+09:00 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
100 200 300 400 500 600 700 800 900 1000
100 200 300 400 500 600 700 800 900 1000
2020-12-09T16:43:16.603297+09:00 0 [Warning] InnoDB: New log files created, LSN=45791
2020-12-09T16:43:16.971311+09:00 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-12-09T16:43:17.083150+09:00 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 3352463e-39f2-11eb-be28-b06ebf1f132d.
2020-12-09T16:43:17.090017+09:00 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-12-09T16:43:18.298670+09:00 0 [Warning] CA certificate ca.pem is self signed.
2020-12-09T16:43:18.654312+09:00 1 [Note] A temporary password is generated for root@localhost: lyp91hR3_*G:
./bin/mysqld_safe --defaults-file=/home/db/mysql/my.cnf &
[1] 32397
Logging to '/home/db/mysql/data/parkjw.in.err'.
2020-12-09T07:56:44.435177Z mysqld_safe Starting mysqld daemon with databases from /home/db/mysql/data
./bin/mysql -S/home/db/mysql/data/mysql.sock -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.30-log
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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'crinity21!';
Query OK, 0 rows affected (0.01 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
Bash
복사