랩제이

[mysql] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 1. root 암호 설정 - 먼저 mysqld_safe로 접속 가능하게 한다./usr/bin/mysqld_safe --skip-grant-tables & - mysql에 접속한다.mysql -u root mysql - 암호 설정한다.mysql> update mysql.user SET authentication_string=PASSWORD('password!') WHERE user='root';Query OK, 1 row affected, 1 warning (0.00 sec)Rows matched: 1 Changed: 1 Warnings: 1 m..

[mysql] root 암호 바꾸기, 외부 접근하기 mysql> mysql> use mysql; Database changed mysql> update user set password=password('!password') where user='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 3 Changed: 0 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on *.* to 'root'@'%' identified by '!password'; Query OK, 0 rows affected (0.00 sec) mys..