第三章：mysql安装和postgresql安装mysql安装下载mysqlcd/usr/local/srcwgethttps://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64。tar.gztar-zxvfmysql-5.7.18-linux-glibc2.5-x86_64.tar.gzmvmysql-5.7.18-linux-glibc2.5-x86_64/usr/local/mysql创建mysql用户组addmysqluseradd-r-gmysqlmysql初始化数据库cd/usr/local/mysqlmkdirdatachwon-Rmysql:mysqldatabin/mysqld--initialize--user=mysql--datadir=/usr/local/mysql/data#记录初始化数据库的root用户密码#你也可以使用以下命令。两者的区别是一个有初始化密码，一个没有bin/mysqld--initialize-insecure--user=mysql--datadir=/usr/local/mysql/data配置启动信息vi/etc/my.cnf#修改配置如下图：#保存退出cp-asupport-files/mysql.service/etc/init.d/mysqldchmod+x/etc/init.d/mysqld#尝试启动mysql/etc/init.d/mysqldstart#成功如下图：#备注：Mysql启动，重启后有时会报如下错误：mmap(137428992bytes)failed;errno12#错误是mysql启动内存不足导致的。解决方法如下：mkdir-p/var/cache/swap/ddif=/dev/zeroof=/var/cache/swap/swap0bs=1Mcount=512chmod0600/var/cache/swap/swap0mkswap/var/cache/swap/swap0swapon/var/cache/swap/swap0#这样就可以顺利启动mysql数据库#设置swap分区启动:vi/etc/fstab#添加如下代码/var/cache/swap/swap0swapswapdefaults00添加环境变量exportPATH=$PATH:/usr/local/mysql:/usr/local/mysql/binsetstartupchkconfig--addmysqldchkconfigmysqldonmysql相关设置#首次进入需要初始密码:mysql-uroot-p#初始root密码mysql>设置密码=密码('');#设置密码为空mysql>usemysql;mysql>updateusersethost='%'whereuser='root';#修改hostmysql>selectuser,hostfromuser;#查看修改结果mysql>flushprivileges;#Refreshsettingsmysql>exit#Exit#在本地进行连接测试，结果如下：#安装成功mysql安装摘要安装包存放点：/usr/local/src/mysql配置文件：/etc/my.cnfmysql数据信息目录：/usr/local/mysql/data/mysql日志文件：/var/log/mariadb/mariadb.logmysqlpid文件：/var/run/mariadb/mariadb.pid（这个写在配置文件里，其实就是主要是根据服务器生成的具体文件，可以通过psaux|grepmysql查看）进入mysql数据库：mysql（无密码）mysql-u用户名-p用户密码（有密码）打开mysql：服务mysqldstartsystemctl启动mysqld关闭mysql：servicemysqldstopsystemctlstopmysqldrestartmysqlservicemysqldrestartsyatemctlrestartmysqldmysqlstatusservicemysqldstatussyatemctlstatusmysqldpostgresqlinstalldownloadpostgresqlcd/usr/local/srcwgethttps://ftp.postgresql.org/pub/source/v10.1/postgresql-10.1.tar.gztar-zxvfpostgresql-10.1.tar.gzpostgresql编译安装cd/postgresql-10.1./configuremake&&makeinstalladdpostgresuseradduserpostgresinitializepostgresqldatabasecd/usr/local/pgsqlmkdirdatamkdirlogstouchlogs/pgsql。log#设置postgres数据信息和日志权限chown-Rpostgres:postgresdatachown-Rpostgres:postgreslogs#初始化postgresqlbin/initdb-D/usr/local/pgsql/data#Executebin/pg_ctlstart-D/usr/local/pgsql/data-l/usr/local/pgsql/logs/pgsql.log#启动成功，出现如下信息waitingservertostart....doneserverstartedintopostgresqldatabasebin/psqlpostgres=#\l#查看数据库informationpostgres=#\du#查看用户信息postgres=#CREATEDATABASEroot;#创建root数据库postgres=#\l#查看创建结果postgres=#CREATEROLErootSUPERUSER#创建root超级用户postgres=#ALTERROLErootLOGIN#设置root用户登录权限postgres=#\du#查看创建结果退出postgresql数据库修改postgresql配置文件su-rootcp/usr/local/src/postgresql-10.1/contrib/start-scripts/linux/etc/init.d/postgresqlvi/etc/init.d/postgresqlchmod+x/etc/init.d/postgresql设置如下信息：保存退出，测试以下命令：/etc/init.d/postgresqlstop/etc/init.d/postgresqlstart/etc/init.d/postgresqlrestart使用root用户进入postgresql数据库/usr/local/pgsql/bin/psql。效果如下：Postgresql安装成功。配置环境变量cd/etc/profileexportPATH=$PATH:/usr/local/pgsql/binconfigurationstartchkconfig--addpostgresqlchkconfigpostgresqlonpostgresqlremoteconnectionvi/usr/local/pgsql/data/postgresql.conf#修改如下:#保存退出vi/usr/local/pgsql/data/pg_hba.conf#修改如下：#保存退出#本地测试结果：#远程连接成功postgresql安装总结安装包存放点：/usr/local/src/postgresql配置文件：/usr/local/pgsql/data/postgresql.conf/usr/local/pgsql/data/pg_hba.conf/etc/init.d/postgresqlpostgresql数据目录：/usr/local/pgsql/datapostgresqllog文件：/usr/local/pgsql/logs/pgsql.logpostgresqlpid文件：/usr/local/pgsql/data/postmaster.pid进入postgresql数据库：psql#配置环境变量/usr/local/pgsql/bin/psql#未配置环境变量startpostgresql/etc/init.d/postgresqlstartservicepostgresqlstartsystemctlstartpostgresqlstoppostgresql/etc/init.d/postgresqlstopservicepostgresqlstopsystemctlstoppostgresqlrestartpostgresql/etc/init.d/postgresqlrestartservicepostgresqlrestartsystemctlrestartpostgresqlinstallphpextension如果之前编译php的时候没有加上--with-pdo-pgsql,--with-pgsql对于这两个模块，我们只需要在php编译文件中编译即可使用postgresqlphp模块#安装pdo_pgsql模块cd/usr/local/src/php-7.2.2/ext/pdo_pgsql//usr/local/php/bin/phpize./configure--with-php-config=/usr/local/php/bin/php-configmake&&makeinstall#安装pgsql模块cd/usr/local/src/php-7.2.2/ext/pgsql//usr/local/php/bin/phpize./configure--with-php-config=/usr/local/php/bin/php-configmake&&makeinstallservicephp-fpmrestart#重启phpphp-m#查看模块列表查看phpinfo()结果如下：安装成功其他文章第一章：环境配置与nginx安装第二章：PHP安装第四章：Python环境配置
