文章詳情頁
Centos7 下mysql重新啟動MariaDB篇
瀏覽:373日期:2023-03-30 13:21:15
前言
MariaDB數(shù)據(jù)庫管理系統(tǒng)是MySQL的一個分支,主要由開源社區(qū)在維護(hù),采用GPL授權(quán)許可。開發(fā)這個分支的原因之一是:甲骨文公司收購了MySQL后,有將MySQL閉源的潛在風(fēng)險,因此社區(qū)采用分支的方式來避開這個風(fēng)險。[3]
MariaDB的目的是完全兼容MySQL,包括API和命令行,使之能輕松成為MySQL的代替品。在存儲引擎方面,10.0.9版起使用XtraDB(名稱代號為Aria)來代替MySQL的InnoDB
# yum install mysql -y # mysql ERROR 2002 (HY000): Can"t connect to local MySQL server through socket "/var/lib/mysql/mysql.sock" (111) 試著去啟動mysql服務(wù),仍然不行 # systemctl start mysql Failed to issue method call: Unit mysql.service failed to load: No such file or directory. # systemctl start mysql.service Failed to issue method call: Unit mysql.service failed to load: No such file or directory # systemctl enable mysql.service Failed to issue method call: Access denied
下面講正確的步驟
# yum install mariadb-server -y systemctl stop mariadb.service # systemctl start mariadb.service # systemctl enable mariadb.service # mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 10 Server version: 5.5.44-MariaDB MariaDB Server Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type "help;" or "\h" for help. Type "\c" to clear the current input statement. MariaDB [(none)]>
搞定!
如何設(shè)置mysql root密碼
# mysql_secure_installation
總結(jié)
以上就是這篇文章的全部內(nèi)容了,希望本文的內(nèi)容對大家的學(xué)習(xí)或者工作能帶來一定的幫助,如果有疑問大家可以留言交流,謝謝大家對的支持。
標(biāo)簽:
MariaDB
相關(guān)文章:
1. CentOS 7中成功安裝MariaDB的方法教程2. CentOS6.7系統(tǒng)中編譯安裝MariaDB數(shù)據(jù)庫3. MariaDB表表達(dá)式之公用表表達(dá)式(CTE)4. MariaDB中1045權(quán)限錯誤導(dǎo)致拒絕用戶訪問的錯誤解決方法5. Window7安裝MariaDB數(shù)據(jù)庫及系統(tǒng)初始化操作分析6. Mariadb數(shù)據(jù)庫主從復(fù)制同步配置過程實例7. MariaDB數(shù)據(jù)庫的外鍵約束實例詳解8. 記一次mariadb數(shù)據(jù)庫無法連接9. MariaDB性能調(diào)優(yōu)工具mytop的使用詳解10. Mysql/MariaDB啟動時處于進(jìn)度條狀態(tài)導(dǎo)致啟動失敗的原因及解決辦法
排行榜
