ubantu上配置开发环境

1. 安装mysql

  • 安装
sudo apt-get update
sudo apt-get install mysql-server
  • 配置安全设置密码远程登录
sudo mysql_secure_installation 
参考:
https://blog.csdn.net/weixx3/article/details/80782479
https://blog.csdn.net/kong050kong/article/details/87898178
https://blog.csdn.net/zhangvalue/article/details/80705769
  • 查看数据库状态
systemctl status mysql
  • 登录mysql,使用安全设置时的密码
sudo mysql -u root -p
  • 修改root密码
mysql> grant all privileges on *.* to root@localhost identified by "123456789";
  • 创建远程登录用的库和用户
mysql> create database db_workflows charset="utf8";
mysql> grant all privileges on db_workflows.* to sunxiuwen@"%"  identified by "123456";
  • 安装可视化工具mysql-workbench
sudo apt-get install mysql-workbench
https://blog.csdn.net/swust5120166213/article/details/86436335
posted @ 2019-04-08 11:32  Alive_2020  阅读(191)  评论(0编辑  收藏  举报