이렇게 저렇게 많이 찾아보고 간신히 mysql은 설치가 됐습니다.
근데 원래는 잘 설치되었었거든요. 근데 한번 안되니까 계속 안되네요.
좀 보시고 답답한 마음좀 달래주세요..
# ls /tmp
OraInstall install-step2.log install.log kfm-cache-0
분명히 없죠.. 보시면 알겠지만..
#./mysqladmin -u root -p start
Enter password:
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
# ls /var/run/mysql*
/var/run/mysqld.pid
분명히 생겼잖아요, 근데 왜 안되지.. 하여튼 그래서 safe_차례
# rm -f /var/run/mysqld.pid
# ./safe_mysqld &
[1] 685
# Starting mysqld daemon with databases from /home/mysql/data
환장하겠어요. 보시면 아시다시피 잘떠요..
# ./mysqladmin -u root -p version
Enter password:
./mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.22.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 min 28 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2
# ./mysqladmin -u root -p variables
Enter password:
+----------------------------+--------------------------------+
| Variable_name | Value |
+----------------------------+--------------------------------+
| back_log | 5 |
| connect_timeout | 5 |
| basedir | /home/mysql/ |
| datadir | /home/mysql/data/ |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| join_buffer | 131072 |
| flush_time | 0 |
| key_buffer | 8388600 |
| language | /home/mysql/msg/mysql/english/ |
| log | OFF |
| log_update | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| max_allowed_packet | 1048576 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_insert_threads | 20 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_write_lock_count | 4294967295 |
| net_buffer_length | 16384 |
| pid_file | /home/mysql/data/board.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 131072 |
| skip_locking | ON |
| skip_networking | OFF |
| socket | /tmp/mysql.sock |
| sort_buffer | 2097144 |
| table_cache | 64 |
| thread_stack | 65536 |
| tmp_table_size | 1048576 |
| tmpdir | /tmp/ |
| version | 3.22.32 |
| wait_timeout | 28800 |
+----------------------------+--------------------------------+
봐요..미친다니까요..
질문1)이런건 왜그런거죠? 어떻게 하면 정상적으로 작동가능할까요?
질문2)제가 mysql을 잘 몰라서 그러는데 safe_mysqld와 mysqld는 어떻게 다른가요? 아시는데로 가르쳐 주시면 감사하겠습니다.
|