Jcat
          寵辱不驚,閑看庭前花開花落~~
          posts - 173,comments - 67,trackbacks - 0
          重裝完系統,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 mysql
          Database 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 閱讀(937) 評論(1)  編輯  收藏 所屬分類: Database

          FeedBack:
          # re: 啟動綠色版MYSQL
          2011-06-16 01:44 | sure_dandan
          霸霸!  回復  更多評論
            
          主站蜘蛛池模板: 阳江市| 望都县| 安远县| 余姚市| 定西市| 彭水| 澎湖县| 沙湾县| 象州县| 荥经县| 大渡口区| 慈利县| 无棣县| 洛浦县| 津市市| 陵川县| 华坪县| 永新县| 长阳| 沽源县| 郴州市| 普定县| 木里| 黑河市| 团风县| 洱源县| 定日县| 久治县| 西青区| 于田县| 股票| 嘉义县| 三都| 商南县| 华坪县| 铜鼓县| 南通市| 社会| 得荣县| 沂水县| 嘉义市|