1. 配置步骤
- Windows平台配置步骤
# 安装服务 mysqld --install mysql --defaults-file=D:\mysql-5.6.40-winx64\my.ini # 启动服务 net start mysql # 连接服务器 mysql -u root -h 127.0.0.1 -P 3307 -p # 修改root密码 USE mysql; UPDATE USER SET PASSWORD=PASSWORD('xx123456') WHERE USER='root'; # 创建新用户 CREATE USER lniwn IDENTIFIED BY 'xxxx'; # 分配远程访问权限 GRANT ALL PRIVILEGES ON *.* TO 'lniwn'@'%' IDENTIFIED BY 'xxxx'; # 应用权限变更 FLUSH PRIVILEGES;
- Ubuntu平台配置步骤
sudo apt-get update sudo apt-get install mysql-server mysql_secure_installation