• 흐림동두천 -3.1℃
  • 구름많음강릉 3.2℃
  • 흐림서울 -2.1℃
  • 구름많음대전 0.5℃
  • 흐림대구 1.7℃
  • 구름많음울산 7.1℃
  • 구름많음광주 0.5℃
  • 흐림부산 6.8℃
  • 흐림고창 0.1℃
  • 흐림제주 5.2℃
  • 흐림강화 -3.4℃
  • 구름많음보은 0.0℃
  • 구름많음금산 -0.1℃
  • 흐림강진군 2.1℃
  • 구름많음경주시 4.7℃
  • 흐림거제 4.0℃
기상청 제공

mysql에서 fonction 생성과 관련된 옵션

// mysql root password 등록


[root@linux mysql]# mysql -u root -p mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 1 to server version: 4.0.23-Max

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.


mysql> update user set password=password('비밀번호입력') where user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0


mysql> flush privileges;  <==  mysql 재시동
Query OK, 0 rows affected (0.00 sec)


mysql> quit


// 접속 확인하기

[root@linux mysql]# mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 4 to server version: 4.0.23-Max

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.