Linux中rmp安装mysql

一.步骤：

1.查看是否已有MySQL库包        rpm  -ga  |  grep  mysql

2.卸载原有的MySQL库包        rmp  -e  --nodeps  mysql-libs-5.1.71-1.el6.x86_64

3.用rmp方式安装MySQL的server端（man  rpm  查看-ivh的具体意思）

rpm  -ivh  ./MySQL-server-5.5.47-1.linux2.6.x86_64.rpm

4.用rmp方式安装MySQL的client端

rpm  -ivh  ./MySQL-client-5.5.47-1.linux2.6.x86_64.rpm

5.查看MySQL数据库状态        service  mysql  status

6.启动MySQL数据库        service   mysql  start

7.进入MySQLroot用户        mysql  -uroot

8.设置数据库的root账户密码        

update mysql.user set password=PASSWORD ('123456') where User ='root';

9.打开远程访问连接（授权）

update mysql.user set host='%' where user='root' and host = '127.0.0.1';

10 .刷新授权        flush  privileges;

二.rpc在centos下安装的MySQL的乱码问题

1.安装MySQL之后默认的字符编码为latinl

在登陆MySQL之后可以通过   show variables like '%char%'  查看，显示如下：

+---------------------－+-----－－--------------
| Variable_name | Value
+-----------------------+-－－------------------
| character_set_client | latin1
| character_set_connection | latin1
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | latin1
| character_set_server | latin1
| character_set_system | utf8
| character_sets_dir | /usr/share/mysql/charsets/
+---------------------+－－－-------------------

2.

1) 进入/usr/share/mysql目录之后，拷贝my-medium.cnf到/etc下

[root@linuxidc mysql]# cp my-medium.cnf /etc/my.cnf

2) 编辑my.cnf        [root@linuxidc mysql]# vim my.cnf

3) 进入my.cnf后在my.cnf最后添加：

[client]
#password       = your_password
port            = 3306
#++++++++++++++++++++++++++++++++
default-character-set=utf8
#++++++++++++++++++++++++++++++++
socket          = /var/lib/mysql/mysql.sock

[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
#++++++++++++++++++++++++++++++++
default-storage-engine=INNODB   #（5.5之后的版本）
character-set-server=utf8
character-set-client=utf8
collation-server=utf8_general_ci
#++++++++++++++++++++++++++++++++
skip-external-locking

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
#++++++++++++++++++++++++++++++++
default-character-set=utf8
#++++++++++++++++++++++++++++++++

然后保存退出

3.重启MySQL服务

[root@linuxidc mysql]#  /etc/init.d/mysql restart

4.

登录mysql之后 再次通过show variables like '%char%'查看，显示如下

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client    | utf8                      |
| character_set_connection | utf8                      |
| character_set_database  | latin1                    |
| character_set_filesystem | binary                    |
| character_set_results    | utf8                      |
| character_set_server    | utf8                      |
| character_set_system    | utf8                      |
| character_sets_dir      | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

就解决完成了!

三.如果以上步骤出现错误，卸载rpm安装的MySQL

whereis mysql (查找mysql的所有安装目录)
which mysql   （查看mysql的运行文件所在位置）

rpm -qa | grep -i  mysql

rpm -e --nodeps mysql.server.................
rpm -e --nodeps mysql.client.................

find / -name mysql

/var/lib/mysql
/var/lib/mysql/mysql
/usr/lib64/mysql

[huaqiang@jy1610y /]$ sudo rm -rf /var/lib/mysql/
[huaqiang@jy1610y /]$ sudo rm -rf /var/lib/mysql/mysql
[huaqiang@jy1610y /]$ sudo rm -rf /usr/lib64/mysql/

[huaqiang@jy1610y etc]$ sudo rm -rf my.cnf 
[huaqiang@jy1610y etc]$ rpm -qa | grep mysql