Ubuntu18.04(linux)安装MySQL

比眉伴天荒 2022-05-14 02:59 205阅读 0赞

[https://www.cnblogs.com/woshimrf/p/ubuntu-install-mysql.html][https_www.cnblogs.com_woshimrf_p_ubuntu-install-mysql.html]

*  **本文作者：**[@Ryan Miao][Ryan Miao]
 *  **本文链接：**[https://www.cnblogs.com/woshimrf/p/ubuntu-install-mysql.html][https_www.cnblogs.com_woshimrf_p_ubuntu-install-mysql.html]
 *  **版权声明：** 本博客所有文章除特别声明外，均采用 [CC BY-NC-SA 3.0][] 许可协议。转载请注明出处！

> 目录
> 
> [**安装**][Link 1]  
> [**字符集修改utf8**][utf8]  
> [**登录权限问题**][Link 2]  
> 解决方案  
> [**关于重置密码**][Link 3]  
> [**参考**][Link 4]

## 安装 ##

mysql

sudo apt-get --purge remove mysql-server mysql-common mysql-client
    sudo apt-get install mysql-server mysql-common mysql-client
    
    mysqladmin -u root password your-new-password
    sudo /etc/init.d/mysql restart

mariadb

apt-get install mariadb-server

## 字符集修改utf8 ##

如果装的mariadb, 默认字符集已经是utf8了。mysql则不是

修改字符集：

sudo vim /etc/mysql/my.cnf

添加以下内容

[mysqld]
    collation-server = utf8_unicode_ci
    init-connect='SET NAMES utf8'
    character-set-server = utf8

重启：

service mysql restart

## 登录权限问题 ##

Ubuntu18.04 安装mysql或者mariadb之后，发现普通用户和远程都没有权限连接。

ERROR 1045: Access denied for user: 'root@localhost' (Using 
    password: YES)

修改了密码也不对。然后`sudo mysql -u root`即可登录。这显然不是我们想要的。

### 解决方案 ###

删除root，重新创建用户。

首先，登录

sudo mysql -u root

然后查看当前用户

删除root账号

mysql> DROP USER 'root'@'localhost';
    Query OK, 0 rows affected (0,00 sec)

重新创建root：

mysql> CREATE USER 'root'@'%' IDENTIFIED BY '123456';
    Query OK, 0 rows affected (0,00 sec)

授权

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
    Query OK, 0 rows affected (0,00 sec)
    
    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0,01 sec)

## 关于重置密码 ##

host为`%`时允许远程登录

SET PASSWORD FOR root@'localhost' = PASSWORD('password');

UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

USE mysql
    UPDATE user SET Password = PASSWORD('newpwd')
    WHERE Host = 'localhost' AND User = 'root';

允许任何地方登录

USE mysql
    UPDATE user SET Password = PASSWORD('newpwd')
    WHERE Host = '%' AND User = 'root';

## 参考 ##

*  https://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04
 *  https://help.ubuntu.com/community/MysqlPasswordReset

关注我的公众号

![wechat-public.jpg][]唯有不断学习方能改变！ -- **Ryan Miao**

分类: [Linux][]

标签: [Ubuntu][], [mysql][]

好文要顶 关注我

[https_www.cnblogs.com_woshimrf_p_ubuntu-install-mysql.html]: https://www.cnblogs.com/woshimrf/p/ubuntu-install-mysql.html
[Ryan Miao]: http://www.cnblogs.com/woshimrf
[CC BY-NC-SA 3.0]: https://creativecommons.org/licenses/by-nc-sa/3.0/
[Link 1]: https://www.cnblogs.com/woshimrf/p/ubuntu-install-mysql.html#_caption_0
[utf8]: https://www.cnblogs.com/woshimrf/p/ubuntu-install-mysql.html#_caption_1
[Link 2]: https://www.cnblogs.com/woshimrf/p/ubuntu-install-mysql.html#_caption_2
[Link 3]: https://www.cnblogs.com/woshimrf/p/ubuntu-install-mysql.html#_caption_3
[Link 4]: https://www.cnblogs.com/woshimrf/p/ubuntu-install-mysql.html#_caption_4
[wechat-public.jpg]: https://blog.rmiao.top/images/wechat-public.jpg
[Linux]: https://www.cnblogs.com/woshimrf/category/659979.html
[Ubuntu]: https://www.cnblogs.com/woshimrf/tag/Ubuntu/
[mysql]: https://www.cnblogs.com/woshimrf/tag/mysql/