mysql完整版_MYSQL安装（完整版）

一、完全卸载MYSQL

yum remove mysql mysql-server mysql-libs compat-mysql51

rm -rf /var/lib/mysql

rm /etc/my.cnf

#查看是否还有mysql软件：

rpm -qa|grep mysql

#如果存在的话，继续删除即可。

二、下载(MYSQL5.6)

MySQL-server(5.6)

MySQL-client (5.6)

MySQL-devel  (5.6)

三、安装

rpm -ivh MySQL-server-5.6.17-1.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-client-5.6.17-1.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-devel-5.6.17-1.linux_glibc2.5.x86_64.rpm

四、问题

ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NO)?

第一步：修改数据库默认密码/etc/init.d/mysql stop   (service mysqld stop )/usr/bin/mysqld_safe --skip-grant-tables另外开个SSH连接[root@localhost ~]# mysqlmysql>use mysqlmysql>update user set password=password("123456") where user="root";mysql>flush privileges;mysql>exit第二步：[mysql@localhost etc]$ ps -A | grep mysql4532 pts/0    00:00:00 mysqld_safe5542 pts/0    00:00:00 mysqld[mysql@localhost etc]$ kill -9 4532 5542正常启动 MySQL：/etc/init.d/mysql start   (service mysql start)第三步：

[root@linux-ke bob]# mysql -u root -p

Enter password:

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

Your MySQL connection id is 2

Server version: 5.6.17

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

第四步：

Server version: 5.6.17

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> show databases;

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

mysql> SET PASSWORD = PASSWORD('123456');

Query OK, 0 rows affected (0.00 sec)

mysql> show databases;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| test |

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

4 rows in set (0.00 sec)

mysql>

完成