mysql - playmakermz/warkop-website GitHub Wiki

Install mysql

sudo pacman -S mysql
mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Aktifkan mysql

sudo sysmtemctl enable --now mariadb

Account

sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('root');

password adalah 'root'

wiki contoh sql

• https://lms.onnocenter.or.id/wiki/index.php/Sql

pranala menarik:

1. https://www.sqlshack.com/how-to-backup-and-restore-mysql-databases-using-the-mysqldump-command/
2. https://blog.cpanel.com/how-to-back-up-and-restore-mysql-databases-in-cpanel/
3. https://www.tutorialspoint.com/sql/sql-data-types.htm

• https://stackoverflow.com/questions/69935085/mysql-mariadb-cant-open-and-lock-privilege-tables-table-mysql-servers-doesn
• https://dfar.io/setting-up-sql-server-in-arch-linux/
• https://dfar.io/setting-up-sql-server-in-arch-linux/
• https://stackoverflow.com/questions/41645309/mysql-error-access-denied-for-user-rootlocalhost
• https://stackoverflow.com/questions/31820750/run-sql-file-in-database-from-terminal/31820850
• https://linuxize.com/post/how-to-show-databases-in-mysql/