Mysql

Abstract: “Mysql在Ubuntu下安装及配置的相关教程.”

---

---

安装Mysql

1.安装Mysql

sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install libmysqlclient-dev

2.检查是否安装成功

sudo netstat -tap | grep mysql

---

修改初始密码

1.查看初始密码

sudo gedit /etc/mysql/debian.cnf

password那一项就是密码,复制粘贴出来

2.更新密码

sudo mysql -u root -p
#输入上面复制粘贴出来的密码登录到mysql
#然后使用以下命令更新密码(其中new-password为设置的新密码)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new-password';

#一旦完成stop and start了mysql服务器。
sudo service mysql stop
sudo service mysql restart

3.Mysql 连接测试

mysql -u root -h localhost -p

然后输入新密码即可登录mysql

---

参考链接:

[1] ERROR 1698 (28000): Access denied for user ‘root’@‘localhost’