mysql安装与启动

安装

sudo apt-get install mysql-server mysql-client然后按照提示输入

管理服务

  • 启动
service mysql start
  • 停止
service mysql stop
  • 重启

service mysql restart

设置远程连接

  • 找到mysql配置文件并修改
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf将bind-address=127.0.0.1注释
  • 登录mysql,运行命令
grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘mysql‘ with grant option;flush privileges;
  • 重启mysql
    •   service mysql restart

相关文章