개인적인 정리

mysql 접속(command line) 본문

DB/MYSQL

mysql 접속(command line)

yeon.Biju 2020. 2. 6. 16:42

 

# 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' 카테고리의 다른 글

Unable to load authentication plugin 'caching_sha2_password'  (0) 2020.02.07
Can't connect to local MySQL server through socket  (0) 2020.02.07
mysql 사용자 명 글자 수  (0) 2020.02.06
mysql.user table 설명  (0) 2020.02.06
Installing MySQL on Linux  (0) 2020.01.11
Could not find rpcgen  (0) 2020.01.10
Package 'libtirpc', required by 'virtual:world', not found  (0) 2020.01.10
Curses library not found. Please install appropriate package,  (0) 2020.01.10
'DB/MYSQL' Related Articles more
Comments