虚拟机搭建CDH-第六讲-安装mysql第二种方法(通过rpm包安装)
1.上传安装文件到linux
MySQL-client-5.5.48-1.linux2.6.x86_64.rpm
MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
2.使用rpm命令安装mysql
rpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm
3.mini版本linux安装mysql执行上面语句会报错,说明缺少依赖
4.安装perl依赖,libaio-0.3.107-10.el6.x86_64.rpm
5.安装依赖 rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm
6.再安装mysql-server,rpm包冲突
8.卸载冲突的rpm包
rpm -e mysql-libs-5.1.73-5.el6_6.x86_64 --nodeps
9.再安装mysql-server和mysql-client
10.启动mysql服务,然后初始化mysql
service mysql start
/usr/bin/mysql_secure_installation 进行初始化
11.初始化
NOTE: RUNNING ALL PARTS OF THIS SCRIPT ISRECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASEREAD EACH STEP CAREFULLY!
In order to log into MySQL to secure it,we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, thepassword will be blank,
so you should just press enter here.
Enter current password for root (enter fornone):这里直接回车
OK, successfully used password, movingon...
Setting the root password ensures thatnobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] Y
New password:设置mysql root用户密码
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
...Success!
By default, a MySQL installation has ananonymous user, allowing anyone
to log into MySQL without having to have auser account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] Y
...Success!
Normally, root should only be allowed toconnect from 'localhost'. This
ensures that someone cannot guess at theroot password from the network.
Disallow root login remotely? [Y/n] Y
...Success!
By default, MySQL comes with a database named'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a productionenvironment.
Remove test database and access to it?[Y/n] Y
-Dropping test database...
...Success!
-Removing privileges on test database...
...Success!
Reloading the privilege tables will ensurethat all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] Y
...Success!
Cleaning up...
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
12.登录 mysql -uroot -proot
13.如果出现用户无法登录情况
状况如下
mysql -uroot -proot
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
如出现此错误
按照下面操作
1.停止mysqld服务
service mysqld stop
2.以跳过授权的方式启动mysql
mysqld_safe --skip-grant-tables &
3.以root用户登录mysql
mysql -u root
4.进入mysql数据库
mysql> use mysql
5.更新mysql数据库中的user表的root的password字段
mysql> update user set password=PASSWORD("new_password") where User="root";
6.刷新权限，使其立即生效，之后退出mysql，并重新启动mysql
mysql> flush privileges;
mysql> quit
# service restart