如何在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 ---
把 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 ---
推荐阅读
-
Mac 下 MySQL5.7.22的安装过程
-
MySql 5.7.21免安装版本win10下的配置方法
-
win10下mysql 8.0.11 压缩版安装教程
-
win10 下安装mysql服务器社区版本mysql 5.7.22 winx64的图文教程
-
Windows下MySQL8.0.11社区绿色版安装步骤图解
-
Windows下mysql 8.0.11 安装教程
-
CentOS7下mysql 8.0.16 安装配置方法图文教程
-
windows下mysql 8.0.16 安装配置方法图文教程
-
win10下mysql 8.0.16 winx64安装图文最新教程
-
win10下mysql 8.0.16 winx64安装配置方法图文教程