db

use zabbix;
update zabbix.users set passwd=md5('newpass') where alias='Admin';

MariaDB> CREATE DATABASE database_name;
MariaDB> CREATE USER 'cactiuser'@'localhost' IDENTIFIED BY 'cactipassword';
MariaDB> GRANT ALL PRIVILEGES ON cactidb.* TO 'cactiuser'@'localhost';
MariaDB> FLUSH PRIVILEGES;

update user_auth set password=md5('admin') where username='admin';

update users set passwd = md5('newpassword') where alias = "username";

select lastdate, lastcome from hardware where lastdate like '2016%' and lastcome like '2016%';


select name, userid, lastdate, lastcome from hardware where ipaddr like '10.1.56.121' and lastdate like '2016-09%'\G;

select USERID from hardware where ipaddr like '10.1.56.121' and lastdate like '2016-09%'\G;

select lastdate, lastcome from hardware where ipaddr like '10.1.56.121' and lastdate like '2016-09%'\G;


-> \c

select 1+1;

SELECT VERSION(); SELECT NOW();


select SSN, SMANUFACTURER, NAME, IPADDR from hardware a join bios  where SSN not like 'VMware%' and WORKGROUP like 'ux.com' and LASTDATE like '2016%';

select SMANUFACTURER, TYPE from bios order by SMANUFACTURER

rows in set, 1 warning
show warning;

select * from bios where TYPE not like '%Notebook%' and TYPE not like '%Desktop%'\G;

not REGEXP 'Notebook|Laptop|COMPATIBLE'
select * from hardware a left join bios b on a.ID=b.HARDWARE_ID where a.ID=1941 \G;
select SSN, SMANUFACTURER from bios where SSN  not like 'VMware%';
select NAME, IPADDR, LASTDATE from hardware where WORKGROUP  like 'ux.com' and LASTDATE like '2016%' ;

select SSN, BDATE from bios;
describe bios;
select DISTINCT  SSN   FROM bios: uniq


mysqldump ............ ocsweb --lock-tables=false -T 10.1.24.128:/tmp/test.csv



主檔hardware 其他child table的foreign key 為hardware_id

show create table hardware: 這可查他的table欄位type 與大小
mysql -u root -p

select * from bios where  TYPE not REGEXP 'Desktop|Notebook|Laptop|COMPATIBLE|Other|Portable' \G;

mysql> show databases;
show tables;   # ???
select host from mysql.user;
 desc mysql.user;

 yum install -y mariadb-server.x86_64
services mysql start
mysql_secure_installation