목록DB/MYSQL (65)

개인적인 정리

mysql 사용자 명 글자 수

user names are up to 32 character long 32글자까지 라고 한다.
DB/MYSQL 2020. 2. 6. 16:45
mysql.user table 설명

계정정보를 저장한다. user name 과 client host로 정의된다.
DB/MYSQL 2020. 2. 6. 16:45
mysql 접속(command line)

# mysql --user=aaaaaa --password db_name # mysql -u aaaaaa -p db_name # mysql -user=aaaaaa --password=password db_name # mysql -u aaaaaa -ppassword db_name -p 옵션을 사용할 경우 password는 p에 바로 붙여쓴다. -p와 password 사이에 공백이 없어야 함
DB/MYSQL 2020. 2. 6. 16:42
Installing MySQL on Linux

리눅스에서 MySQL 설치 리눅스 종류별로 설치할 수 있는 방법들이 설명되어 있다. Installing MySQL on Linux Using the MySQL Yum Repository Installing MySQL on Linux Using the MySQL APT Repository Installing MySQL on Linux Using the MySQL SLES Repository Installing MySQL on Linux Using RPM Packages from Oracle Installing MySQL on Linux Using Debian Packages from Oracle Deploying MySQL on Linux with Docker Installing MySQL on Linux..
DB/MYSQL 2020. 1. 11. 13:16
Could not find rpcgen

CMake Error at plugin/group_replication/libmysqlgcs/rpcgen.cmake:100 (MESSAGE): Could not find rpcgen Call Stack (most recent call first): plugin/group_replication/libmysqlgcs/CMakeLists.txt:38 (INCLUDE) 리눅스에서 MySQL을 설치하는 도중에 위와 같은 오류가 발생 #yum --enablerepo=PowerTools install rpcgen
DB/MYSQL 2020. 1. 10. 15:06
Package 'libtirpc', required by 'virtual:world', not found

-- Found PkgConfig: /usr/bin/pkg-config (found version "1.4.2") -- Checking for module 'libtirpc' -- Package 'libtirpc', required by 'virtual:world', not found CMake Error at cmake/rpc.cmake:65 (MESSAGE): Could not find rpc/rpc.h in /usr/include or /usr/include/tirpc Call Stack (most recent call first): plugin/group_replication/libmysqlgcs/configure.cmake:57 (MYSQL_CHECK_RPC) plugin/group_replic..
DB/MYSQL 2020. 1. 10. 15:03
Curses library not found. Please install appropriate package,

-- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH) CMake Error at cmake/readline.cmake:71 (MESSAGE): Curses library not found. Please install appropriate package, remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel. Call Stack (most recent call first): cmake/readline.cmake:100 (FIND_CURSES) cmake..
DB/MYSQL 2020. 1. 10. 15:02
Cannot find appropriate system libraries for WITH_SSL=system.

Cannot find appropriate system libraries for WITH_SSL=system. Make sure you have specified a supported SSL version. Valid options are : system (use the OS openssl library), yes (synonym for system), CMake Error at cmake/ssl.cmake:65 (MESSAGE): Please install the appropriate openssl developer package. Call Stack (most recent call first): cmake/ssl.cmake:293 (FATAL_SSL_NOT_FOUND_ERROR) CMakeLists...
DB/MYSQL 2020. 1. 10. 14:55
Prev 1 ··· 3 4 5 6 7 8 9 Next