Centos7: The correct command for installing mariadb, centos7mariadb

Centos7: The correct command for installing mariadb, centos7mariadb

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:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/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:

mysql:[root@localhost ~]# yum -y install mariadb*Loaded plugins: fastestmirrorLoading mirror speeds from cached hostfile * base: mirrors.linode.com * extras: mirrors.linode.com * updates: mirrors.linode.comResolving Dependencies--> Running transaction check---> Package mariadb.x86_64 1:5.5.37-1.el7_0 will be installed---> Package mariadb-bench.x86_64 1:5.5.37-1.el7_0 will be installed---> Package mariadb-devel.x86_64 1:5.5.37-1.el7_0 will be installed---> Package mariadb-embedded.x86_64 1:5.5.37-1.el7_0 will be installed---> Package mariadb-embedded-devel.x86_64 1:5.5.37-1.el7_0 will be installed---> Package mariadb-libs.x86_64 1:5.5.37-1.el7_0 will be installed---> Package mariadb-server.x86_64 1:5.5.37-1.el7_0 will be installed--> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.37-1.el7_0.x86_64---> Package mariadb-test.x86_64 1:5.5.37-1.el7_0 will be installed--> Running transaction check---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed--> Finished Dependency ResolutionDependencies Resolved========================================================================================================== Package                           Arch              Version                     Repository          Size==========================================================================================================Installing: mariadb                           x86_64            1:5.5.37-1.el7_0            updates            8.9 M mariadb-bench                     x86_64            1:5.5.37-1.el7_0            updates            385 k mariadb-devel                     x86_64            1:5.5.37-1.el7_0            updates            744 k mariadb-embedded                  x86_64            1:5.5.37-1.el7_0            updates            3.6 M mariadb-embedded-devel            x86_64            1:5.5.37-1.el7_0            updates            7.4 M mariadb-libs                      x86_64            1:5.5.37-1.el7_0            updates            752 k mariadb-server                    x86_64            1:5.5.37-1.el7_0            updates             11 M mariadb-test                      x86_64            1:5.5.37-1.el7_0            updates            7.9 MInstalling for dependencies: perl-DBD-MySQL                    x86_64            4.023-5.el7                 base               140 kTransaction Summary==========================================================================================================Install  8 Packages (+1 Dependent package)Total download size: 40 MInstalled size: 279 MDownloading packages:(1/9): mariadb-bench-5.5.37-1.el7_0.x86_64.rpm                                     | 385 kB  00:00:00(2/9): mariadb-devel-5.5.37-1.el7_0.x86_64.rpm                                     | 744 kB  00:00:00(3/9): mariadb-embedded-5.5.37-1.el7_0.x86_64.rpm                                  | 3.6 MB  00:00:00(4/9): mariadb-5.5.37-1.el7_0.x86_64.rpm                                           | 8.9 MB  00:00:00(5/9): mariadb-libs-5.5.37-1.el7_0.x86_64.rpm                                      | 752 kB  00:00:00(6/9): mariadb-server-5.5.37-1.el7_0.x86_64.rpm                                    |  11 MB  00:00:00(7/9): mariadb-embedded-devel-5.5.37-1.el7_0.x86_64.rpm                            | 7.4 MB  00:00:00(8/9): mariadb-test-5.5.37-1.el7_0.x86_64.rpm                                      | 7.9 MB  00:00:00(9/9): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                                       | 140 kB  00:00:00----------------------------------------------------------------------------------------------------------Total                                                                      36 MB/s |  40 MB  00:00:01Running transaction checkRunning transaction testTransaction test succeededRunning transaction  Installing : 1:mariadb-libs-5.5.37-1.el7_0.x86_64                                                   1/9  Installing : 1:mariadb-5.5.37-1.el7_0.x86_64                                                        2/9  Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                                                      3/9  Installing : 1:mariadb-server-5.5.37-1.el7_0.x86_64                                                 4/9  Installing : 1:mariadb-devel-5.5.37-1.el7_0.x86_64                                                  5/9  Installing : 1:mariadb-embedded-5.5.37-1.el7_0.x86_64                                               6/9  Installing : 1:mariadb-embedded-devel-5.5.37-1.el7_0.x86_64                                         7/9  Installing : 1:mariadb-test-5.5.37-1.el7_0.x86_64                                                   8/9  Installing : 1:mariadb-bench-5.5.37-1.el7_0.x86_64                                                  9/9  Verifying  : 1:mariadb-test-5.5.37-1.el7_0.x86_64                                                   1/9  Verifying  : 1:mariadb-embedded-devel-5.5.37-1.el7_0.x86_64                                         2/9  Verifying  : 1:mariadb-embedded-5.5.37-1.el7_0.x86_64                                               3/9  Verifying  : 1:mariadb-libs-5.5.37-1.el7_0.x86_64                                                   4/9  Verifying  : 1:mariadb-bench-5.5.37-1.el7_0.x86_64                                                  5/9  Verifying  : 1:mariadb-5.5.37-1.el7_0.x86_64                                                        6/9  Verifying  : 1:mariadb-server-5.5.37-1.el7_0.x86_64                                                 7/9  Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                                      8/9  Verifying  : 1:mariadb-devel-5.5.37-1.el7_0.x86_64                                                  9/9Installed:  mariadb.x86_64 1:5.5.37-1.el7_0                        mariadb-bench.x86_64 1:5.5.37-1.el7_0  mariadb-devel.x86_64 1:5.5.37-1.el7_0                  mariadb-embedded.x86_64 1:5.5.37-1.el7_0  mariadb-embedded-devel.x86_64 1:5.5.37-1.el7_0         mariadb-libs.x86_64 1:5.5.37-1.el7_0  mariadb-server.x86_64 1:5.5.37-1.el7_0                 mariadb-test.x86_64 1:5.5.37-1.el7_0Dependency Installed:  perl-DBD-MySQL.x86_64 0:4.023-5.el7Complete![root@localhost ~]# systemctl start mariadb.service[root@localhost ~]# systemctl enable mariadb.serviceln -s '/usr/lib/systemd/system/mariadb.service' '/etc/systemd/system/multi-user.target.wants/mariadb.servi                     ce'[root@localhost ~]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 2Server version: 5.5.37-MariaDB MariaDB ServerCopyright (c) 2000, 2014, Oracle, Monty Program Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> logout    -> exit    ->    -> ;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaD                     B server version for the right syntax to use near 'logoutexit' at line 1MariaDB [(none)]> exitBye[root@localhost ~]# systemctl enable mariadb.service[root@localhost ~]# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 3Server version: 5.5.37-MariaDB MariaDB ServerCopyright (c) 2000, 2014, Oracle, Monty Program Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || test               |+--------------------+4 rows in set (0.00 sec)MariaDB [(none)]> use testDatabase changedMariaDB [test]> show tables;Empty set (0.00 sec)MariaDB [test]> exitBye[root@localhost ~]# mysql_secure_installation/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not foundNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!In order to log into MariaDB to secure it, we'll need the currentpassword for the root user.  If you've just installed MariaDB, andyou haven't set the root password yet, the password will be blank,so you should just press enter here.ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)Enter current password for root (enter for none):OK, successfully used password, moving on...Setting the root password ensures that nobody can log into the MariaDBroot user without the proper authorisation.Set root password? [Y/n] yNew password:Re-enter new password:Password updated successfully!Reloading privilege tables.. ... Success!By default, a MariaDB installation has an anonymous user, allowing anyoneto log into MariaDB without having to have a user account created forthem.  This is intended only for testing, and to make the installationgo a bit smoother.  You should remove them before moving into aproduction environment.Remove anonymous users? [Y/n] y ... Success!Normally, root should only be allowed to connect from 'localhost'.  Thisensures that someone cannot guess at the root password from the network.Disallow root login remotely? [Y/n] y ... Success!By default, MariaDB comes with a database named 'test' that anyone canaccess.  This is also intended only for testing, and should be removedbefore moving into a production environment.Remove test database and access to it? [Y/n] y - Dropping test database... ... Success! - Removing privileges on test database... ... Success!Reloading the privilege tables will ensure that all changes made so farwill take effect immediately.Reload privilege tables now? [Y/n] y ... Success!Cleaning up...All done!  If you've completed all of the above steps, your MariaDBinstallation should now be secure.Thanks for using MariaDB![root@localhost ~]# mysql -uroot -pEnter password:Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 15Server version: 5.5.37-MariaDB MariaDB ServerCopyright (c) 2000, 2014, Oracle, Monty Program Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || zbphp.com  |+--------------------+4 rows in set (0.00 sec)MariaDB [(none)]>

Article by default7 # zbphp.com

MariaDB cannot be installed on centos 65

What is the metadata of yum? Is there a problem with the yum source?

How to install MariaDB in Windows

Maria storage engine PBXT storage engine XtraDB storage engine FederatedX storage engine
Its installation is similar to the noinstall version of MySQL.
1. Download and decompress the noinstall package. Assume that the package is decompressed to the D: \ dev \ MariaDB directory (5.1.44b): fe. up. pt2. create the configuration file my. ini.
The configuration file is usually stored in the Windows System directory (or in your installation directory), for example, C: \ WINDOWS or C: \ WINNT, named my. ini. After extracting mariadb-noinstall-5.1.44b-win32-beta.zip from the downloaded file, the folder contains five built-in MySQL configuration files, my-small. ini, my-medium.ini, my-large.ini, my-huge.ini and my-innodb-heavy-4G.ini, please choose one based on your machine's memory size, and rename it as my. ini is used as the basic configuration file.
Modify the parameters in the configuration file according to the installation directory, for example, [WinMySQLAdmin]
Server = D:/dev/mariadb/bin/mysqld.exe [mysqld] basedir = D:/dev/mariadb
Datadir = D:/dev/mariadb/data
Default-character-set = gbkport = 3306 [client] default-character-set = gbk
Port = 33063. Install MariaDB as a Windows Service
Run mysqld -- install servicename in the d:/dev/mariadb/bin directory to create a Windows service named servicename. Set the Startup Type of the created service to automatic start and start MariaDB. When MariaDB is started, data files and log files are created in the data directory. Note: After MariaDB is started, there is a default root user whose access password is blank. The password change method is similar to that of MySQL. Run the following command to modify the root access password. Mysqladmin-u root password "password"