MySQL下查看用户、建立用户、删除用户
来源:互联网 发布:ubuntu 挂载vmdk 编辑:程序博客网 时间:2024/05/21 03:58
启动数据库:
[root@server ~]# mysqld_safe &[1] 3289[root@server ~]# 130913 08:19:58 mysqld_safe Logging to '/usr/local/mysql/data/server.gao.err'.130913 08:19:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
连接到数据库:
[root@server ~]# mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.6.13 MySQL Community Server (GPL)Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
查看数据库列表:
mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test |+--------------------+4 rows in set (0.00 sec)mysql>
查看用户状态:
mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select host,user from mysql.user;+------------+------+| host | user |+------------+------+| 127.0.0.1 | root || ::1 | root || localhost | || localhost | root || server.gao | || server.gao | root |+------------+------+6 rows in set (0.00 sec)mysql>
创建用户:
mysql> create user 'usrabc'@'%' identified by 'usrabc';Query OK, 0 rows affected (0.00 sec)mysql> select host,user from mysql.user;+------------+--------+| host | user |+------------+--------+| % | usrabc || 127.0.0.1 | root || ::1 | root || localhost | || localhost | root || server.gao | || server.gao | root |+------------+--------+7 rows in set (0.00 sec)mysql>
阅读全文
1 0
- MySQL下查看用户、建立用户、删除用户
- MySQL下查看用户和建立用户
- MYSQL的创建用户,授权用户,删除用户,查看用户
- MySQL如何查看,删除用户
- 用户建立和删除
- MYSQL创建、授权、撤销、查看、删除用户
- Mysql 创建用户、删除用户
- mysql新增用户,用户授权,删除用户
- Mysql 建立用户数据库
- MySQL下查看数据库的用户
- Mysql(用户相关命令)查看所有用户及权限、删除创建用户等命令
- MySQL学习之:用户管理(添加用户,删除用户,添加权限,查看权限,密码等)
- MySQL查看当前用户
- MySQL 查看所有用户
- mysql查看当前用户
- MySQL 删除匿名用户
- Mysql创建、删除用户
- Mysql创建、删除用户
- Linux笔记之shell脚本4:条件语句
- 类别
- C++---------【多态性】之【静态多态性】
- Error:Execution failed for task ':app:processDebugManifest'. > Manifest merger failed with multiple
- 打程序应注意的一个问题
- MySQL下查看用户、建立用户、删除用户
- 安卓 UI 设计
- 如何编写一个带模糊查询的存储过程
- [离线+树状数组] HDU5869 Different GCD Subarray Query
- 返回数组中两个元素的最新距离
- HashMap的底层实现
- python中使用pickle进行序列化
- 不可将两个浮点数 直接做 相等比较判断
- Maven重要的配置项