mysql部署
- 下载地址:http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-8.0/
- 解压tar包,tar -zxvf 文件名 ,解压后文件移动到/usr/local目录
- 创建mysql用户 useradd 用户名
- 初始化数据库:bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
- 配置mysql,/etc/my.cnf
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
port=3306
user=mysql
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
- 配置环境变量
vi /etc/profile 生效:source /etc/profile
PATH=/data/mysql/bin:/data/mysql/lib:$PATH
export PATH
- 添加启动服务service mysql start启动mysql
- 登陆mysql -uroot -p
- 数据库和用户创建
数据库:CREATE DATABASE IF NOT EXISTS blog DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
用户:create user ‘developer’@’%’ identified by ‘XXX’;
授权:grant all privileges on blog.* to ‘developer’@’%’ identified by ‘XXX’;
问题
- service mysql启动失败 提示unit not found 解决办法
ll /etc/init.d/ | grep mysql
- Found option without preceding group in config
修改文件编码 vim :set fileencoding=latin1
修改my.cnf [mysqld]
- mysql登陆错误 2059,8.0的加密验证,修改配置属性
default_authentication_plugin=mysql_native_password
- 密码到期,mysql.user;
添加属性skip-grant-tables,
修改密码
flush privileges;
ALTER user ‘root’@‘localhost’ IDENTIFIED BY ‘root’;
注释属性
- host:xxx is not allowed to connect
改表:host改为%
授权:GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
- 连接错误2003
您尝试访问的网站类型属于[]已经被上网策略[]拒绝访问。如果有疑问,请联系网络管理员。 重配安全组