mysql 5.6的安装

下载

下载安装Mysql-server

到mysql的官方网站下载MySQL-server-5.6.23-1.linux_glibc2.5.x86_64.rpm
sudo rpm -ivh MySQL-server-5.6.23-1.linux_glibc2.5.x86_64.rpm
可能遇到的问题:
Failed dependencies: conflicts with mysql
解决方案：

执行：rpm -qa|grep -i mysql
然后逐步删除. 比如：
rpm -ev mysql-libs-5.1.69-1.el6_4.x86_66

可能遇到的问题2：
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
mysql-libs is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64 情况

解决方案：

sudo rpm -e --nodeps mysql-libs-5.1.69-1.el6_4.x86_64

下载安装Mysql-client

到mysql的官方网站下载MySQL-client-5.6.23-1.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-client-5.6.23-1.linux_glibc2.5.x86_64.rpm

配置

配置文件位置：/usr/my.cnf
设置密码：
mysqladmin -u root -p[oldpass] password newpass

CREATE DATABASE IF NOT EXISTS testdb DEFAULT CHARSET utf8 COLLATE utf8_general_ci

问题

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’

为mysql.sock增加软连接（相当于windows中的快捷方式）

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

创建用户

添加用户：

insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject)
values("localhost","padmin",password("1234"),'','','');

赋予权限：
grant all privileges on test.* to padmin@'%' identified by '1234';

更新密码：
update mysql.user set password=password('d-8') where User="plamp"

刷新权限: flush privileges;­