ä¼ è¾å®æåå°Yumåºå¯¼å
¥å°ä½ çæ¬å°ï¼
>sudo yum localinstall mysql-community-release-el6-*.noarch.rpm
è¿ä¸ªYumåºå
å«äºMySQLServerï¼MySQLå·¥ä½å°ç®¡çå·¥å
·ä»¥åODBC驱å¨ï¼ç°å¨å¯ä»¥éè¿ä¸é¢çå½ä»¤ç®åå°å®è£
MySQLServerï¼
>sudo yum install mysql-community-server
è³æ¤æå°±å¯ä»¥ä½¿ç¨Yumç®åå°ç®¡çMySQLæ´æ°ï¼å¹¶è½ç¡®ä¿æ»æ¯ä»å®ç½è½¯ä»¶åºå¾å°ææ°çåå¸çã
ï¼äºï¼ï¼å°è¿ä¸æ¥ï¼ä½ä¸ºæ°æï¼æ们ç»å¸¸ä¸ç¥émysqlé»è®¤çå¯ç ï¼æ æ³æ£å¸¸ä½¿ç¨mysqlï¼äºæ¯æ们å¾å
ä¿®æ¹mysqlçå¯ç ï¼
(1)设置mysqlçæ å¯ç ç»å½
>[root@localhost ~] # vim /etc/my.cnf
æ·»å ä¸è¡ "skip-grant-tables"ï¼ä¿åéåºã
(2)å¼å¯mysqlæå¡
>[root@localhost ~] mysql -u root -p
ç´æ¥æå车é®è¿å
¥mysqlæ令æä½çé¢
(3)å¨ä¿®æ¹mysqlå¯ç çæ¶åï¼è¦ä½¿ç¨å¦ä¸è¯å¥æä¼æå
> use mysql;
> update mysql.user set authentication_string=password('123qwe') where user='root' and Host ='localhost';
> flush privileges;
> quit;
ç»å¸¸æ¥éçä¸ä¸ªä¾åæ¯ä¸è¿°çauthentication_stringåæ¹ä¸ºpasswordåï¼æ°çæ¬çmysqlï¼å¯ç åçåå为authentication_stringã
(4)ç¶åè¿è¡ [root@localhost ~]# vim /etc/my.cnf
å»æ"skip-grant-tables"åï¼ä¿å该æ件ã
(5)è¿è¡[root@localhost ~]# service mysqld restart;
éå¯mysqlã
(6)è¿æ¶ååè¿è¡mysqlçè¯å¥ï¼å¯è½ä¼åºç°é误æ示ï¼You must reset your password using ALTER USER statement before executing this statement.
解å³æ¹æ¡ï¼
>SET PASSWORD = PASSWORD('9OP0(op)');
>ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
>flush privileges;
å®æ以ä¸ä¸æ¥ï¼ä½¿ç¨æ°è®¾ç½®çå¯ç å³å¯ã
温馨提示:答案为网友推荐,仅供参考