블로그
- JDBC Introduction a database (2) Creating SQL or MYSQL statements (3) Executing SQL or MYSQL queries in the database ( access = in general (1) JDBC API = providing the application-to-JDBC Manager con.......
- [영진전문대 컴퓨터정보계열 컴퓨터프로그래밍전공] 자바서버프로그래밍 mysql 명령프롬프트에서 아래와 같이 명령어 입력 grant all privileges on *.* to '유저'@'아이피' identified by '비밀번호'; 유저= 원격접속가능 -u root mysql *root 비번 설정 -> mysql> SET PASSWORD FOR root=password('새비밀번호'); * 원격호스트 (dbname에)
- mysqladmin 명령 mysqladmin Client for Administering a MySQL Server 1) 데이터베이스의 creating 2) 데이터베이스의 dropping 3) grant tables의 reload 4) flushing tables to disk 5) reopening log file 6) 서버의 version, process, status에 관한 정보 【사용법】
- Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server In some cases people have dropped MySQL and have shifted to NoSQL. One of the biggest reasons for such a movement is that it is said that NoSQL performs better than MySQL
- MySQL Storage Engine Architecture MySQL Storage Engine Architecture, Part 1: An OverviewBy Arjen Lentz, MySQL AB 2 April 2004 출처: http: on which storage engine is best suited for a particular situation.
- mysql root 비밀번호 잊어 먹었을 때 /bin/mysqld_safe --skip-grant-tables &[root@localhost local]# mysqlWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 2 to server version: 4.0.20-log Type 'help;' or
- 자주쓰는 명령 정리 SET A PASSWORD FOR THE MySQL root USER ! : mysql> use DB명 (엄밀히 말하자면, 사용할 'default database'를 선택하는 것이다.)DB변경: mysql> alter database .....