Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MariaDB phpMyAdmin installation and configuration issues to resolve under CentOS7     - Debian (Wheezy) Install Java environment / replace OpenJDK as the SUN JDK (Linux)

- Nginx caching using the official guide (Server)

- Install mono offline on CentOS (Server)

- Compiled version of Android Opus audio codec library method (Programming)

- LAMP and LNMP automated installation scripts (Server)

- Linux basic introductory tutorial ---- simple text processing (Linux)

- Linux System Getting Started Tutorial: mounted directly in Linux LVM partition (Linux)

- JavaScript cross-browser event object library (Programming)

- Kubuntu 14.04 desktop to the user how to upgrade KDE 4.13.2 (Linux)

- Using open source software to build XWiki Wiki system installed within the company (Linux)

- Ubuntu 14.04 LTS NTFS partition can not access solution (Linux)

- Vim Common Command Summary (Linux)

- Linux upgrade Glibc (Linux)

- Fedora 22 install Adobe Flash Player (Linux)

- Xmanager Remote Desktop connection CentOS (Linux)

- Delegate in C # (Programming)

- OpenSUSE GPG Comments (Linux)

- MongoDB in bulk timestamp change the date format (Database)

- CentOS 6 adds disk quota limit (Linux)

- Linux / BSD firewall M0n0wall Profile (Linux)

  MariaDB phpMyAdmin installation and configuration issues to resolve under CentOS7
  Add Date : 2018-11-21      
  Linux novice. The problem until now finally decided to solve, with an afternoon plus minus one night to go to the cinema to see a movie and dinner time. Still quite a long time.

First talk about, in CentOS7 under with yum install mysql have become mariaDB, the beginning I was afraid phpmyadmin not support maria, later a search online is supported.

Well ado, the first is to install php, apache server (httpd) and phpmyadmin, because this is relatively simple thing.

So at this point in time I am now, yum install php-out version 5.4. This can later be installed via rpm -qa | grep php view.

And at this point in time I, the latest version of phpmyadmin need php5.5 + version, and thus, to download a little bit of the old version. This has its official website.

After httpd installation, configuration files are /etc/httpd/conf/httpd.conf, but not the Internet, said the root / var / www / but / var / www / html /, it is good to download and unzip over phpmyadmin folder put in here, and then change the name of a convenient easy to access. I hereby folder name to phpmyadmin. Then execute service httpd start. You are not that good can access the phpmyadmin?

Of course, do not have access, you will be prompted 403forbidden, this time, just going to say modify the configuration file, you will see

< Directory />
    AllowOverride none
    Require all denied
< / Directory>


< Directory />
    AllowOverride none
    Order allow, deny
    Allow from all
< / Directory>

Then save and exit and restart the service httpd restart. Then open the browser localhost / phpmyadmin, if you find you have selinux interference, you execute sentenforce 0 enough.

Of course, there you may be prompted to lack mbstring. This only needs yum install php-mbstring enough.

Then come to talk about mariaDB, first by yum install mysql, rather than automatically installed mariaDB mysql.

After installed, try service mariadb start like no matter, in fact, the command should be centOS7 systemctl start mariadb.service. Then you find it is still not open up?

Okay, you should check under your mariaDB have no means complete, rpm -qa | grep mariadb look. I was actually just installed two packages poor, in fact, need to install 8 packages:


The version number with your installed version change. If you find that not installed, you're one by one yum install it. . . (In fact, I personally feel that is not the test can not install, but seems to have a complete database of test)

Well loaded again systemctl start mariadb.service, you'll find out why or not!

In fact, there is no designated storage location and the name of the database you, execute the command: mysql_install_db --datadir = "/ var / lib / mysql" --user = "mysql"

After finally seems to specify it. But the first time you do not forget to set a root password: mysqladmin -u root password '1234'

It erupted is really done. You can just set root and the password phpmyadmin. Fully completed.

 See mariadb operating status can systemctl status mariadb.service
- Linux System Getting Started Tutorial: How to find the maximum memory your system supports (Linux)
- Java string intern constant pool resolution Introduction (Programming)
- shell script: the number of characters in the text to print no more than 6 words (Programming)
- Linux kernel VLAN study notes (Programming)
- Spacewalk Linux system configuration and installation (Linux)
- linux remote control software (Linux)
- Learning UNIX good habits (Linux)
- Ubuntu How to install screen recording tool Simple Screen Recorder 0.3.1 (Linux)
- How to set the default Fedora from the command line (Linux)
- MySQL Parameter Tuning Best Practices (Database)
- MySQL master-slave delay problem (Database)
- 11 you Linux Terminal Command (Linux)
- JDK installation under CentOS (Linux)
- RabbitMQ tutorial examples: RabbitMQ installation under Windows (Linux)
- MySQL multi-master-slave synchronization (Database)
- Linux Kernel 4.2.2 compiler installation tutorial (Linux)
- Oracle View index and use indexes Precautions (Database)
- Wildcards and special symbols usage comments under Linux (Linux)
- Ubuntu 14.04 configure JDK1.8.0_25, switchable version (Linux)
- Linux argument references and command substitution (Linux)
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.