ubuntu安装mysql[ubuntu部署]
版权声明:
本文为博主原创文章,转载请声明原文链接...谢谢。o_0。
更新时间:
2019-06-01 15:05:53
温馨提示:
学无止境,技术类文章有它的时效性,请留意文章更新时间,如发现内容有误请留言指出,防止别人"踩坑",我会及时更新文章
安装mysql5.6
在ubuntu上安装mysql5.6的版本
1.添加mysql5.6的源
sudo apt-get install software-properties-common sudo add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
2.安装mysql5.6
sudo apt-get update sudo apt install mysql-server-5.6 sudo apt install mysql-client-5.6
3.设置开机自启
update-rc.d mysql defaults
4.创建或修改 my.cnf 文件
在/etc/mysql/目录下添加 my.cnf文件
sudo vim /etc/mysql/my.cnf
复制下面的内容,并保存文件
# The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. # Here is entries for some specific programs # The following values assume you have at least 32M ram !includedir /etc/mysql/conf.d/ # add here [mysqld] default-time_zone = '+8:00' lower_case_table_names=1
5.重启Mysql服务
sudo service mysql restart
6.开启远程用户管理
mysql -u root -p use user; update user set host='host' where user='root'; FLUSH PRIVILEGES;