安装

安装apt的配置

  1. #wget -c https://repo.mysql.com//mysql-apt-config_0.8.14-1_all.deb
  2. #dpkg -i mysql-apt-config_0.8.14-1_all.deb

请访问https://dev.mysql.com/downloads/repo/apt/获取最新版本号

安装mysql

  1. #apt update
  2. #apt install mysql-server

远程连接

修改 /etc/mysql/mysql.conf.d/mysqld.cnf 增加

  1. bind-address = 0.0.0.0

登录mysql控制台

  1. mysql -u root -p

创建用户

  1. CREATE USER 'username'@'%' IDENTIFIED BY 'password';
  3. GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
  5. FLUSH PRIVILEGES;