MySQL/MariaDB

Deploy MySQL or MariaDB, open source relational database management systems that use SQL (Structured Query Language) to manage data. MariaDB is a backward-compatible replacement for MySQL, maintained and developed by the MariaDB Foundation. Use this app to run a standalone database for applications ranging from a CRM to WordPress.

1. Deploy MySQL/MariaDB

 Estimated deployment time: 2–5 minutes

Base distribution and plan

• Supported distribution: Ubuntu 24.04 LTS
• Recommended plans: All plan types and sizes can be used. For larger databases in a production environment, use a High Memory Compute Instance.

Configuration options

StackScript ID: 607026

Note: After the app deployment completes, the password for your limited sudo user is generated and stored in the .credentials file in the home directory, along with application-specific passwords. Log in to your instance as root through the Lish console or SSH, then run cat /home/$USERNAME/.credentials to view its contents.

Use API, CLI, or Terraform

curl --location 'https://api.linode.com/v4/linode/instances' \
    --header 'Content-Type: application/json' \
    --header 'Accept: application/json' \
    --header 'Authorization: Bearer abc123def456hij789klm' \
    --data-raw '{
        "region": "us-east",
        "type": "g6-standard-2",
        "image": "linode/ubuntu24.04",
        "label": "my-mariadb-one-click-app",
        "root_pass": "@C0mpl3x#P@ssw0rd",
        "stackscript_id": 607026,
        "stackscript_data": {
            "user_name": "jsmith"
        }
    }'

linode-cli linodes create \
    --region us-east \
    --type g6-standard-2 \
    --label my-mariadb-one-click-app \
    --image linode/ubuntu24.04 \
    --root_pass @C0mpl3x#P@ssw0rd \
    --stackscript_id 607026 \
    --stackscript_data '{"user_name":"jsmith"}'

resource "linode_instance" "my-linode" {
    region         = "us-east"
    type           = "g6-standard-2"
    label          = "my-mariadb-one-click-app"
    image          = "linode/ubuntu24.04"
    root_pass      = "@C0mpl3x#P@ssw0rd"
    stackscript_id = 607026
    stackscript_data = {
        "user_name" = "jsmith"
    }
}

2. Use MySQL/MariaDB

The standard tool for interacting with MySQL or MariaDB is the mysql client, which installs with the mysql-server package. The client is used through a terminal.

Log in as root

1. Log in to the database as the root user.

   Bash

   sudo mysql -u root -p

2. When prompted, enter the MySQL root password from the .credentials file. You'll see a welcome header and the MySQL prompt.

3. To view a list of the MySQL client commands, enter \h.

   Output

    List of all MySQL commands:
    Note that all text commands must be first on line and end with ';'
    ?         (\?) Synonym for `help'.
    clear     (\c) Clear command.
    connect   (\r) Reconnect to the server. Optional arguments are db and host.
    delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as new delimiter.
    edit      (\e) Edit command with $EDITOR.
    ego       (\G) Send command to mysql server, display result vertically.
    exit      (\q) Exit mysql. Same as quit.
    go        (\g) Send command to mysql server.
    help      (\h) Display this help.
    nopager   (\n) Disable pager, print to stdout.
    notee     (\t) Don't write into outfile.
    pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
    print     (\p) Print current command.
    prompt    (\R) Change your mysql prompt.
    quit      (\q) Quit mysql.
    rehash    (\#) Rebuild completion hash.
    source    (\.) Execute an SQL script file. Takes a filename as an argument.
    status    (\s) Get status information from the server.
    system    (\!) Execute a system shell command.
    tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
    use       (\u) Use another database. Takes database name as argument.
    charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
    warnings  (\W) Show warnings after every statement.
    nowarning (\w) Don't show warnings after every statement.
   
    For server side help, type 'help contents'

4. To leave MySQL/MariaDB, enter exit.

Create a sample table

1. Log back in as the limited sudo user you created during deployment.

   Bash

   sudo mysql -u [username] -p

2. Create a sample table called customers.

   Bash

   use webdata;
   create table customers (customer_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, first_name TEXT, last_name TEXT);

   This creates a table with:

   • A customer ID field of type INT for an integer (auto-incremented for new records, used as the primary key).
   • Two fields for storing the customer’s name. In this example, webdata is the database that you created when launching the Quick Deploy App.

3. View the contents of the table you created.

   CommandOutput

   describe customers;

   +-------------+---------+------+-----+---------+----------------+
   | Field       | Type    | Null | Key | Default | Extra          |
   +-------------+---------+------+-----+---------+----------------+
   | customer_id | int(11) | NO   | PRI | NULL    | auto_increment |
   | first_name  | text    | YES  |     | NULL    |                |
   | last_name   | text    | YES  |     | NULL    |                |
   +-------------+---------+------+-----+---------+----------------+

4. To leave MySQL/MariaDB, enter exit.

Additional resources

For more information about the installed packages, see their official documentation.

• MySQL Reference Manual
• PHP MySQL Manual
• MySQLdb User’s Guide

For more information about MySQL/MariaDB, see our official documentation.

• MariaDB Clusters with Galera