查看 MariaDB & MySQL 用户使用的插件
# select user,plugin from mysql.user;
查看 MariaDB & MySQL 用户使用的插件
# select user,plugin from mysql.user;
mysql> create user 'mingyuzhu'@'192.168.%' identified by 'mypassword';
(补充:这里以创建用户 mingyuzhu@192.168.% 并且把密码设置成 mypassword 为例)
mysql> alter user 'mingyuzhu'@'192.168.%' password expire interval 90 day;
(补充:这里以将用户 mingyuzhu@192.168.% 密码的有效期设置为 90 天为例)
mysql> grant select,insert,update,delete,drop,create on eternalcenter.* to 'mingyuzhu'@'192.168.%';
(补充:这里以给用户 mingyuzhu@192.168.% 库 eternalcenter 增、删、改、查的权限为例)
mysql> flush privileges;
mysql> drop user 'mingyuzhu'@'192.168.%';
(补充:这里以删除用户 mingyuzhu@192.168.% 为例)
mysql> \s
或者:
mysql> \status
或者:
mysql> SHOW VARIABLES WHERE Variable_name LIKE "version";
mysql> quit;
或者:
mysql> exit;
mysql> select * from my_table LIMIT 10;
(补充:这里以查看 my_table 表为例)
mysql> select * from my_table LIMIT 10 OFFSET 10;
(补充:这里以查看 my_table 表为例)
> SELECT user, host, password_lifetime,password_last_changed from mysql.user where password_lifetime is NULL;
> SELECT user, host, password_lifetime,password_last_changed from mysql.user;
https://dev.mysql.com/downloads/mysql
选择想要下载的版本
Linux – Generic
Linux – Generic (glibc 2.17)(x86, 64-bit)
Compressed TAR Archive, Minimal Install