How to restart MySQL: bitsCN.com
The correct method for restarting MySQL has changed my. cnf, the MySQL service needs to be restarted. because Mysql is installed from the source code package, there is no common servcie mysqld restart script in the
As an O & M personnel, you should not only learn how to build and install mysql services, but also understand the use of basic commands and syntaxes. This is the note I have summarized after learning, and I hope it will be helpful to Cainiao like me.
MySQL restart method bitsCN.com
Net start mysql
Net stop mysql
Mysqladmin-u root shutdown
----------------------------------------------------
RedHat Linux (Fedora Core/Cent OS)1. start:/etc/init. d/mysqld start
2. stop:/etc/init. d/mysqld
Share bitsCN.com with MySQL5.5.8 source code compilation and installation records in Linux
System: Ubuntu 10.10Mysql Source File: mysql-5.5.8.tar.gzInstall required tools: cmake, GNU make, gcc, Perl, libncurses5-dev, bison (optional), chkconfigNote:1
Use the yum command in Centos to deploy the lamp environment CentOSLAMP
BitsCN.com
1. by default, Centos enables the IP security policy, that is, port 80 also disables external access. Therefore, iptables is disabled first.
Service iptables stop
Basic mysql conversion operations
Mysql
Directory
1. Database Directory
/Var/lib/mysql
2. configuration file
/Usr/share/mysql (mysql. server command and configuration file)
3. related commands
/Usr/bin (commands such as mysqladmin mysqldump)
A master-slave MySQL replication configuration case where the environment is 111.111.111.110 and the slave database is 111.111.111.111.
A master-slave MySQL replication configuration case where the environment is 111.111.111.110 and the slave
Two ways to boot the CentOS Setup service1, use Chkconfig to configure the boot level In the case of CentOS or redhat other systems, the system will not start automatically after installation, such as httpd, mysqld, postfix, etc., if the service is
Linux
How to start the CentOS Setup serviceby Tianya · 2013/07/26Two ways to boot the CentOS Setup service1, use Chkconfig to configure the boot levelIn the case of CentOS or redhat other systems, the system will not start automatically after
ArticleDirectory
Change Password
Add IP addresses to the NIC
Restart
Apache
Change Password
Passwd Root Add IP addresses to the NIC
Ifconfig eth0: 1 184.82.167.219 netmask 255.255.255.255.248Ifconfig eth0:2 184.82.167.220
New MySQL builds multi-threaded master-slave replication
One: First get
Mysql-5.7.11-1.el6.x86_64.rpm-bundle.tar
Tar XF Mysql-5.7.11-1.el6.x86_64.rpm-bundle.tar
Yum install-y mysql-community-client-5.7.11-1.el6.x86_64.rpm mysql-community-common-5.7
Preparations for BBS Forum construction:
Linux, discuz_x2_ SC _utf8.zip (download available), securecrt (available)
Action start:
Mount disc containing package on Redhat to/mnt
Mount/dev/sr0/mnt
Force remove rhel-source.repo with
Install and configure the LAMP server in CentOS 6.2 (Apache + PHP5 + MySQL)Preparations: 1. configure the firewall, enable port 80 and port 3306 VI/etc/sysconfig/iptables-A input-M state -- state new-m tcp-p tcp -- dport 80-J accept (allow port 80
Starting, stopping, and restarting MySQL is a must-have operation for every webmaster with an independent host. The following describes the operation methods:
I. Startup Mode
1. Start with service: Service mysqld start
2. Use the mysqld script to
Responsibilities of the database administrator
Server startup and Shutdown
User account maintenance
Log File Maintenance
Database backup and copy
Server Optimization
Software updates for the database management system
Security of Data
1) Environment Topology
650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/2232221632-0.png "title =" QQ20130614135543.png "/>
Today we are talking about the mysql cluster. The resources are as follows:
650) this. width = 650;
Install mysql5.1.73 and mysql5.1.73 on CentOS6.5
Ideas:
1. Check whether mysql has been installed.
rpm -qa|grep mysql
Or
yum list installed mysql
2. Check whether the installation package exists.
yum list mysql*
3. Install mysql
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.