MYSQL常用命令

 mysqladmin -u root password 123456

update user set password=PASSWORD("123456") where user='root';
    FLUSH PRIVILEGES;

create database zabbix character set utf8;
grant all privileges on zabbix.* to zabbix@localhost identified by 'password';
# zabbix.*将权限限制在只读库

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
#*.*涵盖所有库和表；登录账号root，远程地址 %；指定密码123456 ；WITH GRANT OPTION 具有授予权限的能力

update user set host = '%' where user = 'root';

mysqladmin -u root password 123456

pkill  mysql
mysqld_safe --skip-grant-tables &

[mysqld]
skip-grant-tables
#重启服务

use mysql
#进入数据库
show tables;
#看看表名
desc user;
#看看表结构

+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field                  | Type                              | Null | Key | Default               | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host                   | char(60)                          | NO   | PRI |                       |       |
| User                   | char(16)                          | NO   | PRI |                       |       |
| Password               | char(41)                          | NO   |     |                       |       |
| Select_priv            | enum('N','Y')                     | NO   |     | N                     |       |

+------------------+------+----------+
| host             | user | password |
+------------------+------+----------+
| localhost        | root |          |
| www.to-share.net | root |          |
| 127.0.0.1        | root |          |
+------------------+------+----------+

+------------------+------+
| host             | user |
+------------------+------+
| 127.0.0.1        | root |
| localhost        | root |
| www.to-share.net | root |
+------------------+------+

SELECT
    COUNT(1) AS countNumber,
    DATE_FORMAT(gmt_modify,'%Y-%m-%d') AS dateTime
FROM
    recognize_log_all
GROUP BY DATE_FORMAT(gmt_modify,'%Y-%m-%d')

delete from jasset_asset