数据库都会有两种方式来管理:命令行和图形化界面
命令行方式如下:
[img]http://dl2.iteye.com/upload/attachment/0086/0911/91993ac5-81e3-32da-ae7c-07f2afc5336a.jpg[/img]
图形化界面方式如下:
[img]http://dl2.iteye.com/upload/attachment/0086/0913/5904e6e2-2ef5-3bbd-bb25-318e965602cf.jpg[/img]
在图形化界面下创建用户、数据库和表很简单,下面就用命令行方式来创建用户、数据库和表
创建用户:
(这里指定了创建数据库的权限)
[img]http://dl2.iteye.com/upload/attachment/0086/0915/2a9c4f5d-5e26-329b-bcda-c598fc93eddd.jpg[/img]
创建数据库:
[img]http://dl2.iteye.com/upload/attachment/0086/0917/a38f9eb5-382a-310f-b10d-8fb9fb55da59.jpg[/img]
创建表:
[img]http://dl2.iteye.com/upload/attachment/0086/0917/a38f9eb5-382a-310f-b10d-8fb9fb55da59.jpg[/img]
插入和查询数据:
[img]http://dl2.iteye.com/upload/attachment/0086/0921/fe08d4b4-8ba7-33bc-8772-a3a35ce3c8b7.jpg[/img]
命令行方式如下:
[img]http://dl2.iteye.com/upload/attachment/0086/0911/91993ac5-81e3-32da-ae7c-07f2afc5336a.jpg[/img]
图形化界面方式如下:
[img]http://dl2.iteye.com/upload/attachment/0086/0913/5904e6e2-2ef5-3bbd-bb25-318e965602cf.jpg[/img]
在图形化界面下创建用户、数据库和表很简单,下面就用命令行方式来创建用户、数据库和表
创建用户:
(这里指定了创建数据库的权限)
[img]http://dl2.iteye.com/upload/attachment/0086/0915/2a9c4f5d-5e26-329b-bcda-c598fc93eddd.jpg[/img]
创建数据库:
[img]http://dl2.iteye.com/upload/attachment/0086/0917/a38f9eb5-382a-310f-b10d-8fb9fb55da59.jpg[/img]
创建表:
[img]http://dl2.iteye.com/upload/attachment/0086/0917/a38f9eb5-382a-310f-b10d-8fb9fb55da59.jpg[/img]
插入和查询数据:
[img]http://dl2.iteye.com/upload/attachment/0086/0921/fe08d4b4-8ba7-33bc-8772-a3a35ce3c8b7.jpg[/img]