1.Window2000下的安装. A.安装目录最好(应该是一定要)是C:\, 以前有几次没看清楚说明,安装在D盘,结果启动不了。 B.安装成为启动服务:mysqld-nt --install 卸载服务:mysqld-nt --uninstall 移除服务:mysqld-nt --remove 启动服务:net start mysql 停止服务:net stop mysql
2.连接以及用户的管理 A.连接MySql数据库: mysql -h host -u user -p 比如用root登陆: mysql -h localhost -uroot -p B.断开连接:quit或exit C.新建用户(用户名为tom,密码为123): 用root连接到数据库,然后用以下的命令: grant all privileges on *.* to ''''tom''''@''''localhost'''' identified by ''''123'''' with grant option; 或grant all privileges on *.* to ''''tom''''@''''%'''' identified by ''''123'''' with grant option; 或insert into user values(''''localhost'''',''''tom'''',password(''''123''''),''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''',''''Y'''');