MARIADB
포스트: 10|조회수: 0|TERM
Posts
10 postsMariaDB 접속 에러
[ DB접속 시 발생하는 에러(1) ]# mysql -uroot -h127.0.0.1 -p mysqlEnter password:ERROR 1275 (HY000): Server is running in --secure-auth mode, but 'root'@'127.0.0.1' has a password in the old format; please change the password to the new format# [ 조치 방법(1) ]MariaDB [mysql]> show variables like 'old_passwords';+---------------+-------+| Variable_name | Value |+---------------+-------+| old_passwords | O
MariaDB 비밀번호 강제 초기화
MariDB root 비밀번호 강제 재설정 # service mysql stop# /usr/bin/mysqld_safe --skip-grant-tables &# mysql -uroot mysqlMariaDB [mysql]> update user set password=PASSWORD("새로운비밀번호") where User='root';MariaDB [mysql]> flush privileges; # service mysql restart
