【CentOS 7LAMP架构1】，LAMP模式介绍与MySQL安装与配置#

最新推荐文章于 2024-08-20 17:14:42 发布
最新推荐文章于 2024-08-20 17:14:42 发布
阅读量340 收藏
点赞数
文章标签： 操作系统 网络 运维
原文链接：https://my.oschina.net/u/3892756/blog/3069274
版权

shallow丿ove

LAMP架构模式

Linux+Apache(httpd)+MySQL+PHP

mysql和MariaDB介绍

  • MySQL是一个关系型数据库，由mysql ab公司开发，mysql在2008年被sun公司收购（10亿美金），2009年sun公司被Oracle（甲骨文）公司收购（74亿美金）
  • MySQL官网https://www.mysql.com最新版本5.7GA/8.0DMR
  • MySQL5.6变化比较大，5.7性能上有很大提升
  • MariaDB为MySQL的一个分支，官网https://mariadb.com/最新版本10.2
  • MariaDB主要由SkySQL公司（现更名为MariaDB公司）维护，SkySQL公司由MySQL原作者带领大部分原班人马创立。
  • MariaDB5.5版本对应MySQL的5.5,10.0对应MySQL5.6
  • Community社区版本，Enterprise企业版本，GA（Generally Available）指通用版本，在生产环境中用的，DMR（Development Milestone Release）开发里程碑发布版，RC（Release Candidate）发行候选版本，Beta开放测试版本，Alpha内部测试版本。

安装MySQL

  • MySQL的几个常用安装包：rpm、源码、二进制免编译
  • cd /usr/local/ssrc
  • wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz
  • tar zxvf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz
  • mv mysql-5.6.36-linux-glibc2.5-x86_64 /usr/local/mysql
  • cd /usr/local/mysql
  • useradd mysql
  • mkdir /data/
  • ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
  • cp support-files/my-default.cnf /etc/my.cnf
  • cp support-files/mysql.server /etc/init.d/mysqld
  • vi /etc/init.d/mysqld 定义basedir和datadir
  • etc/init.d/mysqld start

下载mysql

[root@localhost src]# uname -a	#根据系统选择相对应版本
	Linux localhost.localdomain 3.10.0-123.el7.x86_64 #1 SMP Mon Jun 30 12:09:22 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost ~]# cd /usr/local/src

[root@localhost src]# wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz
	--2017-12-14 11:07:36--  http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz
	Resolving mirrors.sohu.com (mirrors.sohu.com)... 221.236.12.140
	Connecting to mirrors.sohu.com (mirrors.sohu.com)|221.236.12.140|:80... connected.
	HTTP request sent, awaiting response... 200 OK
	Length: 316320366 (302M) [application/octet-stream]
	Saving to: ‘mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz’

	100%[=========================================================>] 316,320,366  506KB/s   in 15m 24s

	2017-12-14 11:23:00 (334 KB/s) - ‘mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz’ saved [316320366/316320366]


[root@localhost src]# tar zxvf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz
	#拆包解压内容
	.
	.
	.
[root@localhost src]# mv mysql-5.6.36-linux-glibc2.5-x86_64 /usr/local/mysql
[root@localhost src]# cd /usr/local/mysql
[root@localhost mysql]# ls
	bin      data  include  man         README   share      support-files
	COPYING  docs  lib      mysql-test  scripts  sql-bench
[root@localhost mysql]# mkdir /data/
[root@localhost mysql]# ls /data/

编译

[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
Installing MySQL system tables...2017-12-14 11:34:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-14 11:34:42 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2017-12-14 11:34:42 0 [Note] ./bin/mysqld (mysqld 5.6.36) starting as process 4733 ...
2017-12-14 11:34:42 4733 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-14 11:34:42 4733 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-14 11:34:42 4733 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-14 11:34:42 4733 [Note] InnoDB: Memory barrier is not used
2017-12-14 11:34:42 4733 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-14 11:34:42 4733 [Note] InnoDB: Using Linux native AIO
2017-12-14 11:34:42 4733 [Note] InnoDB: Using CPU crc32 instructions
2017-12-14 11:34:42 4733 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-14 11:34:43 4733 [Note] InnoDB: Completed initialization of buffer pool
2017-12-14 11:34:43 4733 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2017-12-14 11:34:43 4733 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2017-12-14 11:34:43 4733 [Note] InnoDB: Database physically writes the file full: wait...
2017-12-14 11:34:44 4733 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-12-14 11:34:46 4733 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-12-14 11:34:47 4733 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-12-14 11:34:47 4733 [Warning] InnoDB: New log files created, LSN=45781
2017-12-14 11:34:47 4733 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-12-14 11:34:47 4733 [Note] InnoDB: Doublewrite buffer created
2017-12-14 11:34:47 4733 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-14 11:34:47 4733 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-12-14 11:34:47 4733 [Note] InnoDB: Foreign key constraint system tables created
2017-12-14 11:34:47 4733 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-12-14 11:34:47 4733 [Note] InnoDB: Tablespace and datafile system tables created.
2017-12-14 11:34:47 4733 [Note] InnoDB: Waiting for purge to start
2017-12-14 11:34:47 4733 [Note] InnoDB: 5.6.36 started; log sequence number 0
2017-12-14 11:34:47 4733 [Note] Binlog end
2017-12-14 11:34:47 4733 [Note] InnoDB: FTS optimize thread exiting.
2017-12-14 11:34:47 4733 [Note] InnoDB: Starting shutdown...
2017-12-14 11:34:49 4733 [Note] InnoDB: Shutdown completed; log sequence number 1625977
OK

Filling help tables...2017-12-14 11:34:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-14 11:34:49 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2017-12-14 11:34:49 0 [Note] ./bin/mysqld (mysqld 5.6.36) starting as process 4755 ...
2017-12-14 11:34:49 4755 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-14 11:34:49 4755 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-14 11:34:49 4755 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-14 11:34:49 4755 [Note] InnoDB: Memory barrier is not used
2017-12-14 11:34:49 4755 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-14 11:34:49 4755 [Note] InnoDB: Using Linux native AIO
2017-12-14 11:34:49 4755 [Note] InnoDB: Using CPU crc32 instructions
2017-12-14 11:34:49 4755 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-14 11:34:49 4755 [Note] InnoDB: Completed initialization of buffer pool
2017-12-14 11:34:49 4755 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-14 11:34:49 4755 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-14 11:34:49 4755 [Note] InnoDB: Waiting for purge to start
2017-12-14 11:34:49 4755 [Note] InnoDB: 5.6.36 started; log sequence number 1625977
2017-12-14 11:34:49 4755 [Note] Binlog end
2017-12-14 11:34:49 4755 [Note] InnoDB: FTS optimize thread exiting.
2017-12-14 11:34:49 4755 [Note] InnoDB: Starting shutdown...
2017-12-14 11:34:51 4755 [Note] InnoDB: Shutdown completed; log sequence number 1625987
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

  ./bin/mysqladmin -u root password 'new-password'
  ./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Alternatively you can run:

  ./bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

  cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

  cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as ./my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

[root@localhost mysql]# echo $?
	0

报错，缺少模块

[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
	FATAL ERROR: please install the Perl modules before executing ./scripts/mysql_install_db:
	Data::Dumper

[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
	Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: lib
	aio.so.1: cannot open shared object file: No such file or directory

类似于以上问题，使用模糊搜索查找模块

[root@localhost mysql]# yum list | grep perl | grep -i dumper
	perl-Data-Dumper.x86_64                 2.145-3.el7                    @base    
	perl-Data-Dumper-Concise.noarch         2.020-6.el7                    epel     
	perl-Data-Dumper-Names.noarch           0.03-17.el7                    epel     
	perl-XML-Dumper.noarch                  0.81-17.el7                    base 
[root@localhost mysql]# yum install -y perl-Data-Dumper
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * epel: mirrors.sohu.com
Resolving Dependencies
--> Running transaction check
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be reinstalled
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================
 Package                     Arch              Version                   Repository       Size
===============================================================================================
Reinstalling:
 perl-Data-Dumper            x86_64            2.145-3.el7               base             47 k

Transaction Summary
===============================================================================================
Reinstall  1 Package

Total download size: 47 k
Installed size: 97 k
Downloading packages:
perl-Data-Dumper-2.145-3.el7.x86_64.rpm                                 |  47 kB  00:00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : perl-Data-Dumper-2.145-3.el7.x86_64                                         1/1 
  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                                         1/1 

Installed:
  perl-Data-Dumper.x86_64 0:2.145-3.el7                                                        

Complete!




[root@localhost mysql]#  yum install libaio-devel

[root@localhost mysql]# ls support-files/
binary-configure  magic  my-default.cnf  mysqld_multi.server  mysql-log-rotate  mysql.server

配置MySQL文件

[root@localhost mysql]# vi support-files/my-default.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

"support-files/my-default.cnf" 31L, 1126C

[root@localhost mysql]# cp support-files/my-default.cnf /etc/my.cnf


[root@localhost mysql]# cp support-files/my-default.cnf /etc/my.cnf
	cp: overwrite ‘/etc/my.cnf’? ^C
[root@localhost mysql]# ls /etc/my.cnf
[root@localhost mysql]# rpm -qf /etc/my.cnf
	mariadb-libs-5.5.56-2.el7.x86_64

也可以直接修改/etc/my.cnf

[root@localhost mysql]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

将第2行的datadir=/var/lib/mysql改为datadir=/data/mysql 第3行的socket=/var/lib/mysql/mysql.sock改为socket=/tmp/mysql.sock 可以将第12、13、18行加上注释符号，暂且不用 #log-error=/var/log/mariadb/mariadb.log #pid-file=/var/run/mariadb/mariadb.pid #!includedir /etc/my.cnf.d

自定义启动脚本

[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysqld


[root@localhost mysql]# vi +46 /etc/init.d/mysqld
	.
	.
	.
#
# If you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.

basedir=
datadir=

# Default value, in seconds, afterwhich the script should timeout waiting
# for server start.
# Value here is overriden by value in my.cnf.
# 0 means don't wait at all
# Negative numbers mean to wait indefinitely
service_startup_timeout=900

	.
	.
	.

"/etc/init.d/mysqld" 378L, 10565C

basedir=/usr/local/mysql datadir=/data/mysql

[root@localhost mysql]# chmod 755 /etc/init.d/mysqld 
[root@localhost mysql]# ls -l !$
	ls -l /etc/init.d/mysqld
	-rwxr-xr-x 1 root root 10592 Dec 14 12:26 /etc/init.d/mysqld


[root@localhost mysql]# chkconfig --add mysqld
[root@localhost mysql]# chkconfig --list

Note: This output shows SysV services only and does not include native
      systemd services. SysV configuration data might be overridden by native
      systemd configuration.

      If you want to list systemd services use 'systemctl list-unit-files'.
      To see services enabled on particular target use
      'systemctl list-dependencies [target]'.

iprdump        	0:off	1:off	2:on	3:on	4:on	5:on	6:off
iprinit        	0:off	1:off	2:on	3:on	4:on	5:on	6:off
iprupdate      	0:off	1:off	2:on	3:on	4:on	5:on	6:off
mysql-proxy    	0:off	1:off	2:off	3:off	4:off	5:off	6:off
mysqld         	0:off	1:off	2:on	3:on	4:on	5:on	6:off
netconsole     	0:off	1:off	2:off	3:off	4:off	5:off	6:off
network        	0:off	1:off	2:on	3:on	4:on	5:on	6:off

启动mysql

[root@localhost mysql]# /etc/init.d/mysqld start
	或service mysqld start

[root@localhost mysql]# service mysqld start
	Starting MySQL. SUCCESS!

[root@localhost mysql]# ps aux | grep mysql
root       5445  0.0  0.0  11776  1596 pts/1    S    12:32   0:00 /bin/sh /usr/local/mysql/binmysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/localhost.localdomain.pid
mysql      5583  1.5 24.3 1300784 454860 pts/1  Sl   12:32   0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/localhost.localdomain.err --pid-file=/data/mysql/localhost.localdomain.pid --socket=/tmp/mysql.sock
root       5607  0.0  0.0 112660   972 pts/1    S+   12:33   0:00 grep --color=auto mysql
[root@localhost mysql]# netstat -lntp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2470/master         
tcp        0      0 0.0.0.0:2049            0.0.0.0:*               LISTEN      -                   
tcp        0      0 0.0.0.0:52133           0.0.0.0:*               LISTEN      1496/rpc.statd      
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd           
tcp        0      0 0.0.0.0:20048           0.0.0.0:*               LISTEN      1951/rpc.mountd     
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1406/sshd           
tcp        0      0 0.0.0.0:37559           0.0.0.0:*               LISTEN      -                   
tcp6       0      0 ::1:25                  :::*                    LISTEN      2470/master         
tcp6       0      0 :::2049                 :::*                    LISTEN      -                   
tcp6       0      0 :::48771                :::*                    LISTEN      -                   
tcp6       0      0 :::46184                :::*                    LISTEN      1496/rpc.statd      
tcp6       0      0 :::3306                 :::*                    LISTEN      5583/mysqld         
tcp6       0      0 :::111                  :::*                    LISTEN      1/systemd           
tcp6       0      0 :::20048                :::*                    LISTEN      1951/rpc.mountd     
tcp6       0      0 :::22                   :::*                    LISTEN      1406/sshd

mysql端口号3306

使用命令行方式启动mysql

[root@localhost mysql]# service mysqld stop
	Shutting down MySQL.. SUCCESS! 
[root@localhost mysql]# !ps
	ps aux | grep mysql
	root       5635  0.0  0.0 112660   976 pts/1    S+   12:35   0:00 grep --color=auto mysql

[root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf  --user=mysql --datadir=/data/mysql &
	[1] 5636
[root@localhost mysql]# 171214 12:38:08 mysqld_safe Logging to '/data/mysql/localhost.localdomain.err'.
	171214 12:38:08 mysqld_safe Starting mysqld daemon with databases from /data/mysql

[root@localhost mysql]# !ps
	ps aux | grep mysql
	root       5636  0.0  0.0 113264  1612 pts/1    S    12:38   0:00 /bin/sh /usr/local/mysql/binmysqld_safe --defaults-file=/etc/my.cnf --user=mysql --datadir=/data/mysql
	mysql      5761  2.5 24.0 1300784 449668 pts/1  Sl   12:38   0:00 /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/localhost.localdomain.err --pid-file=/data/mysql/localhost.localdomain.pid --socket=/tmp/mysql.sock
	root       5784  0.0  0.0 112660   972 pts/1    S+   12:38   0:00 grep --color=auto mysql
[root@localhost mysql]# !net
	netstat -lntp
	Active Internet connections (only servers)
	Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
	tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2470/master         
	tcp        0      0 0.0.0.0:2049            0.0.0.0:*               LISTEN      -                   
	tcp        0      0 0.0.0.0:52133           0.0.0.0:*               LISTEN      1496/rpc.statd      
	tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd           
	tcp        0      0 0.0.0.0:20048           0.0.0.0:*               LISTEN      1951/rpc.mountd     
	tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1406/sshd           
	tcp        0      0 0.0.0.0:37559           0.0.0.0:*               LISTEN      -                   
	tcp6       0      0 ::1:25                  :::*                    LISTEN      2470/master         
	tcp6       0      0 :::2049                 :::*                    LISTEN      -                   
	tcp6       0      0 :::48771                :::*                    LISTEN      -                   
	tcp6       0      0 :::46184                :::*                    LISTEN      1496/rpc.statd      
	tcp6       0      0 :::3306                 :::*                    LISTEN      5761/mysqld         
	tcp6       0      0 :::111                  :::*                    LISTEN      1/systemd           
	tcp6       0      0 :::20048                :::*                    LISTEN      1951/rpc.mountd     
	tcp6       0      0 :::22                   :::*                    LISTEN      1406/sshd

关闭mysql

[root@localhost mysql]# /etc/init.d/mysqld stop

[root@localhost mysql]# service mysqld stop

而命令只能kallall service关闭服务或指定kill pid

[root@localhost mysql]# killall mysqld
[root@localhost mysql]# 171214 12:42:59 mysqld_safe mysqld from pid file /data/mysql/localhost.localdomain.pid ended

	[1]+  Done                    /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql --datadir=/data/mysql
[root@localhost mysql]# !ps
	ps aux | grep mysql
	root       5792  0.0  0.0 112660   976 pts/1    S+   12:43   0:00 grep --color=auto mysql

若关闭mysql时发现kill不掉时，这时候很有可能数据量大的mysql正在写入磁盘，不要轻易使用kill -9，否则会损坏mysql表

其它

  • mysql的引擎

innodb和myisam

转载于:https://my.oschina.net/u/3892756/blog/3069274

chouduan9798
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
【CentOS 7LAMP架构1】，LAMP模式介绍与MySQL安装与配置#171214
weixin_34101784的博客
12-14 176
2019独角兽企业重金招聘Python工程师标准>>> ...
mysql43655_关于mysql不能启动的一个案例解决
weixin_42491621的博客
01-20 439
130319 20:00:13 mysqld startedInnoDB: The first specified data file ./ibdata1 did notexist:InnoDB: a new database to be created!130319 20:00:14 InnoDB: Setting file./ibdata1 size to 10 MBInnoDB: Dat...
centos7安装LAMP
不知名白帽的博客
07-21 2326
一、apache的安装；二、安装Apache；三、安装php；四、修改http服务端口；五、docker的搭建
centos-LAMP搭建与配置（论坛网站）
十一、的博客
12-11 626
LAMP是指一组通常一起使用来运行动态网站或者服务器的自由软件名称首字母缩写：Linux操作系统，网页服务器Apache，数据库管理系统MySQL，脚本语言PHP、Perl或Python。由于这些开放源代码程序本身并不是专门设计成同另几个程序一起工作的，但由于它们的廉价和普遍，这个组合开始流行（大多数Linux发行版本捆绑了这些软件）。当一起使用的时候，它们表现的像一个具有活力的“解决方案包”（Solution Packages）。
【CentOS】Linux CentOS7 配置LAMP环境
qq_25285531的博客
12-11 1376
Linux CentOS7 配置LAMP环境
Centos7#基础架构之LAMP架构
kakaops_qing的博客
10-27 452
LAMP 即 Linux+Apache+Mysql/MariaDB+Perl/PHP/Python的首字母缩写
《CentOS 7 搭建LAMP环境》
weixin_47118413的博客
01-24 6035
Linux7搭建LAMP（Linux+Apache+Mysql+PHP）环境
centos7搭建LAMP环境
老徐的博客只有干货
02-17 2528
说明 LAMP相信大家都很熟悉了，就是在Linux系统上面搭建Apache+MySQL+PHP的运行环境。 搭建的方式有很多种，例如：宝塔面板、LAMP一键安装程序等。作为一名研发人员我还是选择手动挨个安装的方式，一方面也是为了熟悉使用各个组件的安装和维护吧，最好是做到知其然、知其所以然。我想本着这个目标去搞技术才会有快速进步。话不多说，下面开干。 安装apache 安装 yum install httpd 设置开机启动 systemctl enable httpd 启动apache systemctl
CentOS7.4 系统安装配置LAMP(Apache+PHP5+MySQL)服务器环境
doubleface999的博客
11-02 3143
很久前转了篇CentOS6.5安装LAMP的文章，很多年没搞了，CentOS版本已经到7.4了，今天在CentOS7.4上安装LAMP，参考之前转的文章，才发现很多知识已经变了，CentOS7相比CentOS6改动很大，但是开始的是我觉得都是往好的方向改 准备篇： 1、配置防火墙，开启80端口、3306端口 CentOS7是用firewalld管理防火墙，和以前iptables的
CentOS 7 搭建 LAMP 环境与配置
01-09
CentOS 7 搭建 LAMP 环境与配置介绍LAMP 架构介绍安装与配置安装 Apache安装阶段配置阶段安装 MySQL安装阶段安装 PHP安装阶段MySQL 导入数据库文件导入数据库方法一：MySQL 命令方法二：source 命令 介绍 该博文将...
CentOS6.6安装配置LAMP服务器（ApachePHP5MySQL）
07-23
资源名称：CentOS 6.6安装配置LAMP服务器(Apache PHP5 MySQL)资源截图： 资源太大，传百度网盘了，链接在附件中，有需要的同学自取。
CentOS 6.6安装配置LAMP服务器(Apache+PHP5+MySQL)
01-20
CentOS 6.6系统安装配置图解教程 //www.jb51.net/os/239738.html 1、配置防火墙，开启80端口、3306端口 vi /etc/sysconfig/iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT -A INPUT -...
CentOS 6.4安装配置LAMP服务器(Apache+PHP5+MySQL)
01-10
1、配置防火墙，开启80端口、3306端口vi /etc/sysconfig/iptables-A INPUT -m state –state NEW -m tcp -p tcp –dport 80 -j ACCEPT #允许80端口通过防火墙-A INPUT -m state –state NEW -m tcp -p tcp –dport ...
centos7搭建LAMP
m0_48096446的博客
03-30 772
保存并退出，然后在浏览器中访问http://服务器IP地址/test.php，如果能看到PHP信息页面，则表示LAMP环境已经搭建完成。安装过程中需要设置root用户密码，以及是否删除测试数据库和禁止远程root登录等。Apache HTTP Server: Web服务器。2.安装Apache HTTP Server。MySQL/MariaDB: 数据库服务器。3.安装MySQL/MariaDB。
linux安装达梦数据库
HAN_789的博客
08-19 203
如果无法创建dmdba 文件夹，需要进入root用户下 在管理员用户下，这种安装方式一般只用于验证，开发，测试，生产最好还是安装传统的方式安装。在 home/dmdba/dmdbms/bin 目录下执行。（1）将文件上传到 /home/dmdba/ 目录下。（2）加压：tar -xzvf dmdb.tar.gz。进入到root就可以创建dmdba 文件夹了。1、后台启动，一般建议用后台启动。
macOS M1Pro 安装 chntpw 工具
最新发布
JakeMa1024的博客
08-20 230
chntpw工具是用来修改位于boot.wim文件第一个索引（或分区）中的注册表。在macOS中安装 Windows虚拟机的时候一般会用到我们采用Homebrew来安装chntpw，需要确保电脑上已经安装好Homebrew。因为Homebrew无法在核心仓库中找到chntpw，所以无法直接通过安装，需要使用tap（第三方仓库）或自定义的 Homebrew 来安装。
Linux网络设置
Lwc1027的博客
08-18 1206
根据pid查询5、查看端口查看网络配置的几个命令又ifconfig、hostname、route、netstat、ss，可以查看网卡，路由表还有统计信息，可以直接指定查询需要的指令。
如何备份Linux整个系统
ithongchou的博客
08-16 150
备份整个 Linux 系统是确保数据安全的重要步骤。你可以使用多种方法来实现这一目标，包括使用系统自带工具、第三方备份软件以及专业的备份解决方案。选择适合你的需求和环境的备份方案可以帮助你有效地备份和恢复 Linux 系统。是一种常用的文件同步工具，可以进行增量备份，比较适合定期备份。: 一个开源的磁盘克隆和备份工具，支持多种文件系统和磁盘格式。是一个低级别的磁盘复制工具，可以创建整个磁盘的镜像。: 一个企业级备份解决方案，提供强大的备份和恢复功能。: 支持加密和增量备份的工具。
CentOS下LAMP架构配置全攻略
"LAMP网站架构方案+安装配置详解" LAMP架构是一种常见的Web开发和部署环境，由Linux操作系统、Apache网络服务器、MySQL数据库管理系统以及PHP编程语言组成。这种架构因其开源、免费、高效和跨平台的特性，在全球...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值