1.
如果出现FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:Data::Dumper,执行:
#安装 perl-module #yum install -y perl-Module-Install.noarch
安装过程:
-
[root@localhost mysqlinstall]# ls
-
- MySQL-client-5.6.19-1.linux_glibc2.5.x86_64.rpm
- MySQL-devel-5.6.19-1.linux_glibc2.5.x86_64.rpm
- MySQL-embedded-5.6.19-1.linux_glibc2.5.x86_64.rpm
- MySQL-server-5.6.19-1.linux_glibc2.5.x86_64.rpm
- MySQL-shared-5.6.19-1.linux_glibc2.5.x86_64.rpm
- MySQL-shared-compat-5.6.19-1.linux_glibc2.5.x86_64.rpm
- MySQL-test-5.6.19-1.linux_glibc2.5.x86_64.rpm
- [root@localhost mysqlinstall]# rpm -ivh MySQL-server-*.rpm
- Preparing... ########################################### [100%]
- 1:MySQL-server ########################################### [100%]
- [root@localhost mysqlinstall]# rpm -ivh MySQL-client-*.rpm
- Preparing... ########################################### [100%]
- 1:MySQL-client ########################################### [100%]
- [root@localhost mysqlinstall]# rpm -ivh MySQL-devel-*.rpm
- Preparing... ########################################### [100%]
- 1:MySQL-devel ########################################### [100%]
- [root@localhost mysqlinstall]# service mysql status
- ERROR! MySQL is not running
- [root@localhost mysqlinstall]# service mysql start
- Starting MySQL.. SUCCESS!
修改设置密码,原始密码在/root/这个文件夹里面,ls -a可以看到一个mysql的文件,里面有原始密码:
mysql> set password=password(’123456‘);
mysql> update user set host = '%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)