linux下MySQL安装

centos6

1.检测系统自带Mysql，并卸载

	[root@hadoop eclipse]# rpm -qa | grep mysql
	mysql-libs-5.1.66-2.el6_3.x86_64
	[root@hadoop eclipse]# rpm -e mysql-libs-5.1.66-2.el6_3.x86_64 --nodeps

2.通过网络安装MySQL （yum）

yum -y install mysql mysql-devel mysql-server

3.启动服务

	# service mysqld start

开机自启动

	# chkconfig mysqld on

4.设置用户和密码

	#/usr/bin/mysqladmin -uroot password '123456'

5.进入mysql

	mysql -uroot -p123456

6.查看mysql用户

	select host,user,password from mysql.user;

7.允许远程访问mysql

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

8.重载授权表：

	FLUSH PRIVILEGES;