CentOS6.8下安装MySQL5.6详解数据库

rpm -qa | grep mysql 

rpm -e mysql       　　　　　　//普通删除模式 
rpm -e --nodeps mysql        // 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除 

yum -y install make gcc-c++ cmake bison-devel  ncurses-devel 

#wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz 
#tar xvf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz 
#mv mysql-5.6.35-linux-glibc2.5-x86_64 /usr/local/mysql 

#groupadd mysql 
#useradd -r -g mysql mysql -d /usr/local/mysql 
#echo "mima" | passwd --stdin mysql 

chown -R mysql:mysql /usr/local/mysql 

#su - mysql 
#/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 
#exit 

#cd /usr/local/mysql/support-files 
#cp my-default.cnf /etc/my.cnf 

#cp mysql.server /etc/init.d/mysql 
#chkconfig mysql on 

#vim /etc/profile 
export MYSQL_HOME="/usr/local/mysql" 
export PATH="$PATH:$MYSQL_HOME/bin" 
#source /etc/profile 

service mysql start 

mysqladmin -u root password '123456' 

#vim /etc/my.cnf 
[mysqld] 
basedir=/usr/local/mysql 
datadir=/usr/local/mysql/data 
port=3306 
server_id=1 
socket=/tmp/mysql.sock 

#mysql -u root -p 
#mysql命令行输入 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 
FLUSH PRIVILEGES;

1.查看CentOS下是否已安装mysql 
[[email protected] ~]# yum list installed | grep mysql 
 
2.删除已安装mysql 
[[email protected] ~]# yum -y remove mysql 
 
3.查看yum库中的mysql（非必须） 
[[email protected] ~]# yum list | grep mysql 
 
4.从yum库中的安装mysql 
[[email protected] ~]# yum -y install mysql mysql-server mysql-devel 
 
5.验证是否安装成功 
[[email protected] ~]# rpm -qi mysql-server 
 
6.启动MySql服务 
[[email protected] ~]# /etc/init.d/mysqld start 
 
7.登录并设置密码 
[[email protected] ~]# mysql -u root 
mysql> show databases; 
mysql>  use mysql;  
mysql> update user set password=password('123456') where user='root'; 
 
8.开放远程登录权限 
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 
Query OK, 0 rows affected (0.00 sec) 
mysql> FLUSH PRIVILEGES; 
Query OK, 0 rows affected (0.00 sec) 
 
9.设置开机启动（非必须） 
chkconfig mysqld on