p.s.因为mysql被oracle收购后,原作者担心mysql闭源,所以又写了一个mariadb,这个数据库可以理解为mysql的分支。
卸载mariadb才能安装mysql。
卸载mariadb的方法:
#列出所有被安装的rpm package rpm -qa | grep mariadb #逐个删除每一个列出来的文件,--nodeps强制删除 rpm -e --nodeps mariadb- libs-************.x86_64
# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm # rpm -ivh mysql-community-release-el7-5.noarch.rpm # yum install mysql-community-server
安装Apache, PHP, MySQL以及php连接mysql库组件。
yum -y install httpd php mysql mysql-server php-mysql CentOS 7.0 yum安装Apache、PHP和MySQL
安装apache扩展
yum -y install httpd-manual mod_ssl mod_perl mod_auth_mysql CentOS 7.0 yum安装Apache、PHP和MySQL
安装php的扩展
yum -y install php-gd php-xml php-mbstring php-ldap php-pear php-xmlrpc CentOS 7.0 yum安装Apache、PHP和MySQL
安装MySQL的扩展
yum -y install mysql-connector-odbc mysql-devel libdbi-dbd-mysql CentOS 7.0 yum安装Apache、PHP和MySQL
配置开机启动服务
#/sbin/chkconfig httpd on [设置apache服务器httpd服务开机启动] #/sbin/service httpd start [启动httpd服务,与开机启动无关] #/sbin/service mysqld start [启动mysqld服务,与开机启动无关]
说明:
apache的配置文件是/etc/httpd/conf下modules放在/usr/lib/httpd下php的配置文件在/etc/php.d/下 和/etc/php.iniphp的modules放在/usr/lib/php/modules下 CentOS 7.0 yum安装Apache、PHP和MySQL
绑定域名
在/etc/httpd/conf/httpd.conf配置文件中,提供了范例: # # VirtualHost example: # Almost any Apache directive may go into a VirtualHost container. # The first VirtualHost section is used for requests without a known # server name. # #<VirtualHost *:80> # ServerAdmin webmaster@dummy-host.example.com # DocumentRoot /www/docs/dummy-host.example.com # ServerName dummy-host.example.com # ErrorLog logs/dummy-host.example.com-error_log # CustomLog logs/dummy-host.example.com-access_log common #</VirtualHost> 所以绑定域名可以跟着提供的范例来配置即可。
说明:
MySQL默认安装的后,root密码为空.
systemctl start httpd.service #启动apache(后面的.service省略也行) 或者是:service httpd start systemctl stop httpd.service #停止apache 或者是:service httpd stop systemctl restart httpd.service #重启apache 或者是:service httpd restart systemctl enable httpd.service #设置apache开机启动 或者是:service httpd enable
systemctl enable mysqld #开机启动 或者: service mysql enable systemctl start mysqld #启动服务 或者: service mysql start systemctl restart mysqld #重启服务 或者: service mysql restart systemctl stop mysqld #停止服务 或者:service mysqld stop
初次安装mysql是root账户是没有密码的
设置密码的方法
1
2
3
|
# mysql -u root mysql> set password for root@localhost = password ( ‘123456‘ ); //这里注意自己替换密码 mysql> exit |
创建一个可以从任何地方连接服务器的一个完全的超级用户,但是必须使用一个口令
1
|
mysql> grant all privileges on *.* to user @localhost identified by ‘123456’ |
CentOS 7.0 yum安装Apache、PHP和MySQL
原文:https://www.cnblogs.com/pebblecome/p/14314881.html