#mysql-server

在 Ubuntu 安裝 MySQL

 MySQL 是開源的資料庫管理系統，

使用上也很廣泛，

許多需要資料庫的網站都選用其作為預設的資料庫管理系統，

安裝方法也很簡單，

這就是今天的主題：

在 Ubuntu 安裝 MySQL 

安裝的套件在軟體庫就有，

僅須執行：

sudo apt install mysql-server

就能夠安裝完畢，

安裝完畢後， 執行 sudo mysql_secure_installation 來進行初始設定

系統會出現幾個問題，

依照自己需求填寫即可，

密碼驗證模組

root 密碼設定

刪除匿名帳戶

禁止 root 從遠端登入

刪除測試資料庫與權限

密碼驗證模組是用來檢驗使用者密碼複雜度的，

避免使用者建立過於簡易的密碼。

基本上匿名帳戶與測試資料庫都不會用到，

均選擇刪除即可。

至於…

Want to know how to optimize MySQL database. Read here.

Every software engineer must have heard the name Mysql as it is one the most used and popular databases in world. When it comes to engineering there are whole lot of people who don’t even bother to think about database and focus only on code. This comes back and bite them bad when the system scales. Today we will see some points using which you can make sure you database will perform well. Lets…

Пишет что-то про локали и dialog

Решается так:

apt-get install locales locale-gen en_US en_US.UTF-8 ru_RU ru_RU.UTF-8 dpkg-reconfigure locales

А потом так

Sometimes you need to update your Linux computer. Simly run these two commands to get your Linux distribution up to date:

sudo apt-get update sudo apt-get upgrade

The update command updates the list of available packages, and their corresponding latest versions. The upgrade command upgrades the packages you have installed to the latest known version. This is why you need to run these commands in order.

But what do you if you run the upgrade command, and your upgrade gets stuck at a package? You’re unsure about stopping the upgrade, because you don’t know if all, or only some of the package upgrades will fail. 

The culprit might be that the software being upgraded is currently running, and can’t be upgraded without first stopping the software. This was exactly what happened to me while trying to upgrade my computer running mysql server.

I got to the point above circled in red, and I waited for about 10-15 minutes while nothing happened. Finally I googled the problem and found a solution that worked:

Open a new terminal and, in this instance, stop mysql. Once I did that, the upgrade and continued and eventually finished.

Automated installation of LAMP stack on Ubuntu Server

In this tutorial, I’ll show you that how we can install the LAMP stack on Ubuntu Server interactively.

First create the script :

vi lamp.sh

Copy and Paste the following code into it (Modify the MySQL root Password,as per your requirement):

#!/bin/bash #Instructions to use this script # #chmod +x SCRIPTNAME.sh # #sudo ./SCRIPTNAME.sh echo…