pooh

I needed to edit /usr/lib/systemd/system/mysqld.service and addLimitNOFILE=infinity LimitMEMLOCK=infinityThen run systemctl daemon-reload and systemctl restart mysql.service.Now the variable is capped at 65536 for some reason unknown, but I can live with that for now.Found this at http://unix.stackexchange.com/questions/152186/mysql-max-open-files-more-than-1024#answer-157910 출처: http://dba.stac..

1. 모든 IP 설정insert into mysql.user (host,user,password,ssl_cipher,x509_issuer,x509_subject) values('%','[user id]',password('[user password]'),'','','');grant all privileges on *.* to '[user id]'@'%';flush privileges; 2. IP 지정insert into mysql.user (host,user,password,ssl_cipher,x509_issuer,x509_subject) VALUES ('123.123.%','[user id]',password('[user password]'),'','','');grant all privileges on..

1. 연결mysql -u [user id] -p mysql 2. db 생성create database [database name]; 3. table 및 user 생성 및 user 할당grant all privileges on [database name].* to [user id]@localhost identified by '[password]' with grant option; 4. user 생성 확인use mysql;select * from user; 5. 연결mysql -u [user id] -p [database name] [root@build-test FlowAgent]# mysql -u root -p mysqlEnter password:Reading table information for com..

1. consolupdate user set password=password('[change password]') where user='[user id]'; mysql> update user set password=password('xxxxxx') where user='root';Query OK, 4 rows affected (0.05 sec)Rows matched: 4 Changed: 4 Warnings: 0mysql> quitBye[root@test /]# mysqladmin -u root -p reloadEnter password:[root@test /]# 2. command # mysqladmin -u [user id] -p password '[change password]' [root@test ..

mysql -u [user id] -p [db name] [root@build-test FlowAgent]# mysql -u root -p mysqlEnter password:Reading table information for completion of table and column namesYou 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 17Server version: 5.6.34 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle ..

mysql client에서 server로 쿼리 전송 시 전송크기가 크면 아래 오류 발생 state:08S01, native:2006, msg:[MySQL][ODBC 5.2(w) Driver][mysqld-5.6.25-enterprise-commercial-advanced-log]MySQL server has gone away - 해결 방안 -mysql 실행 중 쿼리를 통해 설정 SET GLOBAL max_allowed_packet = 1024 * 1024 * 64; SET SESSION max_allowed_packet = 1024 * 1024 * 64; 또는 mysql 설정 파일 수정(mysql 실행 시 적용) [mysqld]max_allowed_packet = 64M 쿼리를 통해 설정하게 되면 mys..

CentOS7 에서 패키지 설치 및 연결 테스트 진행 1. mysql connector odbc 설치# yum install -y mysql-connector-odbc 2. unixODBC devel 설치 - unixODBC는 "mysql connector odbc" 설치 시 의존성으로 같이 설치 됨.# yum install -y unixODBC-devel 3. odbcinst.ini 설정# vi /etc/odbcinst.ini# Example driver definitions # Driver from the postgresql-odbc package # Setup from the unixODBC package [PostgreSQL] Description = ODBC for PostgreSQL Drive..