redhat6.3安装MySQL-server-5.6.13-1.el6.x86_64.rpm

页面导航:首页 > 数据库 > Mysql > redhat6.3安装MySQL-server-5.6.13-1.el6.x86_64.rpm

redhat6.3安装MySQL-server-5.6.13-1.el6.x86_64.rpm

来源: 作者: 时间:2016-02-17 10:07 【

redhat6.3安装MySQL-server-5.6.13-1.el6.x86_64.rpm首先下载下面三个文件:[plain]MySQL-client-5.6.13-1.el6.x86_64.rpm MySQL-devel-5.6.13-1.el6.x86_64.rpm MySQL-server-5.6.13-1.el6.x86_64.rpm 然后使...
redhat6.3安装MySQL-server-5.6.13-1.el6.x86_64.rpm
 
首先下面三个文件:
 
[plain] 
MySQL-client-5.6.13-1.el6.x86_64.rpm  
MySQL-devel-5.6.13-1.el6.x86_64.rpm  
MySQL-server-5.6.13-1.el6.x86_64.rpm  
然后使用root账号登陆,进行安装:
1. 安装server、devel、client:1. 安装server、devel、client:
 
rpm -ivh --replacefiles MySQL-s*.rpm 
rpm -ivh --replacefiles MySQL-d*.rpm
 
rpm -ivh --replacefiles MySQL-c*.rpm
 
 
[[email protected] download]# rpm -ivh --replacefiles MySQL-server-5.6.13-1.el6.x86_64.rpm   
Preparing...                ########################################### [100%]  
   1:MySQL-server           ########################################### [100%]  
[[email protected] download]# rpm -ivh --replacefiles MySQL-client-5.6.13-1.el6.x86_64.rpm   
Preparing...                ########################################### [100%]  
   1:MySQL-client           ########################################### [100%]  
[[email protected] download]# rpm -ivh --replacefiles MySQL-devel-5.6.13-1.el6.x86_64.rpm   
Preparing...                ########################################### [100%]  
   1:MySQL-devel            ########################################### [100%]
要移除安装可以使用 rpm -e MySQL-server  、 rpm -e MySQL-devel、MySQL-client即可;
2. 初始化: 
 
/usr/bin/_install_db 
 
3. 启动mysql服务:
 
service mysql start
 
使用命令ps -ef | grep mysql 查看mysql进程:
 
 
[[email protected] ~]# ps -ef | grep mysql  
root     26047     1  0 18:14 pts/12   00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid  
mysql    26227 26047  0 18:14 pts/12   00:00:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/localhost.localdomain.pid --socket=/var/lib/mysql/mysql.sock  
root     26545 24726  0 18:27 pts/8    00:00:00 grep mysql
4.第一次登陆设置root密码:
首先查看 cat /root/.mysql_secret
 
 
[email protected] ~]# cat /root/.mysql_secret   
# The random password set for the root user at Fri Aug 30 15:57:18 2013 (local time): fMYcarvB
然后命令行:mysql -u root -p ,然后输入上面的密码即可:
 
[[email protected] ~]# mysql -u root -p  
Enter password:   
Welcome to the MySQL monitor.  Commands end with ; or \g.  
Your MySQL connection id is 5  
Server version: 5.6.13 MySQL Community Server (GPL)  
  
Copyright (c) 2000, 2013, and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
设置root密码: 
 
mysql> use mysql  
Database changed  
mysql> update user set password=password('root') where user='root';  
Query OK, 0 rows affected (0.15 sec)  
Rows matched: 5  Changed: 0  Warnings: 0  
  
mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)
退出,重新登陆即可使用新的密码登陆;
5. 设置远程登陆:
 
使用root登陆到mysql后
 
 
mysql> update user set host='%' where user='root';  
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'  
mysql> select host,user from user;  
+-----------------------+------+  
| host                  | user |  
+-----------------------+------+  
| %                     | root |  
| 127.0.0.1             | root |  
| 192.168.128.142       | root |  
| ::1                   | root |  
| localhost.localdomain | root |  
+-----------------------+------+  
5 rows in set (0.00 sec)
然后:  
 
mysql> grant all privileges on *.* to 'root'@'%' with grant option;  
Query OK, 0 rows affected (0.08 sec)  
  
mysql> exit  
Bye  
[[email protected] ~]# service mysql restart  
Shutting down MySQL.. SUCCESS!   
Starting MySQL.. SUCCESS!   
重启mysql即可远程登陆。
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<