Oracle 数据库用户管理
作者:网络转载 发布时间:[ 2014/3/5 10:30:07 ] 推荐标签:数据库 Oracle
命令行进入mysql:
首先确认环境变量里面有如下配置:C:Program FilesMySQLMySQL Server 5.5in
才能在进入黑窗口直接适用mysql命令,否则需要在黑窗口进入mysql的bin目录在执行mysql命令.
使用 root 和123456登陆:
C:Documents and SettingsAdministrator>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 25
Server version: 5.5.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql>
===========================================================
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| dmp |
| hdmp |
| hms |
| mysql |
| ods_produce |
| performance_schema |
| test |
| wms |
+--------------------+
9 rows in set (0.02 sec)
mysql> use mysql;
Database changed
mysql> update user set password=PASSWORD("123456") WHERE user='root'
mysql> FLUSH PRIVILEGES;
mysql> QUIT
======================================================
mysql数据库文件默认存放路径:C:Documents and SettingsAll UsersApplication DataMySQLMySQL Server 5.5data

sales@spasvo.com