Record the specific steps for installing MariaDB in Ubuntu

Steps to install MariaDB in Ubuntu: Add MariaDB Repository Install MariaDB Start MariaDB Service Protect MariaDB Install Connect to MariaDB Create database and user (optional) Verify installation

Record the specific steps for installing MariaDB in Ubuntu

Step 1: Add MariaDB repository

 <code class="bash">sudo apt-get update sudo apt-get install software-properties-common sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc' sudo add-apt-repository 'deb [arch=amd64] http://mirror.mariadb.org/repo/10.1/debian buster main' sudo apt update</code>

Step 2: Install MariaDB

 <code class="bash">sudo apt install mariadb-server</code>

Step 3: Start MariaDB service

 <code class="bash">sudo systemctl start mariadb</code>

Step 4: Protect MariaDB installation

 <code class="bash">sudo mysql_secure_installation</code>

You will be prompted to set the root password and configure other security settings.

Step 5: Connect to MariaDB

 <code class="bash">mysql -u root -p</code>

Prompt to enter the set root password.

Step 6: Create a database and user (optional)

 <code class="bash"># 创建数据库named "my_database" CREATE DATABASE my_database; # 为named "my_user" 的用户创建用户并赋予访问权限GRANT ALL PRIVILEGES ON my_database.* TO 'my_user'@'%' IDENTIFIED BY 'my_password'; # 刷新权限表FLUSH PRIVILEGES; # 退出MariaDB exit</code>

Step 7: Verify the installation

 <code class="bash"># 在MariaDB 提示符下，运行以下查询： SELECT version(); # 期望的输出： # 10.1.48-MariaDB</code>

Congratulations! You have now successfully installed MariaDB on Ubuntu.

The above is the detailed content of Record the specific steps for installing MariaDB in Ubuntu. For more information, please follow other related articles on the PHP Chinese website!