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。。。