Linux中安装MySQL

参阅[url=http://sanwu.iteye.com/blog/2002487]mysql在linux下安装[/url]

一、[url=http://dev.mysql.com/downloads/mysql/]下载MySQL[/url]

二、检查并删除以前安装的MySQL，如下：
[img]http://dl2.iteye.com/upload/attachment/0095/0948/9ac0eb27-83e6-3312-9b9c-06068c54c5c4.png[/img]
rpm -qa | grep mariadb

三、解压MySQL-5.5.36-1.el6.x86_64.rpm-bundle.tar到指定目录（/home/root/software/mysql），如下：
[img]http://dl2.iteye.com/upload/attachment/0095/0954/3d2f0581-7d50-3506-b05d-7542c0fe23b0.png[/img]

四、执行命令rpm -ivh ./*.rpm，即全部安装，如下：
其中[MySQL-devel、MySQL-client、MySQL-server]必须安装
[img]http://dl2.iteye.com/upload/attachment/0095/0957/a5346224-bc33-3a19-b92a-16859fa2df22.png[/img]

五、修改字符集编码，参阅[url=http://sanwu.iteye.com/blog/2002487]mysql在linux下安装[/url]
将/usr/share/mysql/my-medium.cnf复制到/etc/my.cnf，在my.cnf文件的[mysqld]添加编码，如下：
[img]http://dl2.iteye.com/upload/attachment/0095/0959/9a6ed6fc-d846-39ab-adb6-840a98b43bda.png[/img]
[url=http://www.linuxidc.com/Linux/2016-03/128940.htm]CentOS 7中使用rpm方式安装MySQL 5.7后无法使用root登录解决[/url]

六、启动mysql
service mysql start

七、修改mysql的root账户密码

[url=http://blog.csdn.net/lhh1002/article/details/6131733]解决Navicat 报错:1130-host ... is not allowed to connect to this MySql server,MySQL不允许从远程访问的方法[/url]
如下：

--设置允许来自任意IP的登录访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
--更新权限
flush privileges;

[url=http://www.linuxidc.com/Linux/2013-12/93375.htm]RedHat 安装软件源“Unable to read consumer identity”解决[/url]

备注：
查看日志
tail -n 20 /var/lib/mysql/localhost.localdomain54.err

[color=blue]出现mysql: Unknown OS character set 'GB18030'的错误解决

执行如下命令：
echo "export LANG=zh_CN.UTF-8" >> /etc/bashrc
source /etc/bashrc[/color]

[url=http://www.cnblogs.com/wuhou/archive/2008/09/28/1301071.html]Ubuntu安装配置Mysql[/url]
[url=http://asyty.iteye.com/blog/1442503]ubuntu 源码安装mysql[/url]
[url=http://blog.csdn.net/kevinhg/article/details/5934462]Ubuntu下deb包的安装方法 [/url]
[url=http://blog.csdn.net/zjgnl/article/details/8936644]Window上mysql5.6免安装配置[/url]
[url=http://roc588.blog.163.com/blog/static/140977409201141394928538/]《windows无法启动MySQL服务 错误1067：进程意外终止》的解决方法及反思[/url]
[url=http://blog.csdn.net/vah101/article/details/6365120]mysqld: unknown variable 'default-character-set=utf8'的解决[/url]

[url=http://tiankong6622.iteye.com/blog/2092530]MySQL 5.6 for Windows 解压缩版配置安装[/url]
[url=http://www.linuxidc.com/Linux/2016-04/130414.htm]CentOS 7下MySQL 5.7安装、配置与应用[/url]
[url=http://kangh.iteye.com/blog/2300779]在CentOS 6.4下安装Oracle 11gR2(x64)[/url]
[url=http://www.linuxidc.com/Linux/2016-03/128940.htm]CentOS 7中使用rpm方式安装MySQL 5.7后无法使用root登录解决[/url]