Linux Basic Commands

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

1. Login to MySQL.

sudo mysql -u root -p

2. Show all MySQL Database.

show databases;

3. To use database.

use [database name];

4. Show all table in selected database.

show tables;

5. Show all MySQL User.

select user, password, host from mysql.user;

6. Show grants MySQL User.

show grants for 'exampleuser'@'localhost';

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.