centos mysql 5.1_CentOS 下安装MySQL 默认源为5.1版本

CentOS——默认为安装5.1版本，如果需要安装5.5版本，需要使用remi源

yum install mysql-server –enablerepo=remi

Ubuntu——默认为安装5.5版本

apt-get install mysql-server

CentOS下直接yum安装

[root@10-4-5-9 ~]# yum list mysql

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

Available Packages

mysql.x86_64 5.1.73-3.el6_5 updates

[root@10-4-5-9 ~]# wget http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm

[root@10-4-5-9 ~]# ls

anaconda-ks.cfg epel-release-5-4.noarch.rpm install.log install.log.syslog

[root@10-4-5-9 ~]# rpm -ivh epel-release-5-4.noarch.rpm

#查看MySQL版本

[root@10-4-5-9 ~]# yum --enablerepo=remi,remi-test list mysql mysql-server

#安装MySQL

yum install mysql-server --enablerepo=remi

#查看安装好后的MySQL

[root@10-4-5-9 ~]# rpm -qa | grep mysql

mysql-5.5.39-1.el6.remi.x86_64

mysql-libs-5.5.39-1.el6.remi.x86_64

compat-mysql51-5.1.54-1.el6.remi.x86_64

mysql-server-5.5.39-1.el6.remi.x86_64

#启动MySQL

[root@10-4-5-9 ~]# service mysqld start

Starting mysqld: [ OK ]

#登陆MySQL

[root@10-4-5-9 ~]# mysql

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

Your MySQL connection id is 2

Server version: 5.5.39 MySQL Community Server (GPL) by Remi

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>

#查看MySQL用户

mysql> SELECT user,host FROM mysql.user;

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

| user | host |

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

| | 10-4-5-9 |

| root | 10-4-5-9 |

| root | 127.0.0.1 |

| root | ::1 |

| | localhost |

| root | localhost |

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

6 rows in set (0.00 sec)

#删除空用户

DROP USER ''@'10-4-5-9';

DROP USER ''@'localhost';

DROP USER 'root'@'::1';

#修改密码

mysql> UPDATE mysql.user SET password = PASSWORD('********') WHERE user = 'root';

Query OK, 3 rows affected (0.00 sec)

Rows matched: 3 Changed: 3 Warnings: 0

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

#重新登陆

[root@10-4-5-9 ~]# mysql -uroot -p

Enter password:

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

Your MySQL connection id is 4

Server version: 5.5.39 MySQL Community Server (GPL) by Remi

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>

一切OK。。。