Home > Developer > Linux

Correct command for installing mariadb on centos7

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

Correct command for installing mariadb on centos7

The centos7 System of linode is used, and mariadb is used by default when mysql is installed.

However, no matter whether you use the linode official website instructions or the basic installation method found by Baidu, the installation fails.

Always prompt this sentence:

ERROR2002 (HY000): Can 'tconnecttolocalmysqlserverthroughsocket '/var/lib/mysql. sock' (2)

Finally, google search for install mariadb on centos 7 to get the key step of installation.

Now that the installation is successful, please note the entire installation process:

[Php] view plaincopy
  1. Mysql: [root @ localhost ~] # Yum-yinstallmariadb *
  2. Loadedplugins: fastestmirror
  3. Loadingtransferspeedsfromcachedhostfile
  4. * Base: mirrors.linode.com
  5. * Extras: mirrors.linode.com
  6. * Updates: mirrors.linode.com
  7. ResolvingDependencies
  8. --> Runningtransactioncheck
  9. ---> Packagemariadb. x86_641: 5.5.37-1. el7_0willbeinstalled
  10. ---> Packagemariadb-bench.x86_641: 5.5.37-1. el7_0willbeinstalled
  11. ---> Packagemariadb-devel.x86_641: 5.5.37-1. el7_0willbeinstalled
  12. ---> Packagemariadb-embedded.x86_641: 5.5.37-1. el7_0willbeinstalled
  13. ---> Packagemariadb-embedded-devel.x86_641: 5.5.37-1. el7_0willbeinstalled
  14. ---> Packagemariadb-libs.x86_641: 5.5.37-1. el7_0willbeinstalled
  15. ---> Packagemariadb-server.x86_641: 5.5.37-1. el7_0willbeinstalled
  16. --> ProcessingDependency: perl-DBD-MySQLforpackage: 1: mariadb-server-5.5.37-1.el7_0.x86_64
  17. ---> Packagemariadb-test.x86_641: 5.5.37-1. el7_0willbeinstalled
  18. --> Runningtransactioncheck
  19. ---> Packageperl-DBD-MySQL.x86_640: 4.023-5. el7willbeinstalled
  20. --> FinishedDependencyResolution
  22. DependenciesResolved
  24. ========================================================== ========================================================== ======================================
  25. PackageArchVersionRepositorySize
  26. ========================================================== ========================================================== ======================================
  27. Installing:
  28. Mariadbx86_641: 5.5.37-1. el7_0updates8.9M
  29. Mariadb-benchx86_641: 5.5.37-1. el7_0updates385k
  30. Mariadb-develx86_641: 5.5.37-1. el7_0updates744k.
  31. Mariadb-embeddedx86_641: 5.5.37-1. el7_0updates3.6M.
  32. Mariadb-embedded-develx86_641: 5.5.37-1. el7_0updates7.4M.
  33. Mariadb-libsx86_641: 5.5.37-1. el7_0updates752k
  34. Mariadb-serverx86_641: 5.5.37-1. el7_0updates11M.
  35. Mariadb-testx86_641: 5.5.37-1. el7_0updates7.9M.
  36. Installingfordependencies:
  37. Perl-DBD-MySQLx86_644.023-5.el7base140k
  39. TransactionSummary
  40. ========================================================== ========================================================== ======================================
  41. Install8Packages (+ 1 Dependentpackage)
  43. Totaldownloadsize: 40 M
  44. Installedsize: 279 M
  45. Downloadingpackages:
  46. (1/9): mariadb-bench-5.5.37-1.el7_0.x86_64.rpm | small kb00: 00: 00
  47. (2/9): mariadb-devel-5.5.37-1.el7_0.x86_64.rpm | 744kB00: 00: 00
  48. (3/9): mariadb-embedded-5.5.37-1.el7_0.x86_64.rpm | 3.6MB00: 00: 00
  49. (4/9): mariadb-5.5.37-1.el7_0.x86_64.rpm | 8.9MB00: 00: 00
  50. (5/9): mariadb-libs-5.5.37-1.el7_0.x86_64.rpm | 752kB00: 00: 00
  51. (6/9): mariadb-server-5.5.37-1.el7_0.x86_64.rpm | 11MB00: 00: 00
  52. (7/9): mariadb-embedded-devel-5.5.37-1.el7_0.x86_64.rpm | 7.4MB00: 00: 00
  53. (8/9): mariadb-test-5.5.37-1.el7_0.x86_64.rpm | 7.9MB00: 00: 00
  54. (9/9): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm | 140kB00: 00: 00
  55. Bytes ----------------------------------------------------------------------------------------------------------
  56. Total36MB/s | 40MB00: 00: 01
  57. Runningtransactioncheck
  58. Runningtransactiontest
  59. Transactiontestsucceeded
  60. Runningtransaction
  61. Installing: 1: mariadb-libs-5.5.37-1.el7_0.x86_641/9
  62. Installing: 1: mariadb-5.5.37-1.el7_0.x86_642/9
  63. Installation: perl-DBD-MySQL-4.023-5.el7.x86_643/9
  64. Installing: 1: mariadb-server-5.5.37-1.el7_0.x86_644/9
  65. Installing: 1: mariadb-devel-5.5.37-1.el7_0.x86_645/9
  66. Installing: 1: mariadb-embedded-5.5.37-1.el7_0.x86_646/9
  67. Installing: 1: mariadb-embedded-devel-5.5.37-1.el7_0.x86_647/9
  68. Installing: 1: mariadb-test-5.5.37-1.el7_0.x86_648/9
  69. Installing: 1: mariadb-bench-5.5.37-1.el7_0.x86_649/9
  70. Verifying: 1: mariadb-test-5.5.37-1.el7_0.x86_641/9
  71. Verifying: 1: mariadb-embedded-devel-5.5.37-1.el7_0.x86_642/9
  72. Verifying: 1: mariadb-embedded-5.5.37-1.el7_0.x86_643/9
  73. Verifying: 1: mariadb-libs-5.5.37-1.el7_0.x86_644/9
  74. Verifying: 1: mariadb-bench-5.5.37-1.el7_0.x86_645/9
  75. Verifying: 1: mariadb-5.5.37-1.el7_0.x86_646/9
  76. Verifying: 1: mariadb-server-5.5.37-1.el7_0.x86_647/9
  77. Verifying: perl-DBD-MySQL-4.023-5.el7.x86_648/9
  78. Verifying: 1: mariadb-devel-5.5.37-1.el7_0.x86_649/9
  80. Installed:
  81. Mariadb. x86_641: 5.5.37-1. el7_0mariadb-bench.x86_641: 5.5.37-1. el7_0
  82. Mariadb-devel.x86_641: 5.5.37-1. el7_0mariadb-embedded.x86_641: 5.5.37-1. el7_0
  83. Mariadb-embedded-devel.x86_641: 5.5.37-1. el7_0mariadb-libs.x86_641: 5.5.37-1. el7_0
  84. Mariadb-server.x86_641: 5.5.37-1. el7_0mariadb-test.x86_641: 5.5.37-1. el7_0
  86. DependencyInstalled:
  87. Perl-DBD-MySQL.x86_640: 4.023-5. el7
  89. Complete!
  90. [Root @ localhost ~] # Systemctlstartmariadb. service
  91. [Root @ localhost ~] # Systemctlenablemariadb. service
  92. Ln-s '/usr/lib/systemd/system/mariadb. service'/etc/systemd/system/multi-user.target.wants/mariadb. servi
  93. Ce'
  94. [Root @ localhost ~] # Mysql
  95. WelcometotheMariaDBmonitor. Commandsendwith; or \ g.
  96. YourMariaDBconnectionidis2
  97. Serverversion: 5.5.37-MariaDBMariaDBServer
  99. Copyright (c) 2000,2014, Oracle, MontyProgramAbandothers.
  101. Type 'help; 'or' \ H' forhelp. Type '\ C' toclearthur ecurrentinputstatement.
  103. MariaDB [(none)]> logout
  104. -> Exit
  105. ->
  106. ->;
  107. ERROR1064 (42000): YouhaveanerrorinyourSQLsyntax; checkthemanualthatcorrespondstoyourMariaD
  108. Bserverversionfortherightsyntaxtousenear 'logout
  109. Exit 'atline1
  110. MariaDB [(none)]> exit
  111. Bye
  112. [Root @ localhost ~] # Systemctlenablemariadb. service
  113. [Root @ localhost ~] # Mysql
  114. WelcometotheMariaDBmonitor. Commandsendwith; or \ g.
  115. YourMariaDBconnectionidis3
  116. Serverversion: 5.5.37-MariaDBMariaDBServer
  118. Copyright (c) 2000,2014, Oracle, MontyProgramAbandothers.
  120. Type 'help; 'or' \ H' forhelp. Type '\ C' toclearthur ecurrentinputstatement.
  122. MariaDB [(none)]> showdatabases;
  123. + -------------------- +
  124. | Database |
  125. + -------------------- +
  126. | Information_schema |
  127. | Mysql |
  128. | Performance_schema |
  129. | Test |
  130. + -------------------- +
  131. 4 rowsinset (0.00sec)
  133. MariaDB [(none)]> usetest
  134. Databasechanged
  135. MariaDB [test]> showtables;
  136. Emptyset (0.00sec)
  138. MariaDB [test]> exit
  139. Bye
  140. [Root @ localhost ~] # Mysql_secure_installation
  141. /Usr/bin/mysql_secure_installation: line379: find_mysql_client: commandnotfound
  143. NOTE: RUNNINGALLPARTSOFTHISSCRIPTISRECOMMENDEDFORALLMariaDB
  144. SERVERSINPRODUCTIONUSE! PLEASEREADEACHSTEPCAREFULLY!
  146. Inordertologtailmariadbtosecureit, we 'llneedthecurrent
  147. Passwordfortherootuser. Ifyou 'vejustinstalledmariadb, and
  148. Youhaven 'tsettherootpasswordyet, thepasswordwillbeblank,
  149. Soyoushouldjustpressenterhere.
  151. ERROR1045 (28000): Accessdeniedforuser 'root' @ 'localhost' (usingpassword: YES)
  152. Entercurrentpasswordforroot (enterfornone ):
  153. OK, successfullyusedpassword, movingon...
  155. Settingtherootpasswordensuresthatnobodycanlog=themariadb
  156. Rootuserwithouttheproperauthorisation.
  158. Setrootpassword? [Y/n] y
  159. Newpassword:
  160. Re-enternewpassword:
  161. Passwordupdatedsuccessfully!
  162. Reloadingprivilegetables ..
  163. ... Success!
  166. Bydefault, amariadbinstallationhasanonymoususer, allowinganyone
  167. Tologtailmariadbwithouthavingtohaveauseraccountcreatedfor
  168. Them. Thisisintendedonlyfortesting, andtomaketheinstallation
  169. Goabitsmoother. youshouldremovethembeforemovingtransfera
  170. Productionenvironment.
  172. Removeanonymoususers? [Y/n] y
  173. ... Success!
  175. Normally, rootshouldonlybeallowedtoconnectfrom 'localhost'. This
  176. Ensuresthatsomeonecannotguessattherootpasswordfromthenetwork.
  178. Disallowrootloginremotely? [Y/n] y
  179. ... Success!
  181. Bydefault, MariaDBcomeswithadatabasenamed 'test' thatanyonecan
  182. Access. Thisisalsointendedonlyfortesting, andshouldberemoved
  183. Beforemovingpaiaproductionenvironment.
  185. Removetestdatabaseandaccesstoit? [Y/n] y
  186. -Droppingtestdatabase...
  187. ... Success!
  188. -Removingprivilegesontestdatabase...
  189. ... Success!
  191. Reloadingtheprivilegetableswillensurethatallchangesmadesofar
  192. Willtakespontimmediately.
  194. Reloadprivilegetablesnow? [Y/n] y
  195. ... Success!
  197. Cleaningup...
  199. Alldone! Ifyou 'vecompletedalloftheabovesteps, yourMariaDB
  200. Installationshouldnowbesecure.
  202. ThanksforusingMariaDB!
  203. [Root @ localhost ~] # Mysql-uroot-p
  204. Enterpassword:
  205. WelcometotheMariaDBmonitor. Commandsendwith; or \ g.
  206. YourMariaDBconnectionidis15
  207. Serverversion: 5.5.37-MariaDBMariaDBServer
  209. Copyright (c) 2000,2014, Oracle, MontyProgramAbandothers.
  211. Type 'help; 'or' \ H' forhelp. Type '\ C' toclearthur ecurrentinputstatement.
  213. MariaDB [(none)]> showdatabases;
  214. + -------------------- +
  215. | Database |
  216. + -------------------- +
  217. | Information_schema |
  218. | Mysql |
  219. | Performance_schema |
  220. | Zbphp.com |
  221. + -------------------- +
  222. 4 rowsinset (0.00sec)
  224. MariaDB [(none)]>

Article by default7 # zbphp.com

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
correct name on facebook mariadb command line installing rss feed on website installing norton on windows 10 mariadb backup command line mariadb windows command line installing php on windows 7

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More