update gb_member set mb_passwd=password("7023") where mb_id='root';

mysql load data infile 에러시 ERROR 1045: Access denied for user: '@localhost' (Using password: NO) 조치방법 # mysq -u root -p mysql update user set File_priv = 'Y' where user='사용자명'; flush privileges;

mysql> optimize table 테이블명;

[root@localhost mysql]# ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --sysconfdir=/etc --without-debug --with-charset=euckr --with-extra-charsets=all --with-plugins=innobase checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking for a BSD-compatible install... /usr/bin..

1. etc/my.cnf (또는 my.ini) 에서 캐릭터셋 수정 [client] #password = your_password default-character-set=utf8 [mysqld] init_connect=SET collation_connection = utf8_general_ci init_connect=SET NAMES utf8 default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci [mysql] default-character-set=utf8 2. 환경변수를 모두 수정후 mysql 서비스 재시작 3. mysql에서 캐릭터셋 확인 # mysql Type 'help;' or '\h' for hel..