MySQL cheatsheet

Login MySQL CMD

mysql -u root -p

Show Databases;

cek user dan database nya

SELECT 
    User, 
    Host, 
    Db AS Database_Name
FROM mysql.db
WHERE User NOT IN ('root', 'mysql.sys', 'mysql.session', 'mysql.infoschema')
ORDER BY Db, User;

copy file ke linux dari windows

scp "DatabaseScripts\weighbridge_v5_schema.sql" username@IP_SERVER_LINUX:~

show port MySQL

SHOW VARIABLES LIKE 'port';