Database relasional mengatur data dalam tabel. Tabel memiliki baris (atau catatan) dan kolom (atau bidang). Tabel terkait berdasarkan kolom umum untuk menghilangkan redundansi data dan memastikan integritas data Show
Sistem Manajemen Basis Data Hubungan Populer (RDBMS) termasuk
Struktur Query Language (SQL)Bahasa pemrograman tingkat tinggi, yang disebut Structure Query Language (SQL), dirancang untuk berinteraksi dengan database relasional. SQL mendefinisikan sekumpulan perintah, seperti // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx6, // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx7, // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx8, // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx9, -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)0, -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)1, dan lain-lain Edgar F. Codd dari IBM mengusulkan Model Basis Data Relasional pada tahun 1970. SQL, salah satu bahasa pemrograman awal, kemudian dikembangkan oleh Donald D. Chamberlin dan Raymond F. Boyce di IBM pada awal 1970-an. Oracle, kemudian, membawanya ke ketinggian baru ANSI (American National Standard Institute) menetapkan standar SQL pertama pada tahun 1986 (SQL-86 atau SQL-87) - diadopsi oleh ISO/IEC sebagai "ISO/IEC 9075" - diikuti pada tahun 1989 (SQL-89), 1992 (SQL- . 2003), 2006 (SQL. 2006), 2011 (SQL. 2011) dan 2016 (SQL. 2016). Namun, sebagian besar vendor database memiliki arahan sendiri, mis. g. , PL/SQL (Oracle), Transact-SQL (Microsoft, SAP), PL/pgSQL (PostgreSQL) SQL Dengan ContohSistem basis data relasional mengatur data dalam hierarki berikut
Misalkan kita memiliki database bernama -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)_2, sebuah tabel bernama -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)3 dalam database dengan 3 kolom ( -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)4, -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)5, -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)6) dan 4 baris seperti ilustrasi di bawah ini. Setiap kolom memiliki tipe data. Kami memilih. -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)_7 (bilangan bulat) untuk kolom -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)4, -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)9 (string panjang variabel hingga 50 karakter) untuk -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)5, dan XXXXXX XX:XX:XX [Note] mysqld: Normal shutdown ...... XXXXXX XX:XX:XX InnoDB: Starting shutdown... XXXXXX XX:XX:XX InnoDB: Shutdown completed; log sequence number 0 44233 ...... XXXXXX XX:XX:XX [Note] mysqld: Shutdown complete (You may need to press ENTER to get the command prompt?!)1 (angka floating-point) untuk -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)6 Database: studentdb Table: class101 +-----------+--------------------+-------------+ | id (INT) | name (VARCHAR(50)) | gpa (FLOAT) | +-----------+--------------------+-------------+ | 1001 | Tan Ah Teck | 4.5 | | 1002 | Mohammed Ali | 4.8 | | 1003 | Kumar | 4.8 | | 1004 | Kevin Jones | 4.6 | +-----------+--------------------+-------------+ SQL (Structure Query Language) mendefinisikan sekumpulan perintah intuitif (seperti // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx6, // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx7, // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx9, // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx8) untuk berinteraksi dengan sistem database relasional PILIHMENGHAPUSMENYISIPKANMEMPERBARUIBUAT TABELTABEL JATUHCatatan
Pengantar MySQL Relational Database Management System (RDBMS)SQL adalah bahasa pemrograman untuk berinteraksi dengan basis data relasional. Di sisi lain, MySQL adalah perangkat lunak - Sistem Manajemen Basis Data Relasional MySQL adalah salah satu Relational Database Management System (RDBMS) yang paling banyak digunakan, kekuatan industri, sumber terbuka, dan gratis. MySQL dikembangkan oleh Michael "Monty" Widenius dan David Axmark pada tahun 1995. Itu dimiliki oleh sebuah perusahaan Swedia bernama MySQL AB, yang dibeli oleh Sun Microsystems pada tahun 2008. Sun Microsystems diakuisisi oleh Oracle pada tahun 2010 MySQL sukses, bukan hanya karena gratis dan open-source (ada banyak database gratis dan open-source, seperti PostgreSQL, Apache Derby (Java DB), mSQL (mini SQL), SQLite dan Apache OpenOffice's Base), tetapi . MySQL mendukung semua fitur yang diharapkan dalam database relasional berkinerja tinggi, seperti transaksi, kunci asing, replikasi, subkueri, prosedur tersimpan, tampilan, dan pemicu MySQL sering digunakan di lingkungan LAMP (Linux-Apache-MySQL-PHP), WAMP (Windows-Apache-MySQL-PHP), atau MAMP (macOS-Apache-MySQL-PHP). Semua komponen di LAMP gratis dan open-source, termasuk Sistem Operasi Situs induk untuk MySQL adalah https. // www. mysql. com. Referensi utama untuk MySQL adalah "Manual Referensi MySQL", tersedia di https. //dev. mysql. com/doc. Manual referensi sangat besar - PDF memiliki lebih dari 3700 halaman  MySQL beroperasi sebagai sistem client-server melalui jaringan TCP/IP. Server berjalan pada mesin dengan alamat IP pada nomor port TCP yang dipilih. Nomor port TCP default untuk MySQL adalah 3306. Pengguna dapat mengakses server melalui program klien, menghubungkan ke server pada alamat IP dan nomor port TCP yang diberikan MariaDBDiambil dari Wiki. MariaDB adalah garpu sistem manajemen basis data relasional MySQL (RDBMS) yang dikembangkan oleh komunitas dan didukung secara komersial, dimaksudkan untuk tetap bebas dan perangkat lunak sumber terbuka di bawah Lisensi Publik Umum GNU. Pengembangan dipimpin oleh beberapa pengembang asli MySQL, yang bercabang karena kekhawatiran atas akuisisi oleh Oracle Corporation pada tahun 2009. Cara Instal MySQL 8. 0 dan Mulai dengan Pemrograman SQLSaya ingin Anda menginstal MySQL di mesin Anda sendiri, karena saya ingin Anda mempelajari cara menginstal, menyesuaikan, dan mengoperasikan sistem perangkat lunak industri yang kompleks. Instalasi bisa menjadi bagian tersulit dalam latihan ini Langkah 0. Buat direktori untuk menyimpan semua karya AndaPENTING. Sebelum memulai, periksa apakah Anda memiliki beberapa GB Ruang Kosong Buat direktori untuk menyimpan semua karya Anda
// For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject Gunakan antarmuka grafis Anda, mis. g. , File Explorer (Windows), atau Finder (macOS) untuk memverifikasi direktori ini. (Tentu saja Anda dapat menggunakan antarmuka grafis Anda untuk membuat direktori ini. ) Untuk pemula. Penting untuk mengikuti langkah ini. Jika tidak, Anda tidak akan sinkron dengan artikel ini dan tidak akan dapat menemukan file Anda nanti Langkah 1. Unduh dan Instal MySQLUntuk Windows
Untuk macOS Catatan. MySQL versi terbaru (8. 0. 32) bekerja dengan macOS Monterey (12) dan Ventura (13). Jika Anda menjalankan macOS versi lama, Anda mungkin perlu menemukan versi arsip MySQL @ https. //dev. mysql. com/downloads/ ⇒ Arsip
Saya berasumsi bahwa MySQL diinstal di direktori -- Change the current directory to MySQL's binary directory. cd /usr/local/mysql/bin -- Start a client with superuser "root" (-u), and prompt for password (-p) ./mysql -u root -p Enter password: // Enter the root's password given during installation. You will NOT any * for maximum security Welcome to the MySQL monitor. Commands end with ; or \g. ...... mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.9" (untuk Windows) atau " -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye0" (untuk macOS). Tetapi Anda perlu MEMPERHATIKAN DIREKTORI TERINSTAL MySQL ANDA. Selanjutnya, saya akan menunjukkan direktori yang diinstal MySQL sebagai -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye1 dalam artikel ini Langkah 3. Mulai "Server"MySQL adalah sistem klien-server. Database dijalankan sebagai aplikasi server. Pengguna mengakses server basis data melalui program klien, secara lokal atau jarak jauh melalui jaringan, seperti yang diilustrasikan
Program -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye2 dan -- Change the current directory to MySQL's binary directory. cd /usr/local/mysql/bin -- Start a client with superuser "root" (-u), and prompt for password (-p) ./mysql -u root -p Enter password: // Enter the root's password given during installation. You will NOT any * for maximum security Welcome to the MySQL monitor. Commands end with ; or \g. ...... mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.2 disimpan di sub-direktori " -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye8" dari direktori yang diinstal MySQL Server pemulaUntuk Windows Untuk memulai server basis data, luncurkan shell CMD baru -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)_ Catatan. Opsi -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye_9 mengarahkan pesan keluaran ke konsol. Tanpa opsi ini, Anda akan melihat layar kosong Untuk macOS CARA MUDAH. Melalui kontrol grafis. Klik Ikon "Apple" ⇒ Preferensi Sistem ⇒ MySQL ⇒ Mulai atau Berhenti Server database MySQL sekarang dimulai, dan siap untuk menangani permintaan klien Apa pun yang mungkin salah, tidak. Membaca "" Matikan ServerUntuk Windows Cara tercepat untuk mematikan server database adalah dengan menekan Ctrl-C untuk memulai shutdown normal. JANGAN MEMBUNUH server melalui tombol TUTUP jendela Amati pesan-pesan ini dari konsol server MySQL XXXXXX XX:XX:XX [Note] mysqld: Normal shutdown ...... XXXXXX XX:XX:XX InnoDB: Starting shutdown... XXXXXX XX:XX:XX InnoDB: Shutdown completed; log sequence number 0 44233 ...... XXXXXX XX:XX:XX [Note] mysqld: Shutdown complete (You may need to press ENTER to get the command prompt?!) Untuk macOS CARA MUDAH. Melalui kontrol grafis. Klik Ikon "Apple" ⇒ Preferensi Sistem ⇒ MySQL ⇒ Berhenti PERINGATAN. Anda harus mematikan server MySQL dengan benar. Jika tidak, Anda mungkin merusak database dan mungkin mengalami masalah saat memulai ulang. NAMUN, jika Anda mengalami masalah saat mematikan server secara normal, Anda dapat menghentikan proses " -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye2" di Pengelola Tugas (untuk Windows); Langkah 4. Mulai "Klien"Ingat bahwa MySQL adalah sistem client-server. Setelah server dimulai, satu atau lebih klien dapat dihubungkan ke server basis data. Klien dapat dijalankan di mesin yang sama (klien lokal); Untuk masuk ke server MySQL, Anda perlu memberikan nama pengguna dan kata sandi. Selama instalasi, MySQL membuat superuser bernama " -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.5" dengan kata sandi sementara. Saya harap Anda telah mencatat kata sandi ini. (Jika tidak, instal ulang. ) Instalasi MySQL menyediakan program klien baris perintah yang disebut " -- Change the current directory to MySQL's binary directory. cd /usr/local/mysql/bin -- Start a client with superuser "root" (-u), and prompt for password (-p) ./mysql -u root -p Enter password: // Enter the root's password given during installation. You will NOT any * for maximum security Welcome to the MySQL monitor. Commands end with ; or \g. ...... mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.2". (Ingat bahwa program server disebut " -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye2" dengan akhiran -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye3; program klien tidak memiliki akhiran ' -- Change directory to MySQL's binary directory c: cd \myWebProject\mysql\bin -- Start a MySQL client mysql -u root -p Enter password: // Enter the NEW password Welcome to the MySQL monitor. ..... mysql> -- client started, ready to issue SQL command5') Mari mulai klien baris perintah dengan superuser " -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.5" Pertama, pastikan server berjalan. Lihat langkah sebelumnya untuk memulai kembali server jika telah dimatikan Untuk Windows Mulai Shell CMD BARU lainnya untuk menjalankan klien (Anda harus menyimpan CMD yang menjalankan server) -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE. Untuk macOS Buka "Terminal" BARU dan keluarkan perintah ini untuk memulai klien MySQL dengan superuser -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.5 -- Change the current directory to MySQL's binary directory. cd /usr/local/mysql/bin -- Start a client with superuser "root" (-u), and prompt for password (-p) ./mysql -u root -p Enter password: // Enter the root's password given during installation. You will NOT any * for maximum security Welcome to the MySQL monitor. Commands end with ; or \g. ...... mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE. (Lewati Kecuali. ) Membaca "" Langkah 5. Ubah Kata Sandi untuk "root" SuperuserSeperti disebutkan sebelumnya, instalasi MySQL membuat superuser yang disebut " -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.5" dengan kata sandi acak sementara. " -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE._5" adalah pengguna istimewa yang dapat melakukan apa saja, termasuk menghapus semua basis data. Anda diminta untuk mengubah kata sandi root segera setelah masuk Catatan. Jika Anda terjebak memasukkan perintah, tekan Ctrl-C untuk membatalkan perintah saat ini Mengubah Kata Sandi untuk "root"Mari kita lanjutkan dengan sesi klien kita yang dimulai sebelumnya -- Change password for 'root'@'localhost'. Replace xxxx with your chosen password -- (For macOS, there is no need to change the password, but there is no harm trying it out) -- (For my students: use xxxx as the password. Otherwise, you will ask me what is your password next week.) -- Take note that strings are to be enclosed by a pair of single-quotes in MySQL. mysql> alter user 'root'@'localhost' identified by 'xxxx'; Query OK, 0 rows affected (0.00 sec) -- Query the password mysql> select Host, User, authentication_string from mysql.user; +-----------+------------------+---------------------------+ | Host | User | authentication_string | +-----------+------------------+---------------------------+ | localhost | root | $A$005... | | ... | ... | ....... | +-----------+------------------+---------------------------+ -- Take note that the "HASH" of the password is saved, NOT the "PLAIN" password -- [Starting from MySQL 5.x, the "Password" field was removed?!] -- logout and terminate the client program mysql> quit Bye Mulai Ulang Klien sebagai "root" dengan Kata Sandi BaruKami baru saja mengubah kata sandi untuk -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.5 dan keluar dari klien. Mulai klien dan login sebagai -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.5 lagi. Masukkan kata sandi saat diminta Untuk Windows -- Change directory to MySQL's binary directory c: cd \myWebProject\mysql\bin -- Start a MySQL client mysql -u root -p Enter password: // Enter the NEW password Welcome to the MySQL monitor. ..... mysql> -- client started, ready to issue SQL command Untuk macOS -- Change directory to MySQL's binary directory cd /usr/local/mysql/bin -- Start a MySQL client ./mysql -u root -p Enter password: // Enter the NEW password Welcome to the MySQL monitor. ...... mysql> -- client started, ready to issue SQL command Langkah 6. Buat Pengguna Baru"Root" superuser memiliki hak istimewa, yang dimaksudkan untuk administrasi basis data dan tidak dimaksudkan untuk operasional. Kami akan membuat pengguna baru - sebut saja " -- Change directory to MySQL's binary directory cd /usr/local/mysql/bin -- Start a MySQL client ./mysql -u root -p Enter password: // Enter the NEW password Welcome to the MySQL monitor. ...... mysql> -- client started, ready to issue SQL command2" - dengan hak istimewa yang lebih rendah. Untuk membuat pengguna baru, mulai klien dengan superuser " -- Change the current directory to MySQL's binary directory. -- Assume that the MySQL is installed in "c:\myWebProject\mysql". c: cd \myWebProject\mysql\bin -- Start a client as superuser "root" (-u), and prompt for password (-p) mysql -u root -p Enter password: // Enter the root's password set during installation. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 8.0.xx Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- Client started. The prompt changes to "mysql>". -- You can now issue SQL commands such as SELECT, INSERT and DELETE.5" // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject_0 Penjelasan
Langkah 7. Buat Database baru, Tabel baru di Database, Sisipkan Rekaman, Kueri, dan PerbaruiIngatlah bahwa server MySQL mengatur data dalam hierarki berikut
Mari buat database bernama " -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)_2", dan tabel bernama " -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)3" di database. Tabel harus memiliki tiga kolom. -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)_4 (tipe -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)7 - bilangan bulat), -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)5 (tipe -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)9 - string dengan panjang variabel hingga 50 karakter), -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)6 (tipe XXXXXX XX:XX:XX [Note] mysqld: Normal shutdown ...... XXXXXX XX:XX:XX InnoDB: Starting shutdown... XXXXXX XX:XX:XX InnoDB: Shutdown completed; log sequence number 0 44233 ...... XXXXXX XX:XX:XX [Note] mysqld: Shutdown complete (You may need to press ENTER to get the command prompt?!)1 - angka floating-point) PERINGATAN. Pemrogram tidak menggunakan karakter kosong dan khusus di NAMES (nama database, nama tabel, nama kolom). Itu tidak didukung, atau akan memberi Anda lebih banyak tantangan Tips Menggunakan Sesi Klien (Kembali ke Bagian Ini Jika Anda Terjebak dalam Menjalankan Perintah)Sebelum kita melanjutkan, berikut adalah beberapa tips dalam menggunakan klien
Mari mulai klien dengan pengguna baru kita " -- Change directory to MySQL's binary directory cd /usr/local/mysql/bin -- Start a MySQL client ./mysql -u root -p Enter password: // Enter the NEW password Welcome to the MySQL monitor. ...... mysql> -- client started, ready to issue SQL command2" // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject_5 Latihan
(Lewati Kecuali. ) Membaca "" Lebih Banyak Latihan
Relasi banyak ke banyakDi toko buku, sebuah buku ditulis oleh satu atau lebih pengarang; . Ini dikenal sebagai hubungan banyak-ke-banyak. TIDAK MUNGKIN untuk menangkap hubungan banyak-ke-banyak dalam tabel TUNGGAL (atau satu spreadsheet) dengan jumlah kolom yang tetap, tanpa menduplikasi informasi apa pun. Misalnya, jika Anda mengatur data pada tabel di bawah ini, Anda tidak akan mengetahui berapa banyak kolom penulis yang akan digunakan; Hubungan banyak-ke-banyak antara buku dan penulis dapat dimodelkan dengan 3 tabel, seperti yang ditunjukkan di bawah ini. Tabel // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject_50 berisi data tentang buku (seperti judul dan harga); . Tabel bernama // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject52 bergabung dengan tabel // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject50 dan // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject51 dan menangkap hubungan banyak-ke-banyak antara // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject50 dan // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject51 Latihan
(Opsional) Backup dan Restore DatabaseCadangkan melalui Program Utilitas "mysqldump".Anda dapat menggunakan program utilitas // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject76 untuk mencadangkan (i) seluruh server (semua database), (ii) database yang dipilih, atau (ii) tabel database yang dipilih. Program " // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject_77" menghasilkan skrip SQL yang nantinya dapat dieksekusi untuk membuat ulang database, tabel, dan barisnya Misalnya, perintah berikut mencadangkan seluruh database " -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)2" ke skrip SQL yang disebut " // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject79" Untuk Windows // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject_9 Untuk macOS // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx0 Pelajari file output, yang berisi // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject_80, -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)0 dan // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx7 pernyataan untuk membuat ulang database dan tabel yang dibuang sebelumnya Pulihkan melalui perintah "sumber" di klien mysqlAnda dapat memulihkan dari cadangan dengan menjalankan perintah " // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject83" di klien MySQL. Misalnya untuk mengembalikan cadangan -- Change the current directory to MySQL's binary directory -- Assume that the MySQL installed directory is "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin -- Start the MySQL Database Server mysqld --console // If Windows Defender Firewall popup, choose "allow access". ...... ...... XXXXXX XX:XX:XX [Note] mysqld: ready for connections. Version: '8.0.xx' socket: '' port: 3306 MySQL Community Server (GPL)_2 tadi Untuk Windows // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx_1 Untuk macOS // Change directory to the MySQL's binary directory // Suppose that your MySQL is installed in "c:\myWebProject\mysql" c: cd \myWebProject\mysql\bin // Initialize the database. Create a root user with random password. Show the messages on console mysqld --initialize --console ...... ..... [Note] A temporary password is generated for root@localhost: xxxxxxxx_2 Ringkasan Perintah yang Sering Digunakan(Untuk Windows) Memulai Server dan Klien MySQL(Untuk macOS) Memulai Server dan Klien MySQLPerintah MySQL yang sering digunakanPerintah MySQL TIDAK peka huruf besar-kecil (Lewati Kecuali. ) Bagaimana Cara Men-debug?"Segala sesuatu yang mungkin salah akan salah. " Hal terpenting yang harus dilakukan adalah menemukan PESAN KESALAHAN MENYEBABKAN. Anda tidak memiliki "runtime yang dapat didistribusikan ulang Microsoft Visual C++" yang diperlukan LARUTAN. Goto "Unduhan Visual C++ terbaru yang didukung" @ https. //mendukung. microsoft. com/en-gb/help/2977003/the-latest-supported-visual-c-downloads ⇒ Unduh "x64. // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject_85" ⇒ jalankan executable untuk menginstal "Microsoft Visual C++ 2015-2019 redistributable (x64)" ⇒ Restart komputer Anda ⇒ Anda dapat menemukan " // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject86" di bawah " // For Windows: Use "C:\myWebProject" // Launch a "CMD" and issue these commands: c: cd \ mkdir myWebProject // For macOS: Use "~/myWebProject" (where "~" denotes your home directory) // Launch a "Terminal" and issue these commands: cd mkdir myWebProject87" Bagaimana cara menginstal MySQL di komputer saya?Proses instalasi mirip dengan sistem operasi lain. . Buka situs web MySQL di browser. Klik tautan berikut. Unduhan MySQL Pilih opsi Download Pilih Pemasang MySQL untuk Windows Pilih penginstal yang diinginkan dan klik unduh Bagaimana cara menginstal MySQL secara manual di Windows?Anda juga boleh memilih penyiapan lengkap karena ini akan menginstal semua sumber daya MySQL yang tersedia. Setelah Anda memilih opsi pengaturan, klik Berikutnya. . Memilih jenis penyiapan Mengunduh file Menginstal perangkat lunak Menyelesaikan instalasi Bagaimana cara menginstal database MySQL di Windows?Unduh dan instal server basis data MySQL. Anda dapat mengunduh server komunitas MySQL dari lokasi ini. Setelah penginstal diunduh, klik dua kali file setup untuk memulai proses penginstalan. Pada halaman Memilih Jenis Penyiapan, Anda dapat melihat empat opsi pemasangan
Bagaimana cara menginstal MySQL secara manual di Windows 10?Cara Mengunduh Edisi Komunitas Gratis MySQL . Buka situs web MySQL dan pilih Unduhan Pilih Unduhan Komunitas MySQL (GPL). . Pada halaman berikutnya, pilih MySQL Community Server Gulir ke bawah ke bagian bawah halaman dan pilih Go to Download Page di samping Windows (x86, 32 & 64-bit), MySQL Installer MSI |
Bagaimana cara saya menginstal mysql di pc saya?
Pos Terkait
Copyright © 2024 ketajaman Inc.
