CentOS in Source mode installation configuration MySQL (configuration phpMyAdmin)

Source: Internet
Author: User
Tags chmod http authentication rewind zip phpmyadmin

Mysql Installation

Installation

Yum-y install MySQL mysql-server php-mysql perl-dbd-mysql perl-dbi php-gd php-mbstring

Start

Service mysqld Start

Set Password

mysqladmin-u root password ' set '

Set UTF8 Universal code, add the following two narrative sentences

Vi/etc/my.cnf

[Mysqld]
Default-character-set=utf8

[Client]
Default-character-set=utf8

Forget password (note, make sure there is no important information, or start the action if you have already backed up)

Service Mysqld Stop
Rm-rf/var/lib/mysql
Service mysqld Start

Modify password

mysqladmin Password New password

Fire?? setting, limiting the source of use

Vi/etc/sysconfig/iptables

-A rh-firewall-1-input-m state--state new-m tcp-p tcp-s 192.168.10.0/24--dport 3306-j ACCEPT (network segment)

-A rh-firewall-1-input-m state--state new-m tcp-p tcp-s 192.168.10.1--dport 3306-j ACCEPT (stand-alone)

Manager Login

Mysql-u root-p

Repository Backup directives

Mysqldump-uroot-p-A--default-character-set=utf8 > Mysql.sql (all databases)

Mysqldump-uroot-p-a--default-character-set=utf8 xoops > xoops.sql (Single database Xoops)

Mysql-uroot-p < Mysql.sql (all database restore)

MySQL--user=root-p xoops </var/www/html/xoops.sql (single database Restore XOOPSL)

rpm Reinstall MySQL

Download the relevant RPM files to the official website first

Suggest downloading related files to the archives server of http://ftp.isu.edu.tw/pub/Linux/CentOS/University

This time to CentOS 5 version as an example (because of the failure to encounter MYSLQD only this article)

Cd/tmp

Mysqldump-uroot-p-A--default-character-set=utf8 > Mysql.sql (back up all repositories first)

wget http://ftp.isu.edu.tw/pub/Linux/CentOS/5.9/updates/i386/RPMS/mysql-5.0.95-5.el5_9.i386.rpm http:// ftp.isu.edu.tw/pub/linux/centos/5.9/updates/i386/rpms/mysql-bench-5.0.95-5.el5_9.i386.rpm http://ftp.isu.edu.tw /pub/linux/centos/5.9/updates/i386/rpms/mysql-devel-5.0.95-5.el5_9.i386.rpm http://ftp.isu.edu.tw/pub/Linux/ centos/5.9/updates/i386/rpms/mysql-server-5.0.95-5.el5_9.i386.rpm http://ftp.isu.edu.tw/pub/Linux/CentOS/5.9/ updates/i386/rpms/mysql-test-5.0.95-5.el5_9.i386.rpm

When the download is complete, perform the installation www.111cn.net

RPM-IVH mysql-5.0.95-5.el5_9.i386.rpm mysql-bench-5.0.95-5.el5_9.i386.rpm mysql-devel-5.0.95-5.el5_9.i386.rpm/ mysql-server-5.0.95-5.el5_9.i386.rpm mysql-test-5.0.95-5.el5_9.i386.rpm

If you encounter a related message, you can force the installation! This time again met (102.10.25)

xxx1 conflicts with file from package xxx2

RPM-UVH--force mysql-5.0.95-5.el5_9.i386.rpm mysql-bench-5.0.95-5.el5_9.i386.rpm mysql-devel-5.0.95-5.el5_9. i386.rpm/mysql-server-5.0.95-5.el5_9.i386.rpm mysql-test-5.0.95-5.el5_9.i386.rpm

After installation, you can start mysqld

Service mysqld Start

Set Password

mysqladmin-u root password ' set '

Rewind the Database

Mysql-uroot-p < Mysql.sql (all database restore)

Check to install its kit

Yum-y install MySQL mysql-server php-mysql perl-dbd-mysql perl-dbi php-gd php-mbstring



Yum re-install MySQL
Back up all repositories first

Mysqldump-uroot-p-A--default-character-set=utf8 > Mysql.sql

Remove the fault mysqld again

Service Mysqld Stop
Yum-y Remove mysql*
Rm-rf/var/lib/mysql

Reinstall MYSQLD

Yum-y install MySQL mysql-server php-mysql perl-dbd-mysql perl-dbi php-gd php-mbstring
Service mysqld Start

If you start an exception

Try A

Touch/var/lib/mysql/mysql.sock
Chown Mysql:mysql/var/lib/mysql/mysql.sock
chmod 4777/var/lib/mysql/mysql.sock
Still no success enabled, restore your socket

Mysqld_safe--user=mysql &

Try two (100 years 0118 that once in this way solved)

mysql_install_db

Set Password

mysqladmin-u root password ' set '

Rewind the Database

Mysql-uroot-p < Mysql.sql (all database restore)

phpMyAdmin
Yum installation software

Yum-y Install phpMyAdmin php-mbstring php-gd php-mcrypt

Set

vi/usr/share/phpmyadmin/config.inc.php

Tar installation

Please go to the official website to download the latest version of phpMyAdmin, this site provides version (2013.10.25) phpmyadmin-4.0.8-all-languages.zip

http://www.phpmyadmin.net/home_page/index.php

Tar jvxf phpmyadmin-3.0.1-all-languages.tar.bz2-c/var/www/html/

Cd/var/www/html/phpmyadmin

CP config.sample.inc.php config.inc.php

Set

vi/var/www/html/phpmyadmin/config.inc.php

-------------------------------------------------------------------------------

Change the cookie to HTTP authentication method 111cn.net

$cfg [' blowfish_secret '] = ' encrypt digital text ';

$cfg [' Servers '] [$i] [' auth_type '] = ' http ';

Alias settings, let the page read the place

Vi/etc/httpd/conf.d/phpmyadmin.conf

<directory "/usr/share/phpmyadmin" >
Order Deny,allow
Deny from all
Allow from 127.0.0.1
Allow from 192.168.10.x #建议指定IP, security considerations
</Directory>


Alias/phpmyadmin/usr/share/phpmyadmin
Alias/pa/usr/share/phpmyadmin #有机器人会扫瞄phpmyadmin, the suggestion uses the unpopular word!

When you are done, modify the permissions before restarting

chmod 755/usr/share/phpmyadmin

Service httpd Restart

Next, test whether the website is successfully enabled

Http://IP/pa

PS: When setting up a database, we recommend coding Uft8_general.ci

"utf8_swedish_ci" turn into "utf8_general_ci"
The Emed802epx.zip tool can be used to turn proofreading "utf8_swedish_ci" into common "utf8_general_ci"

vi/var/www/html/phpmyadmin/libraries/select_lang.lib.php

Yum version
vi/usr/share/phpmyadmin/libraries/select_lang.lib.php
Find//mysql charsets Map
' Utf-8 ' = ' utf-8 ',

Change into
' Utf-8 ' = ' latin1 ',

And then restart Apache
Service httpd Restart

So phpmyadmin can display the correct Chinese characters, after the output, in the use of EmEditor, save the new file into a utf-8 format, then the data into the database.

Single Repository Export

Mysqldump-uroot-p-a--default-character-set=utf8 xoops > Xoops.sql

Single Repository Import

MySQL Xoops < xoops.sql-u root-p--default-character-set=utf8

Related Article

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.

A Free Trial That Lets You Build Big!

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

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

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