半根烟 发表于 2010-8-16 11:04:19

如何在win2000下安装mysql

安装选默认目录就可以了 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 ---



----------------------------------------------
雨湿了我的头发,我用手轻轻拨弄了一下。
心情是那么的舒畅,在雨中我找回了真实的自己。漫步于雨中,是我最好的消遣寂寞方法。
我能想到最浪漫的事,就是和你一起慢慢变老。
页: [1]
查看完整版本: 如何在win2000下安装mysql

请大家牢记南瓜园网址 www.nan2008.com