导航：首页 > 数据库 >

Centos6.5安装MySql

发表于：2024-09-30 作者：千家信息网编辑

千家信息网最后更新 2024年09月30日，安装MySql方法有多种方式，如下图：序号MySql安装方式特点说明1yum/rpm包安装特点是简单、速度快，但是没法定制安装，入门新手常用这种方式2二进制安装解压软件，简单配置后就可以使用，不用安装

千家信息网最后更新 2024年09月30日Centos6.5安装MySql

安装MySql方法有多种方式，如下图：

序号	MySql安装方式	特点说明
1	yum/rpm包安装	特点是简单、速度快，但是没法定制安装，入门新手常用这种方式
2	二进制安装	解压软件，简单配置后就可以使用，不用安装，速度较快，专业DNA喜欢这种方式。软件名如：mysql-5.5.32-linux2.6_x86_64.tar.gz
3	源码编译安装	特点是可以定制安装，但是安装时间长，例如：字符集安装路径，等等。软件名称如：mysql-5.5.32.tar.gz
4	源码软件结合yum/rpm安装	把源码软件制作成符合要求的rpm，放到yum仓库里，然后通过yum来安装。结合了上面1和3的优点，即安装快速，可做生意定制参数，但是安装者也需要具有更深能力

下面演示yum和编译安装：

一、yum安装

1、关闭iptables

[root@mysql ~]# /etc/init.d/iptables stopiptables: Setting chains to policy ACCEPT: filter          [  OK  ]iptables: Flushing firewall rules:                         [  OK  ]iptables: Unloading modules:                               [  OK  ][root@mysql ~]# /etc/init.d/iptables stop[root@mysql ~]# chkconfig iptables off

2、关闭SELinux

[root@mysql ~]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config[root@mysql ~]# setenforceusage:  setenforce [ Enforcing | Permissive | 1 | 0 ][root@mysql ~]# setenforce 0[root@mysql ~]# getenforcePermissive

3、安装mysql

[root@mysql ~]# yum -y install mysql mysql-server mysql-develLoaded plugins: fastestmirror, securitybase                                                     | 3.7 kB     00:00     base/primary_db                                          | 4.6 MB     00:30     extras                                                   | 3.4 kB     00:00     extras/primary_db                                        |  37 kB     00:00     updates                                                  | 3.4 kB     00:00     updates/primary_db                                       | 5.2 MB     00:43...略[root@mysql ~]# chkconfig mysqld on                                  #开机启动[root@mysql ~]# chkconfig --list | grep mysqld#查询是否开机启动mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off[root@mysql ~]# service mysqld start#启动服务Starting mysqld:                                           [  OK  ]  [root@mysql ~]# mysql                                                #进入mysqlWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.1.73 Source distributionCopyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> CREATE DATABASE wordpress;#创建一个名称为wordpress的数据库Query OK, 1 row affected (0.00 sec)mysql> select user,host,password from mysql.user;                    #查询用户等信息+------+-----------+----------+| user | host      | password |+------+-----------+----------+| root | localhost |          || root | mysql     |          || root | 127.0.0.1 |          ||      | localhost |          ||      | mysql     |          |+------+-----------+----------+5 rows in set (0.00 sec)mysql> set password for root@localhost=password('root');#查询用户的密码，都为空，用上面的命令设置root的密码为rootQuery OK, 0 rows affected (0.00 sec)mysql> select user,host,password from mysql.user;                   #再次查询发现password下面已有密码信息+------+-----------+-------------------------------------------+| user | host      | password                                  |+------+-----------+-------------------------------------------+| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B || root | mysql     |                                           || root | 127.0.0.1 |                                           ||      | localhost |                                           ||      | mysql     |                                           |+------+-----------+-------------------------------------------+5 rows in set (0.00 sec)mysql> exitBye[root@mysql ~]#[root@mysql ~]# mysql -u root -p                                    #用新密码登录Enter password:                                                     #填写密码Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 6Server version: 5.1.73 Source distribution...略mysql> exit[root@mysql ~]#[root@mysql ~]# cat /etc/my.cnf #/etc/my.cnf是mysql的主配置文件[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid[root@mysql ~]#[root@mysql ~]# ls -l /var/lib/mysql/#mysql数据库的数据库文件存放位置total 20492-rw-rw----. 1 mysql mysql 10485760 May 16 22:30 ibdata1-rw-rw----. 1 mysql mysql  5242880 May 16 22:30 ib_logfile0-rw-rw----. 1 mysql mysql  5242880 May 16 22:30 ib_logfile1drwx------. 2 mysql mysql     4096 May 16 22:30 mysqlsrwxrwxrwx. 1 mysql mysql        0 May 16 22:30 mysql.sockdrwx------. 2 mysql mysql     4096 May 16 22:30 testdrwx------. 2 mysql mysql     4096 May 16 22:33 wordpress[root@mysql ~]#[root@mysql ~]# ls /var/log/#日志文件存放位置anaconda.ifcfg.log    anaconda.yum.log  dmesg       mysqld.log  tallyloganaconda.log          audit             dmesg.old   ntpstats    wtmpanaconda.program.log  boot.log          dracut.log  prelink     yum.loganaconda.storage.log  btmp              lastlog     saanaconda.syslog       ConsoleKit        maillog     secureanaconda.xlog         cron              messages    spooler[root@mysql ~]#[root@mysql ~]# netstat -lntup|grep 3306#查看mysql端口侦听状态tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      2053/mysqld[root@mysql ~]#

MySql密码忘记后重新设置：

#多次输入密码均不对[root@bogon ~]# mysql -u root -pEnter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)[root@bogon ~]# mysql -u root -pEnter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)[root@bogon ~]# /application/mysql//bin/mysqladmin -u root password '789@!@#'#把root的mysql登录密码设置为789@!@#[root@bogon ~]# mysql -u root -p#输入密码789@!@#，进入mysqlEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 6Server version: 5.5.32 Source distributionCopyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

基本命令

show databases; //查看系统已存在的数据库

use databasesname; //选择需要使用的数据库

drop database databasename; //删除选定的数据库

exit //退出数据库的连接

create database test01; //建立名为test的数据库

show tables; // 列出当前数据库下的表

其他基本的增删改查使用标准SQL即可

开放远程登录权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

FLUSH PRIVILEGES;

参考：