重装完系统,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 阅读(917)
评论(1) 编辑 收藏 所属分类:
Database