리눅스 분류
MySQL 에러입니다 ㅠㅠ
작성자 정보
- 오영국 작성
- 작성일
컨텐츠 정보
- 2,019 조회
- 1 댓글
- 0 추천
- 목록
본문
[root@localhost ~]# mysqld_safe --skip-grant-tables &
[1] 3577
[root@localhost ~]# Starting mysqld daemon with databases from /usr/local/mysql/data
[root@localhost ~]# mysql -u root -p mysql -S /var/lib/mysql/mysql.sock
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 5.0.21
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show table;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
17 rows in set (0.00 sec)
mysql> exit
Bye
[root@localhost ~]# su
[root@localhost ~]# killall mysql
mysql: no process killed
[root@localhost ~]# killall mysqld
[root@localhost ~]# STOPPING server from pid file /usr/local/mysql/data/mysql.pid
090120 15:37:54 mysqld ended
[root@localhost ~]# /usr/local/mysql/bin/mysqld_safe &
[1] 3644
[root@localhost ~]# Starting mysqld daemon with databases from /usr/local/mysql/data
[root@localhost ~]# /usr/local/mysql/share/mysql/mysql.server start
Starting MySQL................................... [실패]
[root@localhost ~]#
[1] 3577
[root@localhost ~]# Starting mysqld daemon with databases from /usr/local/mysql/data
[root@localhost ~]# mysql -u root -p mysql -S /var/lib/mysql/mysql.sock
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 5.0.21
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show table;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
17 rows in set (0.00 sec)
mysql> exit
Bye
[root@localhost ~]# su
[root@localhost ~]# killall mysql
mysql: no process killed
[root@localhost ~]# killall mysqld
[root@localhost ~]# STOPPING server from pid file /usr/local/mysql/data/mysql.pid
090120 15:37:54 mysqld ended
[root@localhost ~]# /usr/local/mysql/bin/mysqld_safe &
[1] 3644
[root@localhost ~]# Starting mysqld daemon with databases from /usr/local/mysql/data
[root@localhost ~]# /usr/local/mysql/share/mysql/mysql.server start
Starting MySQL................................... [실패]
[root@localhost ~]#
------------------------------------------------------------------------------------------
현재 페도라 코어 5버전 에서 MySQL-5.0.22 버전을 소스 컴파일로 설치하였습니다.
무슨 문제인지 모르겠습니다 ㅠㅠ 가르쳐주세요..
관련자료
-
이전
-
다음
댓글 1
suki님의 댓글
- suki
- 작성일
/usr/local/mysql/bin/mysqld_safe &와 /usr/local/mysql/share/mysql/mysql.server start 둘다 mysql을 스타트 시키는 명령입니다 .