Windows XP Windows 7 Windows 2003 Windows Vista Windows教程綜合 Linux 系統教程
Windows 10 Windows 8 Windows 2008 Windows NT Windows Server 電腦軟件教程
 Windows教程網 >> Windows Server系統教程 >> Server 2000 >> 在win2000下安裝mysql 的方法

在win2000下安裝mysql 的方法

日期:2017/2/10 9:32:23      編輯:Server 2000

安裝選默認目錄就可以了 c:\mysql
   把 c:\mysql\my-example.cnf copy 為 c:\my.cnf

   要修改的自己去看看吧,很簡單的    把 c:\mysql\libcygwinb19.dll copy 到 winnt\system32    啟動 mysql    c:\mysql\bin\mysqld-shareware --install
   net start mysql    啟動啦    更改 root 的 password    C:\mysql\bin\mysql mysql
   mysql> UPDATE user SET password=PASSWORD('your password') WHERE user='root';
   mysql> QUIT
   C:\mysql\bin\mysql\admin reload    去看看行了沒有?
   C:\mysql\bin\mysqlshow    在這裡應該顯示:    +-----------+
   Databases
   +-----------+
   +-----------+
   mysql 
   Databases
   +-----------+
   mysql  
   test   
   +-----------+    看到這些信息這一步就OK了
   再來:
   C:\mysql\bin\mysqlshow --user=root --password=your password mysql    在這裡應該顯示:    Database: mysql
   +--------------+
   Database: mysql
   +--------------+
    Tables   
   +--------------+
   columns_priv
   db     
   host    
   tables_priv 
   user    
   +--------------+    看見就行了。    C:\mysql\bin\mysqladmin version status proc    沒有問題就應該可以看到這些信息:    mysqladmin mysqladmin  Ver 8.0 Distrib 3.22.32, for Win95/Win98 on i586
   TCX Datakonsult AB, by Monty    Server version          3.22.32-shareware-debug
   Protocol version        10
   Connection            localhost via TCP/IP
   TCP port localhost via TCP/IP
   TCP port                3306
   Uptime:                 1 hour 29 min 30 sec    Threads: 1  Questions: 72  Slow queries: 0  Opens: 16  Flush tables: 1  Open tables: 0  Memory in use:    16423K  Max memory used: 16490K
   Uptime: 5370Threads: 1 Threads: 1  Questions: 72  Slow queries: 0  Opens: 16  Flush tables: 1  Open tables: 0  Memory in use: 16423K  Max memory used: 16490K    +----+------+-----------+----+---------+------+-------+------------------+
   Id User Host    db Command Ti State Info  State Info
   +----+------+-----------+----+---------+------+-------+------------------+
   35 ODBC localhost    Query  0       show processlist
   +----+------+-----------+----+---------+------+-------+-----------------    接著,用show databases命令可以將安裝的數據庫列出來:    mysql> show databases;    你就可以看到:    +----------+    Database    +----------+    mysql ---    test ---   ----------------------------------------------
 
Copyright © Windows教程網 All Rights Reserved