欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  科技

如何在win2000下安装mysql

程序员文章站 2023-11-25 17:51:16
如何在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 ---