Installing MARIADB phpMyAdmin

Last Update:2017-09-20 Source: Internet

Author: User

Tags install php php print phpmyadmin

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

1 Installation Settings MariaDB5.5

[Email protected] ~]# yum-y install Mariadb-server

[Email protected] ~]# VI/ETC/MY.CNF
[Mysqld]

Character-set-server=utf8

[Email protected] ~]# Systemctl enable Mariadb.service
[Email protected] ~]# systemctl start Mariadb.service

[Email protected] ~]# mysql_secure_installation

Note:running all PARTS of this SCRIPT are 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 current
Password for the root user. If you ' ve just installed MariaDB, and
You haven ' t set the root password yet, the password would be blank,
So, should just press ENTER here.

Enter current password to root (enter for none):
OK, successfully used password, moving on ...

Setting The root password ensures that nobody can log into the MariaDB
Root user without the proper authorisation.

Set root Password? [y/n] Y
New Password:
Re-enter new password:
Password Updated successfully!
Reloading privilege tables.
... success!

By default, a MariaDB installation have an anonymous user, allowing anyone
To log into MariaDB without has to has a user account created for
them. This was intended only for testing, and the installation
Go a bit smoother. You should remove them before moving into a
Production environment.

Remove anonymous users? [y/n] Y
... success!

Normally, Root should only is allowed to connect from ' localhost '. This
Ensures that someone cannot guess at the root of password from the network.

Disallow Root login remotely? [y/n] Y
... success!

By default, MariaDB comes with a database named ' test ' that anyone can
Access. This was also intended only for testing, and should be removed
Before 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 would ensure that all changes made so far
would 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 MariaDB
Installation should now is secure.

Thanks for using mariadb!

2 Installation Settings httpd

[Email protected] ~]# yum-y install httpd

[Email protected] ~]# rm-f/etc/httpd/conf.d/welcome.conf
[Email protected] ~]# Systemctl enable httpd
Created symlink From/etc/systemd/system/multi-user.target.wants/httpd.service to/usr/lib/systemd/system/ Httpd.service.
[Email protected] ~]# systemctl start httpd
[Email protected] ~]# vi/var/www/html/index.html

Direct access to Web pages

650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M01/A5/AA/wKioL1nBQ-7hJmOdAABxgHW6NEo272.png-wh_500x0-wm_ 3-wmp_4-s_4258301454.png "title=" qq picture 20170920001925.png "alt=" Wkiol1nbq-7hjmodaabxghw6neo272.png-wh_50 "/>

3 Installation settings PHP

[Email protected] ~]# yum-y install PHP php-mbstring php-pear

[Email protected] ~]# Vi/etc/php.ini
Date.timezone = "Asia/shanghai"

[Email protected] ~]# systemctl restart httpd

[Email protected] ~]# vi/var/www/html/index.php


650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/A5/AA/wKioL1nBRq2geY4UAABpAJrNeK0144.png-wh_500x0-wm_ 3-wmp_4-s_3379099890.png "title=" qq picture 20170920003203.png "alt=" Wkiol1nbrq2gey4uaabpajrnek0144.png-wh_50 "/>
4 Installation Settings phpMyAdmin
[email protected] ~]# Yum--enablerepo=epel-y install phpMyAdmin php-mysql php-mcrypt
[Email protected] ~]# vi/etc/httpd/conf.d/phpmyadmin.conf
<ifmodule mod_authz_core.c>
# Apache 2.4
<RequireAny>
Require IP 127.0.0.1 9.110.187.100/24
Require IP:: 1
</RequireAny>
</IfModule>
<ifmodule!mod_authz_core.c>
# Apache 2.2
Order Deny,allow
Deny from all
Allow from 127.0.0.1
-Allow from:: 1
</IfModule>
</Directory>
29
<Directory/usr/share/phpMyAdmin/setup/>
<ifmodule mod_authz_core.c>
# Apache 2.4
<RequireAny>
Require IP 127.0.0.1 9.110.187.100/24
Require IP:: 1
</RequireAny>
Panax Notoginseng </IfModule>
650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/06/FA/wKiom1nBSBjySUgxAAGIShghEwg971.png-wh_500x0-wm_ 3-wmp_4-s_2625765554.png "title=" qq picture 20170920003722.png "alt=" Wkiom1nbsbjysugxaagishghewg971.png-wh_50 "/>
[Email protected] ~]# systemctl restart httpd
650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M00/06/FA/wKiom1nBSJCw-xtEAADVyESAR3Y045.png-wh_500x0-wm_ 3-wmp_4-s_2633247339.png "title=" qq picture 20170920003922.png "alt=" Wkiom1nbsjcw-xteaadvyesar3y045.png-wh_50 "/>
650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/06/FA/wKiom1nBScGCTPFFAAJWbQGbPDo577.png-wh_500x0-wm_ 3-wmp_4-s_3442662602.png "title=" qq picture 20170920004403.png "alt=" Wkiom1nbscgctpffaajwbqgbpdo577.png-wh_50 "/>
This article from "Hu Xiaoqiu Studio" blog, reproduced please contact the author!
Installing MARIADB phpMyAdmin

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.

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