search

zhuangjinxin / blog

:notebook: 个人博客 技术分享 整理笔记
http://blog.zhuangjinxin.top
7 stars 0 forks source link

Ubuntu14.04安装MySQL5.6 #17

Open zhuangjinxin opened 7 years ago

zhuangjinxin commented 7 years ago

安装MySQL5.6

sudo apt-get update sudo apt-get install mysql-client-core-5.6 sudo apt-get install mysql-client-5.6 sudo apt-get install mysql-server-5.6 查看进程：ps -ef | grep mysql 监听端口：netstat -tap | grep mysql 重启服务：sudo service mysql start/stop/restart

允许远程访问：

sudo vi /etc/mysql/my.cnf #bind_address - 127.0.0.1 注释掉 重启 授权： mysql -u root -p use user GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; . 所有的表 | root 授权给root | % 所有的ip和域名 | password 密码 刷新权限：FLUSH PRIVILEGES;

修改编码方式：

查看mysql服务端编码：status 修改配置文件：sudo vi /etc/mysql/my.cnf 在Client后追加：default-character-set = utf8 在mysqld下追加：character-set-server=utf8 在mysql下追加：default-character-set=utf8 保存退出，重启服务：sudo service mysql restart

zhuangjinxin commented 6 years ago

MySQL 5.7.21配置文件位置： sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf