一(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=””;
- 版權所有(yǒu):奇站網絡 轉載請(qing)注明出處
- 廈們(men)奇站網絡科(ke)技(ji)有(yǒu)限(xian)公(gōng)司,專(zhuan)業提供網站建(jian)設(shè),響應式(shi)網站建(jian)設(shè),小(xiǎo)程(cheng)序開髮(fa),係(xi)統定製(zhi)開髮(fa)。
- 軟件開髮(fa)咨詢熱線(xiàn):吳小(xiǎo)姐 13313868605
