CentOS安装MySQL

CentOS在线安装MySQL

安装

1.yum -y install wget
2.wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 
3.rpm -ivh mysql-community-release-el7-5.noarch.rpm

4.yum -y install mysql-server
5.systemctl start mysql
systemctl enable mysql

远程授权

# 开放端口
firewall-cmd  --permanent  --add-port=3306/tcp
systemctl restart firewalld

# 没有密码
mysql -uroot -p  

mysql > use mysql;
mysql > update user set host='%' where user='root' and host='127.0.0.1';
mysql > flush privileges;

# 测试
telnet 192.168.100.10 3306

找回密码

编辑配置文件
vi /etc/my.cnf
[mysqld]
# 密码过期（单位：天）
default_password_lifetime = 0
# 跳过登录验证
skip-grant-tables

重启服务
systemctl restart mysqld

修改密码
use mysql
update user set authentication_string=password('新密码') where user='root';
flush privileges;

卸载

# 停止mysq服务
systemctl stop mysql

# 查询已经安装的软件
[root@localhost ~]# rpm -qa | grep mysql
mysql-community-common-5.6.51-2.el7.x86_64
mysql-community-client-5.6.51-2.el7.x86_64
mysql-community-release-el7-5.noarch
mysql-community-server-5.6.51-2.el7.x86_64
mysql-community-libs-5.6.51-2.el7.x86_64

# 卸载指定的软件
[root@localhost ~]# rpm -e --nodeps mysql-community-common-5.6.51-2.el7.x86_64 mysql-community-client-5.6.51-2.el7.x86_64 mysql-community-release-el7-5.noarch mysql-community-server-5.6.51-2.el7.x86_64 mysql-community-libs-5.6.51-2.el7.x86_64

# 查询残留文件，删除之
find / -iname mysql* -exec rm -rf {} \;

CentOS安装MySQL源码

准备

1.安装编译器
	yum -y install gcc gcc-c++ ncurses-devel perl cmake bison wget
	
2.下载MySQL源码
	wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.26.tar.gz

3.新建mysql系统用户
	groupadd mysql
	useradd -r -g mysql mysql 

4.新建安装目录，修改用户和组
	mkdir -p /usr/local/mysql/
	mkdir -p /usr/local/mysql/data/
	chown -R mysql:mysql /usr/local/mysql/

安装

1.解压mysql-5.6.26.tar.gz后进入主目录
	tar -zxvf mysql-5.6.26.tar.gz
	cd mysql-5.6.26/
	
2.检查平台和源码
	cmake \
	-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
	-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
	-DMYSQL_DATADIR=/usr/local/mysql/data \
	-DDEFAULT_CHARSET=utf8 \
	-DDEFAULT_COLLATION=utf8_general_ci \
	-DWITH_INNOBASE_STORAGE_ENGINE=1 \
	-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
	-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
	-DWITH_FEDERATED_STORAGE_ENGINE=1 \
	-DMYSQL_TCP_PORT=3306 \
	-DENABLE_DOWNLOADS=1

3.编译（时间有点长）
	make
	
4.安装
	make install
	
5.进入usr/local/mysql目录
	cd /usr/local/mysql
	./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/
	
6.拷贝配置文件
	cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
	cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

7.配置环境变量
	echo "export PATH=$PATH:/usr/local/mysql/bin" >> ~/.bashrc
	source ~/.bashrc
	
8.启动服务
	service mysqld start
	
9.登录（初始化没有密码）
	mysql -uroot -p
	
10.修改密码
	set password for 'root'@'localhost' = password('你的密码');
	flush privileges;

11.远程授权
	grant all privileges on *.* to 'root'@'%' identified by '你的密码' with grant option;
	flush privileges;
	
12.查看用户
	use mysql;
	select host,user,password from user;

卸载

1、停止服务
	service mysqld stop
	
2、卸载服务
	rm -rf /etc/init.d/mysqld
	
3、卸载配置文件
	rm -rf /etc/my.cnf
	
4、卸载主目录
	rm -rf /usr/local/mysql/
	
5、清除环境变量
	~/.bashrc