Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Installation and deployment of MariaDB under CentOS     - Linux performance monitoring (Linux)

- Iptables Instructions (Linux)

- ORA-27054 NFS problem solving (Database)

- C # Future: Tracking null reference (Programming)

- Docker Private Registry Installation Guide at CentOS6.X (Linux)

- Build your own Python coding environment (Linux)

- Django Signals from practice to source code analysis (Programming)

- VirtualBox virtual machine to install Linux (Linux)

- Installation of Python2.7.8 and iPython under CentOS6.5 (Linux)

- Linux terminal program running in the background (Linux)

- CentOS7 boot systemd introduction and use of management (Linux)

- CentOS 5.3 under broadcom NIC dual activation issues (Linux)

- Ubuntu 14.10 splash screen brightness settings (Linux)

- Graphical interface for the CentOS 6.4 installed and connected by remote VNC (Linux)

- Linux System Getting Started Tutorial: How do you know Shell which is currently being used (Linux)

- Redis is installed in Ubuntu 14.04 (Database)

- Based shell: using read, the command-line script to achieve mass participation and input two integer calculation (Programming)

- CentOS7 minimized installation can not find the 'ifconfig' command - Repair Tips (Linux)

- Novice Advanced Ubuntu7.10 configured IP address (Linux)

- Python Multithreaded Programming (Programming)

  Installation and deployment of MariaDB under CentOS
  Add Date : 2017-01-08      

VM: VMWare10.0.1 build-1379776

Operating System: CentOS7 64 bit


1, add a yum repository MariaDB source, build MariaDB.repo file /etc/yum.repos.d/, the contents of the file to https://downloads.mariadb.org/mariadb/repositories/ can choose their own system and version mariadb version of this article chose mariadb5.5:

# MariaDB 5.5 CentOS repository list - created 2015-09-08 10:16 UTC
# Http://mariadb.org/mariadb/repositories/
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos7-amd64
gpgkey = https: //yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1

2, use yum to install, long wait.

sudo yum -y install MariaDB-client MariaDB-server MariaDB-devel

3. Start the database

sudo service mysql start

4, log on using local mysql database (default no password)

mysql -u root

5, modify the root password

use mysql;
update user set password = PASSWORD ( 'root') where user = 'root';
flush privileges;

reset Password

If you forget the mysql root password, what steps can help you.

1, stop mysqld running processes

killall -TERM mysqld

2, Safe Mode Boot mysql service (plus & start showing background)

mysqld_safe --skip-grant-tables &

3, after the start can not lose the password mysql

mysql -u root -p

4, modify the root password, refer to Step 5.
- MongoDB 2.6 deployment replica set + partitions (Database)
- Laravel cache paged results (Server)
- Let Git variety of colors and custom log format output (Linux)
- Modify Linux SSH default port 22 in several ways (Linux)
- Seven Steps to Help Google Chrome Speed - (Linux)
- MySQL appears data too long for column 'name' at row 1 to solve (Database)
- Four Methods of Self - Learning Linux (Linux)
- Linux kernel source code analysis (Linux)
- Help you make Git Bisect (Linux)
- Hibernate Search 5.5 in the search results sorted (Linux)
- MySQL 5.7 and 5.6 group by differences (Database)
- Upgrade to Node V4 seven reasons (Programming)
- Linux operating system buffer overflow attacks Countermeasures (Linux)
- CentOS 6.5 installation and configuration Cobbler (Server)
- CentOS 7 Configure logging (VirtualBox) (Linux)
- Installation Yarock 1.1.4 Music Player in Ubuntu (Linux)
- Nagios plugin installation tutorial of Nrpe (Linux)
- Linux Network Programming - raw socket Example: sending a UDP packet (Programming)
- Shuffle Process Arrangement in MapReduce (Server)
- Ubuntu 14.04 kernel after the restart boot black screen to solve (Linux)
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.