티스토리 뷰
728x90
MySQL 5.7.17 - 수동설치
출처 : 취향창고 :: [윈도우10]mysql 5.7.10 수동 설치기
환경파일 생성(mysql.ini)
[mysqld]
# port
# port=3306
# set basedir to your installation path
basedir=C:/mysql/mysql-5.7.17-winx64
# set datadir to the location of your data directory
datadir=C:/mysql/mysql-5.7.17-winx64/data
character-set-server=utf8
collation-server=utf8_general_ci
#default-storage-engine = InnoDB
#default-table-type = InnoDB
transaction-isolation = READ-COMMITTED
[mysql]
no-auto-rehash
default-character-set=utf8
[client]
default-character-set=utf8
초기화
bin\mysqld --initialize
root 계정 암호 초기화
권한 없이 mysql 서버 실행
bin\mysqld --skip-grant-tables
root 계정 암호 설정
C:\mysql\mysql-5.7.17-winx64>bin\mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, 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> use mysql
Database changed
mysql> update user set authentication_string = password('sql') where user = 'root';
Query OK, 1 row affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit Bye
localhost용 root 계정 등록
C:\mysql\mysql-5.7.17-winx64>bin\mysql -u root -p Enter password: *** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.7.17 Copyright (c) 2000, 2016, 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 'sqldba'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> quit Bye
mysql 서비스 등록
bin\mysqld.exe --install "MySQL 5.7.17" --defaults-file=C:\mysql\mysql-5.7.17-winx64\mysql.ini
mysql 서비스 삭제
bin\mysqld.exe --remove "MySQL 5.7.17"
댓글
300x250
공지사항
최근에 올라온 글
최근에 달린 댓글
- Total
- Today
- Yesterday
TAG
- oracle
- 튜닝쇼 2008
- Spring MVC
- 지스타2007
- Linux
- 레이싱모델 익스트림 포토 페스티벌
- 송주경
- ubuntu
- BPI-M4
- flex
- 서울오토살롱
- Spring
- 전예희
- MySQL
- ffmpeg
- sas2009
- android
- ble
- koba2010
- JavaScript
- NDK
- 동경
- Delphi
- Xcode
- Java
- SAS
- KOBA
- Delphi Tip
- Mac
- 일본여행
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 |
글 보관함