Red Hat NETSCAPE MANAGEMENT SYSTEM 6.0 - COMMAND-LINE Manuel d'utilisateur télécharger pdf (Page 24)

MYSQL

Open mysql command line

from same server

mysql –uuser –ppassword

i.e. mysql –uroot –pwopnam

Open mysql command line

from remote server

mysql –uuser –ppassword –hip_address database_name

i.e mysql –uroot –pwopnam –h207.169.53.5 snort

Connect to database

connect database_name

i.e. connect snort

Query table names

show tables;

Query columns from a table

show columns from table_name;

i.e show columns from acid_event;

Query the most recent data

(field) in a column

select max(field) from table_name;

i.e. select max(timestamp) from acid_event

Misc.

show databases

use database_name

show tables

show grants for user@localhost

Backup Database

mysqldump –u root –p --opt database_name > /path/filename.sql

For example:

mysqldump –u root –p --opt snort > /root/snort.sql

Restore Database

mysql –u root –p database_name < /path/filename.sql

For example:

mysql –u root –p snort < /root/snort.sql

MISC Stuff

revoke all privileges on pec.* from matt@'%';

GRANT CREATE, INSERT, SELECT, UPDATE ON pec.* TO

change_user@localhost IDENTIFIED BY 'password';

flush privileges;

mysql -u changes –p

USE mysql

SELECT user,host FROM user;

DELETE FROM user WHERE user=””;

CONNECT pec;

SHOW TABLES;

SELECT * FROM table_name;

SHOW COLUMNS FROM table_name;

SELECT MAX(date_opened) FROM changes;

SHOW GRANTS FOR matt@’%’;

SHOW GRANTS FOR matt@localhost;

ALTER TABLE `table_name` DROP `field_name`;

1 2 ... 19 20 21 22 23 24 25 26 27 28 29 ... 59 60

Commentaires sur ces manuels

Pas de commentaire

Red Hat NETSCAPE MANAGEMENT SYSTEM 6.0 - COMMAND-LINE Manuel d'utilisateur Page 24

Commentaires sur ces manuels