mysql管理用户

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql管理用户，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含9594字，纯文字阅读大概需要14分钟。

内容图文

[root@ZAMPDMP-02 ~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2317

Server version: 5.6.30-log Source distribution

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> select user,host,password from mysql.user;

+---------+------------+-------------------------------------------+

| user | host | password |

+---------+------------+-------------------------------------------+

| root | localhost | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | zampdmp-02 | |

| root | 127.0.0.1 | |

| root | ::1 | |

| | localhost | |

| | zampdmp-02 | |

| hivedb | localhost | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| hivedb | % | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| root | % | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| etler | % | *8C377BBE4E13B4FA9AB2727937F3FEF047DB0AAF |

| exposer | % | *1B5955820D31F633B073D0A326801133A15DE967 |

+---------+------------+-------------------------------------------+

11 rows in set (0.00 sec)

mysql> select user,host,password from mysql.user where password=‘‘;

+------+------------+----------+

| user | host | password |

+------+------------+----------+

| root | zampdmp-02 | |

| root | 127.0.0.1 | |

| root | ::1 | |

| | localhost | |

| | zampdmp-02 | |

+------+------------+----------+

5 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘zampdmp-02‘ IDENTIFIED BY PASSWORD ‘*225AF6FA78393CB66A2CF30F85001B643546ED44‘ WITH GRANT OPTION

-> ;

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘127.0.0.1‘ IDENTIFIED BY PASSWORD ‘*225AF6FA78393CB66A2CF30F85001B643546ED44‘ WITH GRANT OPTION;

Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,password from mysql.user where password=‘‘;

+------+------------+----------+

| user | host | password |

+------+------------+----------+

| root | ::1 | |

| | localhost | |

| | zampdmp-02 | |

+------+------------+----------+

3 rows in set (0.00 sec)

mysql> select user,host,password from mysql.user;

+---------+------------+-------------------------------------------+

| user | host | password |

+---------+------------+-------------------------------------------+

| root | localhost | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | zampdmp-02 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | 127.0.0.1 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | ::1 | |

| | localhost | |

| | zampdmp-02 | |

| hivedb | localhost | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| hivedb | % | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| root | % | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| etler | % | *8C377BBE4E13B4FA9AB2727937F3FEF047DB0AAF |

| exposer | % | *1B5955820D31F633B073D0A326801133A15DE967 |

+---------+------------+-------------------------------------------+

11 rows in set (0.00 sec)

mysql> select user,host,password from mysql.user where password = ‘‘;

+------+------------+----------+

| user | host | password |

+------+------------+----------+

| root | ::1 | |

| | localhost | |

| | zampdmp-02 | |

+------+------------+----------+

3 rows in set (0.00 sec)

mysql> delete from mysql.user where password=‘‘;

Query OK, 3 rows affected (0.00 sec)

mysql> select user,host,password from mysql.user where password = ‘‘;

Empty set (0.00 sec)

mysql> select user,host,password from mysql.user;

+---------+------------+-------------------------------------------+

| user | host | password |

+---------+------------+-------------------------------------------+

| root | localhost | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | zampdmp-02 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | 127.0.0.1 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| hivedb | localhost | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| hivedb | % | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| root | % | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| etler | % | *8C377BBE4E13B4FA9AB2727937F3FEF047DB0AAF |

| exposer | % | *1B5955820D31F633B073D0A326801133A15DE967 |

+---------+------------+-------------------------------------------+

8 rows in set (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to ‘hivedb‘@‘zampdmp-02‘ identified by ‘*1F4A2E1E0471EC60934CC4896B8B03BC64E80B58‘ with grant options;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘options‘ at line 1

mysql> grant all privileges on *.* to ‘hivedb‘@‘zampdmp-02‘ identified by ‘*1F4A2E1E0471EC60934CC4896B8B03BC64E80B58‘ with grant option;

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> select user,host,password from mysql.user;

+---------+------------+-------------------------------------------+

| user | host | password |

+---------+------------+-------------------------------------------+

| root | localhost | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | zampdmp-02 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | 127.0.0.1 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| hivedb | zampdmp-02 | *9AE5587FACBA2EE66D40CE18BAC51361FD134B42 |

| hivedb | localhost | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| hivedb | % | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| root | % | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| etler | % | *8C377BBE4E13B4FA9AB2727937F3FEF047DB0AAF |

| exposer | % | *1B5955820D31F633B073D0A326801133A15DE967 |

+---------+------------+-------------------------------------------+

9 rows in set (0.00 sec)

mysql> grant all privileges on *.* to ‘hivedb‘@‘127.0.0.1‘ identified by ‘*1F4A2E1E0471EC60934CC4896B8B03BC64E80B58‘ with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,password from mysql.user;

+---------+------------+-------------------------------------------+

| user | host | password |

+---------+------------+-------------------------------------------+

| root | localhost | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | zampdmp-02 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | 127.0.0.1 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| hivedb | 127.0.0.1 | *9AE5587FACBA2EE66D40CE18BAC51361FD134B42 |

| hivedb | zampdmp-02 | *9AE5587FACBA2EE66D40CE18BAC51361FD134B42 |

| hivedb | localhost | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| hivedb | % | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| root | % | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| etler | % | *8C377BBE4E13B4FA9AB2727937F3FEF047DB0AAF |

| exposer | % | *1B5955820D31F633B073D0A326801133A15DE967 |

+---------+------------+-------------------------------------------+

10 rows in set (0.00 sec)

mysql> delete from mysql.user where user=root and host=zampdmp-02;

ERROR 1054 (42S22): Unknown column ‘root‘ in ‘where clause‘

mysql> delete from mysql.user where user=‘root‘ and host=‘zampdmp-02‘;

Query OK, 1 row affected (0.00 sec)

mysql> delete from mysql.user where user=‘hivedb‘ and host=‘zampdmp-02‘;

Query OK, 1 row affected (0.00 sec)

mysql> select user,host,password from mysql.user;

+---------+-----------+-------------------------------------------+

| user | host | password |

+---------+-----------+-------------------------------------------+

| root | localhost | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| root | 127.0.0.1 | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| hivedb | 127.0.0.1 | *9AE5587FACBA2EE66D40CE18BAC51361FD134B42 |

| hivedb | localhost | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| hivedb | % | *1F4A2E1E0471EC60934CC4896B8B03BC64E80B58 |

| root | % | *225AF6FA78393CB66A2CF30F85001B643546ED44 |

| etler | % | *8C377BBE4E13B4FA9AB2727937F3FEF047DB0AAF |

| exposer | % | *1B5955820D31F633B073D0A326801133A15DE967 |

+---------+-----------+-------------------------------------------+

8 rows in set (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

[root@ZAMPDMP-02 ~]# mysql -uroot -p -hzampdmp-02

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2336

Server version: 5.6.30-log Source distribution

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> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| david |

| elita |

| exp |

| hivedb |

| mysql |

| olap |

| performance_schema |

| pub |

| test |

| tmp |

+--------------------+

11 rows in set (0.00 sec)

mysql> use tmp

Database changed

mysql> show tables;

Empty set (0.00 sec)

mysql> use exp

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

+--------------------+

| Tables_in_exp |

+--------------------+

| export_segment_day |

| segment_status |

| segment_total |

| segment_trait |

+--------------------+

4 rows in set (0.00 sec)

本文出自 “梅花香自苦寒来！” 博客，请务必保留此出处http://daixuan.blog.51cto.com/5426657/1840383

原文：http://daixuan.blog.51cto.com/5426657/1840383

内容总结

以上是互联网集市为您收集整理的mysql管理用户全部内容，希望文章能够帮你解决mysql管理用户所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/1284635.html

来源：【匿名】

【上一篇】mysql:unknown variable 'default -collation=utf8_general_ci'【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【mysql管理用户】教程文章相关的互联网学习教程文章

[root@ZAMPDMP-02 ~]# mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2317Server version: 5.6.30-log Source distributionCopyright (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...

三：MySQL管理【代码】

一：MySQL用户管理MySQL中，用户是如何定义的？用户名@主机域才是一个用户root@'10.0.0.5%' 包含：50~59 单独 5 root@'10.0.0.%' root@'10.0.%' root@'10.%' root@'%' root@'10.0.0.0/255.255.255.0' #root@'10.0.0.0/24' 不可以1 添加用户1.创建用户并赋予密码 #create user username@'主机域' mysql> create user qls3@'localhost' identified by '123'; 2.授权 mysql> grant select on *.* to qls2@'%';#5.6 grant 一个不存在...

php-mysql管理利器 adminer【图】

简介：adminer类似于phpMyAdmin，用于MySQL管理客户端。整个程序只有一个PHP文件，易于使用和安装。Adminer支持多语言（已自带11种翻译语言文件，可以按自己的需求翻译相应的语言）。支持PHP4.3+，MySQL 4.1+以上的版本。Adminer KO phpMyAdmin: http://www.adminer.org/en/phpmyadmin/ E文的，就是为了取代phpMyAdmin而生下载地址：http://pan.baidu.com/s/1o6Jm9xo ，亦可去官网下载：http://www.adminer.org/使用方法：.将adm...

MySQL管理之道-笔记-MySQL5.7-在线调整innodb_buffer_pool_size不用重启mysql进程【代码】

在线调整innodb_buffer_pool_size不用重启mysql进程MySQL5.7以前，调整innodb_buffer_pool_size需要重启mysql进程才可以生效。建议业务低峰时间执行1 当前大小128Mroot@localhost:mysql3306.sock [(none)]>show variables like‘%innodb_buffer_pool_size%‘; +-------------------------+-----------+| Variable_name | Value |+-------------------------+-----------+| innodb_buffer_pool_size |134217728|+----...

MYSQL管理之主从同步管理

原文地址：MYSQL管理之主从同步管理作者：飞鸿无痕MYSQL管理之主从同步管理MYSQL主从同步架构是目前使用最多的数据库架构之一，尤其是负载比较大的网站，因此对于主从同步的管理也就显得非常重要，新手往往在出现主从同步错误的时候不知道如何入手，这篇文章就是根据自己的经验来详细叙述mysql主从的管理。MYSQL主从同步的作用(1) 数据分布(2) 负载平衡(load balancing)(3) 备份(4) 高可用性(high availability)和容错MYSQL主从同...

linux程序设计——MySQL管理（第八章）

8.2.2 创建用户并赋予权限作为MySQL管理员，最常见的工作就是维护用户信息——在MySQL中添加和删除用户并管理它们的权限。通过在MySQL控制台中使用grant和revoke命令来管理用户权限。1.grant命令 MySQL的grant命令几乎完全遵循SQL92的语法，它的常规格式是： grant <privilege> on <object> to <user> [identified by user-password] [with grant option]; 可以赋予的特权值如下所示：值说明 alter 改变表和索引...

mysql管理【代码】

一客户端工具1.1.1 命令行交互式客户端程序mysql选项:--print-default # 默认选项 --verbose # 现实详细信息 -u(USERNAME) # 用户名,默认为:root -h(HOST) # 服务器主机,默认为localhost -p(PASSWORD) # 用户的密码,建议使用-p,默认为空密码 1.1.2 mysql用户账号组成# mysql账号由两部分组成 ‘USERNAME‘@‘HOST‘# HoST用于限制此用户可以通过哪些远程主机连接mysql服务 # 支持使用通配符% 表示...

MySQL管理之日志详解

MySQL日志详解错误日志MySQL的错误信息是在data目录下的错误日志本身所定义的内容本身是可以定义的编辑配置文件，定义错误日志：log-error=/path/to/xx.err#定义|wpdb |+--------------------+12 rowsin set (0.01 sec)进入数据库查看表是否存在mysql>show tables;+-----------------+|Tables_in_test3 |+-----------------+|tb1 |+-----------------+1 rowin set (0.00 sec)查看数据是否存在mysql>sele...

MySQL管理之二进制日志文件的管理【图】

Mysql的二进制日志记录的是所有mysql数据库发生变更的信息，因此对数据库非常重要，mysql的二进制日志还是非常重要的，在日常工作 Mysql的二进制日志记录的是所有mysql数据库发生变更的信息，因此对数据库非常重要，二进制日志的作用我概括了一下主要包含如下几个方面： 1、可以用于数据库基于时间点的还原。 2、可以用来分析数据库发生更改的情况，比如程序的bug导致数据库数据更改等等。 3、二进制日志还可以用来重建数据库。从...

MySQL管理之SQL语句实例

MySQL管理之SQL语句实例首先，我们来导入world库，这个world库中的表是mysqlocp考试专用表，在网上有下mysqlsource/root/world_innodb.sql表结构如下：本文来自h delete 操作：删除添加的第一条记录，，也要考虑事务操作：begin;delete from wubx_1 where id=1;select * from wubx_1 where id=1;rollback |commit 以上，为MySQL的日常sql实例，感谢各位看官本文出自 “心情依旧” 博客，转载请与作者联系！

php_MySQL管理客户端adminer-2.3.2中文版

Adminer是一个类似于phpMyAdmin的MySQL管理客户端。整个程序只有一个PHP文件，易于使用和安装。Adminer支持多语言（已自带11种翻译语言文件，可以按自己的需求翻译相应的语言）。支持PHP4.3+，MySQL 4.1+以上的版本。提供的功能包括： 1：创建，修改，删除索引/外键/视图/存储过程和函数。 2：查询，合计，排序数据。 3：新增/修改/删除记录。 4：支持所有数据类型，包括大字段。 5：能够批量执行SQL语句。 6：支持将数据...

PHP使用MySQL管理Session的回调函数详解_PHP教程

代码如下: class MySession extends DBSQL { /** * __construct() */ public function __construct() { parent::__construct (); } /** * open() * * @param $sSavePath * @param $sSessionNames * * @return true */ public function open($sSavePath, $sSessionName) { return true; } /** * close() */ public function close() { return true; } /** * read() * * @param $...

PHP使用MySQL管理Session的回调函数详解_php技巧

PHP 使用MySQL管理Session的回调函数详解

代码如下:<?php class MySession extends DBSQL { /** * __construct() */ public function __construct() { parent::__construct (); } /** * open() * * @param <String> $sSavePath * @param <String>$sSessionNames * * @return <Boolean> true */ public function open($sSavePath, $sSessionName) { return true; } /** * close() */ public function close() { return true; } /**...

MySQL 管理【代码】

启动及关闭 MySQL 服务器首先，我们需要通过以下命令来检查MySQL服务器是否启动： ps -ef | grep mysqld 如果MySql已经启动，以上命令将输出mysql进程列表，如果mysql未启动，你可以使用以下命令来启动mysql服务器: root@host# cd /usr/bin ./safe_mysqld & 如果你想关闭目前运行的 MySQL 服务器, 你可以执行以下命令: root@host# cd /usr/bin ./mysqladmin -u root -p shutdown Enter password: ******MySQL 用户设置如果你需要...

首页 / MYSQL / mysql管理用户

mysql管理用户

内容导读

内容图文

内容总结

内容备注

内容手机端

【mysql管理用户】教程文章相关的互联网学习教程文章