ubuntu 20.041. 安装server
sudo apt-get update
sudo apt-get install mysql-server
2. 设置密码及安全配置
sudo mysql_secure_installation
配置项,如下所示
New password:(输入密码)
Re-enter new password:(重复输入)
Remove anonymous users? (Press y|Y for Yes,any other key for No): N (选择N,不删除匿名用户)
Disallow root login remotely? (Press y|Y for Yes,any other key for No): N (选择N,允许root远程连接)
Remove test database and access to it? (Press y|Y for Yes,any other key for No): N (选择N,不删除test数据库)
Reload privilege tables now? (Press y|Y for Yes,any other key for No): Y (选择Y,修改权限立即生效)3. 检测服务
systemctl status mysql.service
4. 配置允许远程访问
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf #找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)
sudo /etc/init.d/mysql restart #重启mysql5. 设置权限与密码
sudo mysql # 登入mysql
mysql>use mysql;# 切换数据库
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';# 使用mysql_native_password修改加密规则
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;# 更新一下用户的密码
mysql> UPDATE user SET host ='%' WHERE user ='root';# 允许远程访问
mysql> CREATE DATABASE auto;# 创建数据库
mysql> CREATE USER 'www' @'%' IDENTIFIED WITH mysql_native_password BY 'www123?';# 创建用户
mysql> GRANT ALL PRIVILEGES ON autoneo.* TO 'www'@'%' WITH GRANT OPTION;# 授权用户指定数据库
mysql>flush privileges;#刷新cache中配置 刷新权限
mysql>quit;# 退出