Home  >  Article  >  Database  >  本博客环境配置-----mysql的安装_MySQL

本博客环境配置-----mysql的安装_MySQL

WBOY
WBOYOriginal
2016-06-01 13:11:251037browse

前言:

      在这里我用的是rpm安装,当然你也可以选择yum install mysql 这种方式。(yum这种安装方式,我自己试了有点问题,于是就用rpm包安装了)

一、安装前准备:

手先需要下载如下的几个包,然后通过ftp上传到服务器中,当然也可以再网上找到源,通过wget命令下载下来。

推荐使用第二种,因为阿里云的服务器上传速度实在是不敢恭维,但是服务器端下载文件到时很快。

[root@AY130701184903434d7bZ mysql]# lsMySQL-client-5.5.30-1.el6.x86_64.rpmMySQL-devel-5.5.30-1.el6.x86_64.rpmMySQL-server-5.5.30-1.el6.x86_64.rpm

二、然后首先安装服务器端

[root@AY130701184903434d7bZ mysql]# rpm -ivh MySQL-server-5.5.30-1.el6.x86_64.rpm  显示如下信息。    warning: MySQL-server-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5  Preparing...       ########################################### [100%]  1:MySQL-server     ########################################### [100%]   。。。。。。(省略显示)

同样的方式,安装client端

安装完成后root用户默认密码为空,我们进去可以看到mysql数据库

mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || b3log              || mysql              || performance_schema || test               |+--------------------+5 rows in set (0.02 sec)

use mysql ,然后show tables看到如下表 ,

mysql> show tables;+---------------------------+| Tables_in_mysql           |+---------------------------+| columns_priv              || db                        || event                     || func                      || general_log               || help_category             || help_keyword              || help_relation             || help_topic                || host                      || ndb_binlog_index          || plugin                    || proc                      || procs_priv                || proxies_priv              || servers                   || slow_log                  || tables_priv               || time_zone                 || time_zone_leap_second     || time_zone_name            || time_zone_transition      || time_zone_transition_type || user                      |+---------------------------+24 rows in set (0.00 sec)

查看user表看到如下结果

mysql> select host,user,password from user;+-----------------------+------+-------------------------------------------+| host                                    | user | password |+-----------------------+------+-------------------------------------------+| %                                        | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B || AY130701184903434d7bZ | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B || 127.0.0.1                            | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B || localhost                             | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B || AY130701184903434d7bZ | | |+-----------------------+------+-------------------------------------------+5 rows in set (0.01 sec)

要配置远程登录host里面需要有%,(具体可以google)  
这样就可以了,有登录权限了,但是如果不能创建表或者数据库,那么就是用户权限的问题了。。

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn