centos7安装MySQL-server-5.6.13-1.el6.x86_64.rpm

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

 

首先下载下面三个文件:

 

 

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  

-----自注-----------

以上三个软件下载地址:

http://pan.baidu.com/s/1qXDnSUK

http://pan.baidu.com/s/1qY8KwQ4

http://pan.baidu.com/s/1hrKVLfI

 

然后使用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

-----------自注:---------------------------------------

如果出现:Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).赋予目录执行权限/var/lib/mysql。

chmod 777 -R /var/lib/mysql

 

使用命令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密码:

==========================================================================

自注:

第一次登陆mysql,设置密码:

1.mysql,回车

2.mysql>use mysql;

3.mysql> update user set password=password('root') where user='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0
4.重启mysql服务。service mysql restart

5.就可以登陆mysql。mysql -uroot -p

=================================================================================

首先查看 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 |  

+-----------------------+------+  
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即可远程登陆。

service mysql start出错,mysql启动不了,解决mysql: unrecognized service错误

service mysql start出错,mysql启动不了,解决mysql: unrecognized service错误的方法如下:

[root@ctohome.com ~]# service mysql start
mysql: unrecognized service
[root@ctohome.com ~]# service mysql restart
mysql: unrecognized service
 
[root@ctohome.com ~]# rpm -q mysql   查询发现mysql已经正常安装
mysql-5.1.52-jason.1

[root@ctohome.com ~]# /etc/rc.d/init.d/mysqld start  直接启动没问题
Starting mysqld:  [  OK  ]

 
[root@ctohome.com ~]# ls  /etc/rc.d/init.d/mysqld  -l
-rwxr-xr-x 1 root root 5509 Dec 18 02:31 /etc/rc.d/init.d/mysqld

[root@ctohome.com ~]# chkconfig mysqld on 设置mysql开机启动

[root@ctohome.com ~]# chmod 755 /etc/rc.d/init.d/mysqld  修改mysqld执行权限

[root@ctohome.com ~]# service mysqld start  搞定
Starting mysqld:  [  OK  ]
[root@ctohome.com ~]# service mysqld start
Starting mysqld:  [  OK  ]
[root@ctohome.com ~]# service mysqld status
mysqld (pid 9487) is running...

转载于:https://my.oschina.net/bysu/blog/747743

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值