![]() You should see this output: Query OK, 0 rows affected (0.07 sec) Run this command to create a customers table: CREATE TABLE customersĬustomer_id BIGINT PRIMARY KEY AUTO_INCREMENT, You should see this output: Database changed Select the sample_database database: USE sample_database You should see this output, which confirms that the database was created successfully: Query OK, 1 row affected (0.02 sec) Next, run this SQL command to create a sample database that’s named sample_database: CREATE DATABASE sample_database If you are using MariaDB, you may see a prompt like the following instead: MariaDB > When prompted, enter the root password of your MySQL server and hit Enter to continue. Then, enter this command to log in to MySQL as the root user: mysql -u root -p Please refer to the MySQL section, which contains guides that describe how to install MySQL on several Linux distributions.īefore you create your MySQL views, create a sample database, define a few tables, and populate them with some data first: ![]() The MySQL server software (or MariaDB) installed on your Linode. You can follow the Getting Started with Linode guide to provision a Linode. To follow along with this guide, make sure you have the following:Ī Linode, which you run the MySQL software on.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |