欢迎来到电脑知识学习网,专业的电脑知识大全学习平台!

手机版

在win2000下安装mysql 的方法

操作系统 发布时间:2019-02-17 21:58:40

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


责任编辑:电脑知识学习网

操作系统