重裝完系統,mysql不需要重裝,直接當綠色版使用,還更干凈
//啟動MYSQL
cd $MYSQL_HOME/bin
D:\JAVA\MYSQL\mysql-5.1.53-win32\bin>
mysqld --console??????
110616? 1:26:26 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110616? 1:26:26? InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110616? 1:26:26? InnoDB: Started; log sequence number 0 44233
110616? 1:26:27 [Note] Event Scheduler: Loaded 0 events
110616? 1:26:27 [Note] mysqld: ready for connections.
Version: '5.1.53-community'? socket: ''? port: 3306? MySQL Community Server (GPL
)
//簡單使用mysql>
show databases;
+--------------------+
| Database?????????? |
+--------------------+
| information_schema |
| mysql????????????? |
| test?????????????? |
+--------------------+
3 rows in set (0.03 sec)
mysql>
use mysqlDatabase changed
mysql>
show tables;+---------------------------+
| Tables_in_mysql?????????? |
+---------------------------+
| columns_priv????????????? |
| db??????????????????????? |
| event???????????????????? |
| func????????????????????? |
| general_log?????????????? |
| help_category???????????? |
| help_keyword????????????? |
| help_relation???????????? |
| help_topic??????????????? |
| host????????????????????? |
| ndb_binlog_index????????? |
登陸D:\JAVA\MYSQL\mysql-5.1.53-win32\bin>mysql.exe -uroot
創建數據庫mysql> create database testdb;
posted on 2011-06-16 01:40
Jcat 閱讀(932)
評論(1) 編輯 收藏 所屬分類:
Database