centos
我本来只是为了搭建简单的lamp环境，亲自动手，却发现有这么多的问题会发生。(by default7#zbphp.com)
很多地方给的安装mysql的提示是通过yum一键安装。shell命令如下：
yum install mysqlyum install mysql-serveryum install mysql-devel
但是，这个命令安装的mysql版本很旧，5.1.0x版本的，官网的mysql已经是 5.6.x版本了。太旧了，记得08年的时候就出了 5.1的版本了。
坚持安装最新版本的，在mysql官网下载rpm-.tar安装包，300mb左右。linux64。
[root@localhost mysqlinstall]# ls mysql-client-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-devel-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-embedded-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-server-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-shared-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-shared-compat-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-test-5.6.19-1.linux_glibc2.5.x86_64.rpm[root@localhost mysqlinstall]# pwd/home/default7@zbphp.com/downloads/mysqlinstall[root@localhost mysqlinstall]#
但是按照网上（csdn博客、blogcn博客）一步步提示来安装但是总是各种问题，各种问题，无法运行。
最后尝试了很多遍终于安装成功，正常运行：
[root@localhost /]# yum remove mysqlloaded plugins: fastestmirror, refresh-packagekit, securitysetting up remove processno match for argument: mysqlloading mirror speeds from cached hostfile * base: mirrors.163.com * extras: mirrors.163.com * updates: mirrors.163.compackage(s) mysql available, but not installed.no packages marked for removal[root@localhost /]# yum remove mysql-serverloaded plugins: fastestmirror, refresh-packagekit, securitysetting up remove processresolving dependencies--> running transaction check---> package mysql-server.x86_64 0:5.6.19-1.linux_glibc2.5 will be erased--> finished dependency resolutiondependencies resolved================================================================================ package arch version repository size================================================================================removing: mysql-server x86_64 5.6.19-1.linux_glibc2.5 installed 248 mtransaction summary================================================================================remove 1 package(s)installed size: 248 mis this ok [y/n]: ydownloading packages:running rpm_check_debugrunning transaction testtransaction test succeededrunning transaction erasing : mysql-server-5.6.19-1.linux_glibc2.5.x86_64 1/1 verifying : mysql-server-5.6.19-1.linux_glibc2.5.x86_64 1/1 removed: mysql-server.x86_64 0:5.6.19-1.linux_glibc2.5 complete![root@localhost /]# yum remove mysql-*loaded plugins: fastestmirror, refresh-packagekit, securitysetting up remove processresolving dependencies--> running transaction check---> package mysql-devel.x86_64 0:5.6.19-1.linux_glibc2.5 will be erased---> package mysql-shared.x86_64 0:5.6.19-1.linux_glibc2.5 will be erased---> package mysql-shared-compat.x86_64 0:5.6.19-1.linux_glibc2.5 will be erased--> processing dependency: libmysqlclient.so.16()(64bit) for package: perl-dbd-mysql-4.013-3.el6.x86_64--> processing dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-dbd-mysql-4.013-3.el6.x86_64--> running transaction check---> package perl-dbd-mysql.x86_64 0:4.013-3.el6 will be erased--> finished dependency resolutiondependencies resolved================================================================================ package arch version repository size================================================================================removing: mysql-devel x86_64 5.6.19-1.linux_glibc2.5 installed 17 m mysql-shared x86_64 5.6.19-1.linux_glibc2.5 @/mysql-shared-5.6.19-1.linux_glibc2.5.x86_64 7.8 m mysql-shared-compat x86_64 5.6.19-1.linux_glibc2.5 @/mysql-shared-compat-5.6.19-1.linux_glibc2.5.x86_64 11 mremoving for dependencies: perl-dbd-mysql x86_64 4.013-3.el6 @base 338 ktransaction summary================================================================================remove 4 package(s)installed size: 36 mis this ok [y/n]: ydownloading packages:running rpm_check_debugrunning transaction testtransaction test succeededrunning transaction erasing : mysql-devel-5.6.19-1.linux_glibc2.5.x86_64 1/4 erasing : perl-dbd-mysql-4.013-3.el6.x86_64 2/4 erasing : mysql-shared-compat-5.6.19-1.linux_glibc2.5.x86_64 3/4 erasing : mysql-shared-5.6.19-1.linux_glibc2.5.x86_64 4/4 verifying : mysql-shared-compat-5.6.19-1.linux_glibc2.5.x86_64 1/4 verifying : mysql-devel-5.6.19-1.linux_glibc2.5.x86_64 2/4 verifying : mysql-shared-5.6.19-1.linux_glibc2.5.x86_64 3/4 verifying : perl-dbd-mysql-4.013-3.el6.x86_64 4/4 removed: mysql-devel.x86_64 0:5.6.19-1.linux_glibc2.5 mysql-shared.x86_64 0:5.6.19-1.linux_glibc2.5 mysql-shared-compat.x86_64 0:5.6.19-1.linux_glibc2.5 dependency removed: perl-dbd-mysql.x86_64 0:4.013-3.el6 complete![root@localhost /]# yum remove mysql-*loaded plugins: fastestmirror, refresh-packagekit, securitysetting up remove processno match for argument: mysql-*loading mirror speeds from cached hostfile * base: mirrors.163.com * extras: mirrors.163.com * updates: mirrors.163.compackage(s) mysql-* available, but not installed.no packages marked for removal[root@localhost /]# whereis mysqlmysql: /usr/lib64/mysql[root@localhost /]# which mysql/usr/bin/which: no mysql in (/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/default7/bin)[root@localhost /]# yum remove mysql-sharedloaded plugins: fastestmirror, refresh-packagekit, securitysetting up remove processno match for argument: mysql-sharedloading mirror speeds from cached hostfile * base: mirrors.163.com * extras: mirrors.163.com * updates: mirrors.163.comno packages marked for removal[root@localhost /]# whereis mysqlmysql: /usr/lib64/mysql[root@localhost /]# which mysql/usr/bin/which: no mysql in (/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/default7/bin)[root@localhost /]# yum remove mysql-testloaded plugins: fastestmirror, refresh-packagekit, securitysetting up remove processno match for argument: mysql-testloading mirror speeds from cached hostfile * base: mirrors.btte.net * extras: mirrors.btte.net * updates: mirrors.btte.netpackage(s) mysql-test available, but not installed.no packages marked for removal[root@localhost /]# clear
其实我一直不断的重新安装，总是问题，无法启动或者报错，原因在与第一次安装步骤不正确，然后接下来不断的重装。
但是并没有彻底卸载干净。rpm -e mysql 这个似乎区分大小写，而我一开始直接删除文件夹来卸载，后来用 rpm -e -nodeps mysql来卸载，但是还是有残留。
最后是用的yum remove mysql ,mysql-server,mysql-shared 来卸载，为了卸载干净，之后，将所有文件夹中有mysql的删除掉。然后再重新安装。
[root@localhost mysqlinstall]# lsmysql-client-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-devel-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-embedded-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-server-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-shared-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-shared-compat-5.6.19-1.linux_glibc2.5.x86_64.rpmmysql-test-5.6.19-1.linux_glibc2.5.x86_64.rpm[root@localhost mysqlinstall]# rpm -ivh mysql-server-*.rpmpreparing... ########################################### [100%] 1:mysql-server ########################################### [100%][root@localhost mysqlinstall]# rpm -ivh mysql-client-*.rpmpreparing... ########################################### [100%] 1:mysql-client ########################################### [100%][root@localhost mysqlinstall]# rpm -ivh mysql-devel-*.rpmpreparing... ########################################### [100%] 1:mysql-devel ########################################### [100%][root@localhost mysqlinstall]# service mysql status error! mysql is not running[root@localhost mysqlinstall]# service mysql startstarting mysql.. success!
修改设置密码，原始密码在/root/这个文件夹里面，ls -a可以看到一个mysql的文件，里面有原始密码：
mysql> show databases;error 1820 (hy000): you must set password before executing this statementmysql> select user();error 1820 (hy000): you must set password before executing this statementmysql> set password=password('zbphp.com');query ok, 0 rows affected (0.00 sec)mysql> show user();error 1064 (42000): you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'user()' at line 1mysql> select user();+----------------+| user() |+----------------+| root@localhost |+----------------+1 row in set (0.00 sec)mysql> show databases;+--------------------+| database |+--------------------+| information_schema || mysql || performance_schema || test |+--------------------+4 rows in set (0.01 sec)mysql> select version();+-----------+| version() |+-----------+| 5.6.19 |+-----------+1 row in set (0.00 sec)mysql>