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_MySQL，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3739字，纯文字阅读大概需要6分钟。

内容图文

Redhat bitsCN.com

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

[root@localhost download]# rpm -ivh --replacefiles MySQL-server-5.6.13-1.el6.x86_64.rpm

Preparing... ########################################### [100%]

1:MySQL-server ########################################### [100%]

[root@localhost download]# rpm -ivh --replacefiles MySQL-client-5.6.13-1.el6.x86_64.rpm

Preparing... ########################################### [100%]

1:MySQL-client ########################################### [100%]

[root@localhost 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/mysql_install_db

3. 启动mysql服务：

service mysql start

使用命令ps -ef | grep mysql 查看mysql进程：

[root@localhost ~]# 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

root@localhost ~]# 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 ，然后输入上面的密码即可：

[root@localhost ~]# 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, Oracle 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

[root@localhost ~]# service mysql restart

Shutting down MySQL.. SUCCESS!

Starting MySQL.. SUCCESS!

重启mysql即可远程登陆。

bitsCN.com

内容总结

以上是互联网集市为您收集整理的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_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---