阿裏雲centos 6.8安(an)裝(zhuang)mysql5.6

行業動(dòng)态 公(gōng)司新(xin)聞 案例分(fēn)享 技(ji)術(shù)百(bai)科(ke)

阿裏雲centos 6.8安(an)裝(zhuang)mysql5.6

來源:奇站網絡 浏覽量:3,060 髮(fa)布日(ri)期: 2017-10-13

一(yi)、檢(jian)查係(xi)統昰(shi)否安(an)裝(zhuang)其他(tā)版本(ben)的(de)MYSQL數(shu)據

yum list installed | grep mysql

yum -y remove mysql-libs.x86_64

二、安(an)裝(zhuang)及(ji)配(pei)置

wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

rpm -ivh mysql-community-release-el6-5.noarch.rpm

查看可(kě)以(yi)安(an)裝(zhuang)的(de)版本(ben)

yum repolist all | grep mysql

1、安(an)裝(zhuang)MYSQL數(shu)據庫

yum install mysql-community-server

2、設(shè)置爲(wei)開機(jī)啓動(dòng)

chkconfig —list | grep mysqld
chkconfig mysqld on

service mysqld start

3、設(shè)置密碼

/usr/bin/mysqladmin -u root password 123456

4、修改root密碼

mysql -u root -p 123456

select user,host,password from mysql.user;
set password for root@localhost=password (xxx);
set password for root@127.0.0.1=password (xxx);

删除匿名(míng)用(yong)戶(hu)

delete from mysql.user where user=””;

标簽:
上一(yi)篇

廈們(men)奇站網絡科(ke)技(ji)有(yǒu)限(xian)公(gōng)司

電(dian)話(hua):13313868605

QQ:3413772931

地阯(zhi):廈們(men)集(ji)美區(qu)軟件園三期


                    掃一(yi)掃加(jia)我(wo)咨詢