-community-server//enable MySQL also need to install MySQL server, through this command install # service MYSQLD Start//Start mysql# chkconfig mysqld on//set MySQL Boot # grant all privileges on * * to ' admin ' @ '% ' identified by ' 123456 ' with Grant option; Set MySQL r
piece of codeAddType application/x-httpd-php. php. phtml Restart Apache#/usr/local/apache2/bin/apachectl Restart The above installation steps can be written as a shell script, detailed reference Http://files.cnblogs.com/mchina/lamp.rar 16. Installing the Zend Accelerator # cd/usr/local/src/zendoptimizer-3.2.6-linux-glibc21-i386/#./install.sh 17, Installation phpMyAdminCopy the directory to the specif
Label:How to upgrade the MySQL under CentOS 6.5The CentOS 6.5 comes with MySQL 5.1 installed, but 5.1 has a lot of limitations, and in practice we've already used MySQL 5.6, which causes some scripts to execute in MySQL 5.1 with a
MYSQL master-slave synchronization configuration for CentOS
1. Both the master and salver close the firewall iptables and execute the service iptables stop command:
Set SELINUX = disabled for The SELINUX file ,:
2. Create a database
Log on to mysql on the master and slave respectively: mysql-u root-p
Create database r
/** * Centos-6.4-minimal version of the source installation MySQL-5.5.38 *---------------------------------------------------------------------- ------------------------------------------------* Three ways to install * 1) Source installation * 2) binary Package installation * 3) RPM or Yum installation * This article demonstrates the source installation, and, starting from
following command[[Email protected] liuzhen]# service MySQL startStop MySQL Service[[Email protected] liuzhen]# service MySQL stopRestart MySQL Service[[Email protected] liuzhen]# service MySQL restartThe following two commands work the same way
Systemctl [Stop|sta
following command[[Email protected] liuzhen]# service MySQL startStop MySQL Service[[Email protected] liuzhen]# service MySQL stopRestart MySQL Service[[Email protected] liuzhen]# service MySQL restartThe following two commands work the same way
Systemctl [Stop|sta
;# chkconfig mysqld on # Set the boot up with this command:
If the error occurs in the first step, you have just configured the problem in step 8th, so you reset
After you finish this step, do the next operation again.
If the following problems occur in the subsequent operation
This is the problem of the computer environment, you can directly
10, MySQL service start/restart/stop
# service m
information configuration CD for installation source (note: There is a configuration ISO for the installation source, here only the disc image is temporarily used as the installation source): $ sudo ssh 192.168.48.128- L root# Cat/etc/yum.repos.d/centos-media.repo Basic contents are as follows: [c7-media]name=centos-$releasever-mediabaseurl=file:///media /centos
MySQL -- install MySQL5.5 and centosmysql5.5 in RPM Mode Under CentOS
Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46507735First go to the mySQL official website to download the page:
Http://dev.mysql.com/downloads/mysql/#downloads
Select PlatformOracle Red Hat Linux 4 5
Dow
:
mysql -h10.0.0.1 -uroot -p123
(Note: you do not need to add spaces for u and root. The same applies to others)
Configure Firewall
Port 3306 of the firewall is disabled by default. To access the firewall remotely, you must enable this port.
Open/etc/sysconfig/iptables
In "-a input-m state -- state NEW-m tcp-p tcp-dport 22-j ACCEPT", add:
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
Save and close the file. Run the following comm
CentOS Linux has been used more and more widely because of its compatibility with Rhel and the stability of enterprise-class application, and allow users to use it freely.
1] CentOS MySQL Installation decompression[Root@localhost root]# Cd/usr/local/mysql/software
[Root@localhost software]# ls
MySQL compilation and Installation notesThe premise is that your Linux system should build the GCC compiling environment.If CentOS is used, you can:Yum-y install gccYum-y install gcc-c ++Add MySQL user groups and usersGrounadd mysqlUseradd-g mysqlMySQL compilation and installation of dependent software packages:Cd/tmpWget http://ftp.gnu.org/pub/gnu/ncurses/ncurse
Then restart MySQL.
1
sudo systemctl start mysqld
Tune MySQLMySQL Tuner is a Perl script this connects to a running instance of MySQL and provides configuration recommendations based On workload. Ideally, the MySQL
CentOs php + mysql + apache + ftp configuration, centosapache. In the php + mysql + apache + ftp configuration in centOs, centosapache takes notes when installing the server. this method is successful in person. as the version keeps updating, there may be a centOs php +
Install and configure LAMP (Linux + Apache + MySQL + PHP) in Centos. For more information about LAMP, see Baidu Google, today, we will introduce how to install a web server in Centos. First, let's talk about my host and network environment: the host system is win7, the virtual machine is installed under win7, And the Centos
Share The CentOS installation process of the latest MySQL version 5.6.13 source code in CentOS.
BitsCN.com
Two months ago, the company withdrew the test server for the DBA and used a group of databases for development. some of the small functions that need to be tested need to be restarted constantly. in order not to affect the development colleagues, I have appl
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.