Linux Basic Commands


Ini adalah senarai beberapa command asas untuk terminal Linux. Bagi command asas Raspberry Pi boleh rujuk Raspberry Pi Basic Commands.

List of currently installed cron jobs crontab -l
To add/modify/delete a job run crontab -e
Login to MySQL sudo mysql -u root -p
Show all MySQL Database show databases;
To use database use database_name
Show all table in selected database show tables;
Show all MySQL User select user, password, host from mysql.user;
Show grants MySQL User show grants for ‘example_user’@’localhost’;
Create a new database in MySQL create database database_name;
Create a new MySQL user create user ‘example_user’@’localhost’ identified by ‘example_password’;
Grant all privileges to a MySQL user grant all privileges on example_database.* to ‘example_user’@’localhost’;
Revoke all privileges to a MySQL user revoke all privileges on example_database.* from ‘example_user’@’localhost’;


Leave a Reply

Your email address will not be published. Required fields are marked *