# Ubuntu中mysql的安装及基本配置

**URL:** <https://eijil.com/t/ubuntu-mysql/37>\
**Category:** 其它\
**Created:** [December 31, 2020, 10:01am UTC](https://eijil.com/t/ubuntu-mysql/37 "2020-12-31T10:01:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![linuxren](https://eijil.com/user_avatar/eijil.com/linuxren/32/6_2.png) [@linuxren](https://eijil.com/u/linuxren)\
**Post date:** [December 31, 2020, 10:01am UTC](https://eijil.com/t/ubuntu-mysql/37/1 "2020-12-31T10:01:00Z")

</div>

sudo apt install mysql-server

sudo mysql\_secure\_installation #基础安全配置

sudo mysql

mysql\> SELECT user,authentication\_string,plugin,host FROM mysql.user;

mysql\> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql\_native\_password BY ‘password’; #使root用户使用密码也可以登录mysql

mysql\> FLUSH PRIVILEGES;

mysql\> CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8\_unicode\_ci; #创建名为wordpress的数据库

mysql\> GRANT ALL ON wordpress.\* TO ‘wordpressuser’@‘localhost’ IDENTIFIED BY ‘password’; #创建wordpressuser用户，赋予其wordpress数据库所有权限，且用户密码为password

---

<div class="post-metadata">

**Author:** ![Tristan](https://eijil.com/user_avatar/eijil.com/tristan/32/986_2.png) [@Tristan](https://eijil.com/u/Tristan)\
**Post date:** [June 13, 2022, 7:59am UTC](https://eijil.com/t/ubuntu-mysql/37/2 "2022-06-13T07:59:49Z")

</div>

运行 mysql\_secure\_installation 后，设置密码时，如果出现下面错误

```nohighlight
 ... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.

```

需要在执行上面命令之前，先手动设置好密码

```sql
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'my-secret-password';

```

然后再执行操作

另起一个ssh，执行下面命令可以kill mysql\_secure\_installation

```nohighlight
sudo kill $(ps aux | grep mysql_secure_installation | grep -v grep | awk '{print $2}')

```