博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
CentOS以RPM方式安装MYSQL
阅读量:6699 次
发布时间:2019-06-25

本文共 4499 字,大约阅读时间需要 14 分钟。

hot3.png

CentOS5.6以RPM方式安装MySQL5.6

1.检查MySQL及相关RPM包,是否安装,如果有安装,则移除(rpm –e 名称)

[root@localhost ~]# rpm -qa | grep -i mysqlmysql-libs-5.1.66-2.el6_3.x86_64[root@localhost ~]# yum -y remove mysql-libs*

如果卸载不掉提示异常,则可以强制卸载依赖

rpm -e --nodeps mysql-libs-5.1.66-2.el6_3.x86_64

2.下载Linux对应的RPM包,如:CentOS6.4_64对应的RPM包,如下:

[root@localhost rpm]# lltotal 74364-rw-r--r--. 1 root root 18442536 Dec 11 20:19 MySQL-client-5.6.15-1.el6.x86_64.rpm-rw-r--r--. 1 root root  3340660 Dec 11 20:06 MySQL-devel-5.6.15-1.el6.x86_64.rpm-rw-r--r--. 1 root root 54360600 Dec 11 20:03 MySQL-server-5.6.15-1.el6.x86_64.rpm

3.安装MySQL

[root@localhost rpm]# rpm -ivh MySQL-server-5.6.15-1.el6.x86_64.rpm[root@localhost rpm]# rpm -ivh MySQL-devel-5.6.15-1.el6.x86_64.rpm[root@localhost rpm]# rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm

出现以下文字表示安装成功

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !You will find that password in '/root/.mysql_secret'.You must change that password on your first connect,no other statement but 'SET PASSWORD' will be accepted.See the manual for the semantics of the 'password expired' flag.Also, the account for the anonymous user has been removed.In addition, you can run:  /usr/bin/mysql_secure_installationwhich will also give you the option of removing the test database.This is strongly recommended for production servers.See the manual for more instructions.Please report any problems with the /usr/bin/mysqlbug script!The latest information about MySQL is available on the web at  http://www.mysql.comSupport MySQL by buying support/licenses at http://shop.mysql.comNew default config file was created as /usr/my.cnf andwill be used by default by the server when you start it.You may edit this file to change server settings

4.配置MySQL配置

#修改配置文件位置[root@localhost rpm]# cp /usr/share/mysql/my-default.cnf /etc/my.cnf#修改配置参数(vim /etc/my.cnf 或者是/usr/my.cnf具体看MySQL安装之后的提示)[client]  password        = 123456  port            = 3306  default-character-set=utf8  [mysqld]  port            = 3306  character_set_server=utf8  character_set_client=utf8  collation-server=utf8_general_ci  #(注意linux下mysql安装完后是默认:表名区分大小写,列名不区分大小写; 0:区分大小写,1:不区分大小写)  lower_case_table_names=1  #(设置最大连接数,默认为 151,MySQL服务器允许的最大连接数16384; )  max_connections=1000  [mysql]  default-character-set = utf8

5.初始化MySQL及设置密码

[root@localhost rpm]# /usr/bin/mysql_install_db[root@localhost rpm]# service mysqld start[root@localhost rpm]# cat /root/.mysql_secret  #查看root账号密码# The random password set for the root user at Wed Dec 11 23:32:50 2013 (local time): qKTaFZnl[root@localhost ~]# mysql -uroot –pqKTaFZnlmysql> SET PASSWORD = PASSWORD('123456');    #设置密码为123456mysql> exit[root@localhost ~]# mysql -uroot -p123456

6.查看字符集

#查看字符集mysql> show variables like '%collation%';mysql> show variables like '%char%';

7.允许远程登陆

mysql> use mysql;mysql> select host,user,password from user;+-----------------------+------+-------------------------------------------+| host                  | user | password                                  |+-----------------------+------+-------------------------------------------+| localhost             | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 || localhost.localdomain | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 || 127.0.0.1             | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 || ::1                   | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |+-----------------------+------+-------------------------------------------+mysql> update user set password=password('123456') where user='root';mysql> update user set host='%' where user='root' and host='localhost';mysql> flush pr

7.1新建数据库账号

GRANT ALL PRIVILEGES ON *.* TO yhroot@"%" IDENTIFIED BY 'xxx密码' WITH GRANT OPTION;

8.设置开机自启动

[root@localhost ~]# chkconfig --levels 235 mysql on[root@localhost ~]# chkconfig --list | grep mysqlmysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off

9.MySQL的默认安装位置

/var/lib/mysql/               #数据库目录/usr/share/mysql              #配置文件目录/usr/bin                     #相关命令目录/etc/init.d/mysql              #启动脚本

参考:http://blog.csdn.net/liumm0000/article/details/18841197

------------------------------------------------进阶的分割线--------------------------------------------

在线安装:

CentOS 7的yum源中没有正常安装mysql时的mysql-sever文件,需要去官网上下载

# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm# rpm -ivh mysql-community-release-el7-5.noarch.rpm# yum install mysql-community-server

安装成功之后参考上面的配置方法即可。

更新:2017.03.14

 

转载于:https://my.oschina.net/dolphinboy/blog/701270

你可能感兴趣的文章
Java并发编程(多线程)中的相关概念
查看>>
6-14 数据库高级
查看>>
[QNAP crontab 定時執行程式
查看>>
listView当中有嵌套了有onClickListener的控件时ListView自身的onItemClick无响应的解决方案...
查看>>
本地浏览器缓存sessionStorage(临时存储) localStorage(长期存储)的使用
查看>>
python面试题目
查看>>
GIL , 线程池 , 同步 , 异步 , 队列 , 事件
查看>>
表单oninput和onchange事件区别
查看>>
[转]windows系统激活
查看>>
下划线按钮
查看>>
[JSOI2008]最小生成树计数
查看>>
Cantor定理的一种好表述
查看>>
陶哲轩实分析 定理 13.1.5
查看>>
Elementary Methods in Number Theory Exercise 1.5.13
查看>>
Oracle 制造死锁和查询死锁
查看>>
Python学习第一天-第2节
查看>>
Java二十三设计模式之------工厂方法模式
查看>>
读书笔记之何时重构(下)
查看>>
Java---利用程序实现在控制台聊天
查看>>
第一篇 计算机基础
查看>>