deepin15.11安装MySQL

港控/mmm° 2023-06-15 09:47 162阅读 0赞

deepin15.11安装MySQL

# 1.安装 #

这里我们使用apt方式直接安装  
sudo apt-get install -y mysql-server mysql-client  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l_size_16_color_FFFFFF_t_70]

# 2.设置密码 #

打开终端输入以下命令：  
sudo mysql -uroot -p  
要求输入密码是直接按回车可以直接进入（sudo必须加，不加进不去）。  
如下图：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l_size_16_color_FFFFFF_t_70 1]  
成功进入命令行模式以后依次执行下面命令设置密码

update mysql.user set plugin="mysql_native_password" where user="root";
    grant all on *.* to root@"localhost";
    update mysql.user set authentication_string=password('这里是你的密码') where user='root'and Host = 'localhost';
    flush privileges;

执行情况如下图：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l_size_16_color_FFFFFF_t_70 2]

# 3.测试 #

然后测试root账户能否使用密码正常登录，输入以下命令  
mysql -uroot -p  
再输入密码即可登录。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l_size_16_color_FFFFFF_t_70 3]

安装成功！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2019112116410477.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2019112116413591.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191121164235866.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20191121164303416.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Vhc2VzX3N0b25l,size_16,color_FFFFFF,t_70