怎样安装在ubuntu12.04上安装mysql

最新推荐文章于 2021-02-11 13:01:41 发布

最新推荐文章于 2021-02-11 13:01:41 发布 · 193 阅读

文章标签：

#数据库 #网络

本文详细介绍了如何在Ubuntu Linux 12.04 LTS 32位系统上逐步安装MySQL 5.5数据库。从打开终端到验证MySQL是否运行成功，包括更新包缓存、安装MySQL服务器软件包、创建新数据库及用户等步骤。

Abstract

MySQL is the most trusted and depended-on open source database platform in use today. As such, 9 out of the top 10 most popular and highly trafficked websites in the world rely on MySQL primarily due to its ubiquity across heterogeneous platforms and application stacks and for its well-known performance, reliability and ease of use. This blog entry will guide you through the step-by-step installation ofMySQL 5.5onUbuntu Linux 12.04 LTS 32 bit. This installation is performed on a clean installation of Ubuntu Server 12.04 32 bit.

Step 1: Open your Terminal

Press the following keyboard shortcut:

 
        Ctrl + Alt + T

Step 2: Update your package cache

Run the following command in your terminal:

 
        sudo
        apt-get update

Step 3: Install the mysql-server-5.5 package

Run the following command in your terminal:

 
        sudo
        apt-get 
        install
        mysql-server-5.5

Step 4: Create a new MySQL database

Run the following commands in your terminal, replacingnewdatabase,newuserandnewpassword:

 
        mysql -u root -p 
       
        CREATE DATABASE newdatabase; 
       
        GRANT ALL PRIVILEGES ON newdatabase.* TO newuser@localhost IDENTIFIED BY 
        'newpassword'
        ; 
       
        Press CTRL + D

Step 5: Check whether MySQL is running

Run the following command in your terminal:

 
        sudo
        netstat 
         -tap | 
        grep
        mysql

You should see the following line or something similar:

 
        tcp 0 0 localhost:mysql *:* LISTEN 2810
        /mysqld

Step 6: Congratulations – You have just installed MySQL on Ubuntu. Share this fantastic news using one of the share buttons or leave a comment in the reply section below.