linux mysql5.5 rpm_linux下安装mysql5.5.x rpm

环境RHEL5.7 64bit

查询是否已安装及卸载

下载

MySQL-5.5.36-1.rhel5.x86_64.rpm-bundle.tar

需要安装其中的服务器端和客户端，本文采用mysql用户安装

MySQL-server-5.5.36-1.rhel5.x86_64.rpm

MySQL-client-5.5.36-1.rhel5.x86_64.rpm

[root@dev ~]# mkdir /soft/MySQL-5.5.36

把安装文件上传至此目录

添加mysql组

[root@dev ~]# groupadd mysql

添加mysql用户

[root@dev ~]# useradd -g mysql mysql

[root@dev ~]# chown -R mysql /soft/MySQL-5.5.36

[root@dev ~]# su - mysql

[mysql@dev ~]$ cd /soft/MySQL-5.5.36

[mysql@dev MySQL-5.5.36]$ tar -xvf MySQL-5.5.36-1.rhel5.x86_64.rpm-bundle.tar

MySQL-client-5.5.36-1.rhel5.x86_64.rpm

MySQL-devel-5.5.36-1.rhel5.x86_64.rpm

MySQL-server-5.5.36-1.rhel5.x86_64.rpm

MySQL-shared-5.5.36-1.rhel5.x86_64.rpm

MySQL-test-5.5.36-1.rhel5.x86_64.rpm

MySQL-embedded-5.5.36-1.rhel5.x86_64.rpm

MySQL-shared-compat-5.5.36-1.rhel5.x86_64.rpm

[mysql@dev MySQL-5.5.36]$ chmod u+x MySQL-server-5.5.36-1.rhel5.x86_64.rpm

[mysql@dev MySQL-5.5.36]$ chmod u+x MySQL-client-5.5.36-1.rhel5.x86_64.rpm

安装服务器端

非root用户使用rpm可以采用 sudo 命令 的方式，sudo 需要配置

[mysql@dev MySQL-5.5.36]$ sudo rpm -ivh MySQL-server-5.5.36-1.rhel5.x86_64.rpm

Preparing...                ########################################### [100%]

1:MySQL-server           ########################################### [100%]

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h dev password 'new-password'

Alternatively you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.

See the manual for more instructions.

Please report any problems at http://bugs.mysql.com/

查看是否启动

[mysql@dev MySQL-5.5.36]$ netstat -nat

Active Internet connections (servers and established)

Proto Recv-Q Send-Q Local Address               Foreign Address             State

tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN

启动停止命令

[mysql@dev MySQL-5.5.36]$ /etc/init.d/mysql start

[mysql@dev MySQL-5.5.36]$ /etc/init.d/mysql stop

安装客户端

[mysql@dev MySQL-5.5.36]$ sudo rpm -ivh MySQL-client-5.5.36-1.rhel5.x86_64.rpm

Preparing...                ########################################### [100%]

1:MySQL-client           ########################################### [100%]

[mysql@dev MySQL-5.5.36]$ mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.5.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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.

mysql> exit;

Bye

修改root用户密码

[mysql@dev MySQL-5.5.36]$ mysqladmin -u root password "password"

[mysql@dev MySQL-5.5.36]$ mysql -u root -p

Enter password:输入密码

mysql> use mysql

mysql> select host,user,password from user;

+-----------+------+-------------------------------------------+

| host      | user | password                                  |

+-----------+------+-------------------------------------------+

| localhost | root | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |

| dev       | root |                                           |

| 127.0.0.1 | root |                                           |

| ::1       | root |                                           |

| localhost |      |                                           |

| dev       |      |                                           |

+-----------+------+-------------------------------------------+

6 rows in set (0.00 sec)

设置root用户可以远程连接，

此语句会在user表插一条记录

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

Query OK, 0 rows affected (0.00 sec)

#另一种方法，修改原有的记录

#mysql> UPDATE user SET Host='%' WHERE User='root' AND Host='localhost' LIMIT 1;

mysql> select host,user,password from user;

+-----------+------+-------------------------------------------+

| host      | user | password                                  |

+-----------+------+-------------------------------------------+

| localhost | root | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |

| dev       | root |                                           |

| 127.0.0.1 | root |                                           |

| ::1       | root |                                           |

| localhost |      |                                           |

| dev       |      |                                           |

| %         | root | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |

+-----------+------+-------------------------------------------+

7 rows in set (0.00 sec)

刷新权限

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit;

Bye

修改配置文件my.cnf

[mysql@dev MySQL-5.5.36]$ /etc/init.d/mysql stop

Shutting down MySQL...                                     [确定]

[mysql@dev MySQL-5.5.36]$ sudo cp /usr/share/mysql/my-medium.cnf /etc/my.cnf

编辑my.cnf

[client]

……

default-character-set = utf8 #设置客户端的字符编码

[mysqld]

character-set-server = utf8 #设置服务器端的字符编码 5.1的是default-character-set = utf8

lower_case_table_names=1 #设置表名不区分大小写

[mysql@dev MySQL-5.5.36]$ /etc/init.d/mysql start

[mysql@dev MySQL-5.5.36]$ mysql -u root -p

Enter password:输入密码

查看编码

mysql> show variables like '%char%';

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | utf8                       |

| character_set_connection | utf8                       |

| character_set_database   | utf8                       |

| character_set_filesystem | binary                     |

| character_set_results    | utf8                       |

| character_set_server     | utf8                       |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.00 sec)

查看排序规则

mysql> show variables like '%collation%';

+----------------------+-----------------+

| Variable_name        | Value           |

+----------------------+-----------------+

| collation_connection | utf8_general_ci |

| collation_database   | utf8_general_ci |

| collation_server     | utf8_general_ci |

+----------------------+-----------------+

3 rows in set (0.00 sec)

mysql>exit

Bye

其他操作

防火墙开启3306端口