vlei 发表于 2019-2-18 10:30:12

ubuntu14.01安装mysql5.6

　　1.安装mysql
   apt-get install mysql-server-5.6 安装mysql
2.配置权限   
chgrp -R mysql /var/log/mysql/配置组
chown -R mysql:mysql /var/log/mysql/ 配置权限
备注：
    配置文件位置：/etc/mysql/my.cnf
    数据目录:/var/lib/mysql
    错误日志：/var/log/mysql/error.log
   
ps -ef | grep mysql查看mysql进程是否运行
netstat -tap | grep mysql查看msyql 监听端口
3.修改配置文件
vi /etc/mysql/my.cnf
注释远程绑定


http://s1.运维网.com/images/20181224/1545637207879274.png
在下追加
default-character-set = utf8
http://s1.运维网.com/images/20181224/1545637220408807.png

在下追加
character-set-server=utf8
http://s1.运维网.com/images/20181224/1545637233133430.png
在下追加
default-character-set=utf8
http://s1.运维网.com/images/20181224/1545637246476513.png

4.新建用户并授权
create user 'ylyk'@'127.0.0.1' identified by '123456';
http://s1.运维网.com/images/20181224/1545637264305687.pnghttp://blog.运维网.com/static/js/ueditor1.4.3/themes/default/images/spacer.gif
create database wfm;
http://s1.运维网.com/images/20181224/1545637287229661.png

http://blog.运维网.com/static/js/ueditor1.4.3/themes/default/images/spacer.gif
grant all on wfm.* to ylyk'@'127.0.0.1';
http://s1.运维网.com/images/20181224/1545637309110298.png
flush privileges;
http://s1.运维网.com/images/20181224/1545637332520159.png

5.重启服务
service mysql restart



页: [1]
查看完整版本: ubuntu14.01安装mysql5.6