개인적인 정리

# 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 사이에 공백이 없어야 함

리눅스에서 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..

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

-- 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..

-- 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..

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...

-- The C compiler identification is unknown -- The CXX compiler identification is unknown CMake Error at CMakeLists.txt:311 (PROJECT): No CMAKE_C_COMPILER could be found. Tell CMake where to find the compiler by setting either the environment variable "CC" or the CMake cache entry CMAKE_C_COMPILER to the full path to the compiler, or to the compiler name if it is in the PATH. 리눅스에서 MySQL 설치시 위와 ..

-- Running cmake version 3.11.4 -- Found Git: /usr/bin/git (found version "2.18.1") -- MySQL 8.0.18 CMake Error: CMake was unable to find a build program corresponding to "Unix Makefiles". CMAKE_MAKE_PROGRAM is not set. You probably need to select a different build tool. CMake Error: CMAKE_C_COMPILER not set, after EnableLanguage CMake Error: CMAKE_CXX_COMPILER not set, after EnableLanguage -- C..