에버노트 에버노트

MySQL

• Warning: World-writable config file '/etc/my.cnf' is ignored

  IT 2020. 5. 22. 14:25

  Warning: World-writable config file '/etc/my.cnf' is ignored chmod 644 /etc/my.cnf

  Read More
• mysql 명령어

  IT 2020. 5. 20. 15:34

  select user,password,host from user;

  Read More
• mysql 쉘 쿼리 실행

  IT 2020. 5. 20. 14:51

  #암호 설정되어 있찌 않다. mysql -uroot > root.sql #root.sql use mysql; update user set password=password('dhormfo') where user='root'; grant all privileges on *.* to root@'%' identified by 'dhormfo'; flush privileges;

  Read More
• mysql 5.5.57 설치

  IT 2020. 5. 14. 15:54

  5.6 동일 CentOS Linux release 7.8.2003 (Core) wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.5.57-linux-glibc2.12-x86_64.tar.gz groupadd -g 501 mysql useradd -u 501 -g 501 -d /usr/local/mysql -s /sbin/nologin mysql tar zxvf mysql-5.5.57-linux-glibc2.12-x86_64.tar.gz ln -s mysql-5.5.57-linux-glibc2.12-x86_64.tar.gz cd mysql chown -R mysql:mysql . cp support-files/my-medium.cnf /etc..

  Read More
• Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid.)

  IT 2020. 5. 14. 10:07

  /usr/local/mysql/data/localhost.localdomain.pid. #에러로그 확인 /usr/local/mysql/data/localhost.localdomain.err # yum이 설치되어 있었다. 3306 포트를 사용된 문제 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use [ERROR] Do you already have another mysqld server running on port: 3306 ? [ERROR] Aborting yum remove mysql* /usr/local/mysql/data/localhost.localdomain.pid.

  Read More
• yum mysql 삭제

  IT 2020. 5. 14. 10:02

  # 검색 yum list installed mysql* yum remove mysql*

  Read More